Restore database Until Time: possibility [message #426876] |
Tue, 20 October 2009 03:16 |
chetanaZ
Messages: 132 Registered: October 2009 Location: UK
|
Senior Member |
|
|
Hi,
The Oracle Documentation states
Quote:
Note that if you specify a SET UNTIL command after a RESTORE and before a RECOVER, you may not be able to recover the database to the point in time required because the restored files may already have time stamps more recent than the set time. Hence, it is recommended that you specify the SET UNTIL command before the RESTORE command.
Suppose I have taken backup of database and the backup finished at say 17:05:00
Now I have archive logs to apply from 17:05:00 till 18:05:00
Now can I restore database till 16:05:00?
According to my undestanding the minimum timestamp (earliest one) to which I can recover the database is 17:05:00, which is the time backup finished.
In case I want to recover at any stage between 17:05:00 till 18:05:00,I will apply archive logs accordingly
Thus 'Set Until' must not matter for 'Restore' but for 'Recover' since we can rollback hours of data during recover after completing restore till 17:05:00
Please help me in clearing my understanding
Thanks and Regards,
Chetana
|
|
|
|
Re: Restore database Until Time: possibility [message #426889 is a reply to message #426876] |
Tue, 20 October 2009 04:03 |
chetanaZ
Messages: 132 Registered: October 2009 Location: UK
|
Senior Member |
|
|
Thanks Michel,
Does it mean if I had only one backup which finished at 17:05:00, there is no way I can restore to a point before 17:05:00?
And in order to restrore database before 17:05:00, I must have 'another' backup which must have completed before 17:05:00; which can be then recovered to any point after its backup completion time and before 17:05:00 by applying logs?
Thanks and Regards,
Chetana
|
|
|
|
|