The following is an example of restoring a database to a point-in-time based on the dump database dates and times.
Date |
Dump time |
Type of dump |
|---|---|---|
Aug 14 |
11:04 AM |
database dump |
12:20 PM |
transaction dump |
|
2:20 PM |
transaction dump |
|
7:00 PM |
transaction dump |
|
Aug 17 |
9:00 AM |
transaction dump |
9:00 AM |
transaction dump |
|
2:16 PM |
transaction dump |
|
Aug 23 |
10:27 AM |
database dump |
2:00 PM |
transaction dump |
|
9:30 PM |
transaction dump |
|
Sep 28 |
8:00 AM |
transaction dump |
9:00 AM |
transaction dump |
|
12:14 PM |
transaction dump |
sybrestore prompts you to select a range of time based on the database dump history.
For example, based on the information in the above table, you see:
1 : [Aug 23 2012 10:27:45:206AM, Sep 28 2012 12:14:50:063PM] 2 : [Aug 14 2012 11:04:58:330AM, Aug 17 2012 2:16:17:206PM]
You can select a time range by entering the list number. For
example, enter 2 for the time
range [Aug 14 2012 11:04:58:330AM, Aug 17 2012 2:16:17:206PM].
Next, enter a time that falls between Aug 14 2012 11:04:58:330AM and Aug 17 2012 2:16:17:206PM. For example, enter:
Aug 16 2012 10:00 A.M
