Home » RDBMS Server » Backup & Recovery » Restore database Until Time: possibility (Oracle 9.2.0.6.0 on windows / Linux)
Restore database Until Time: possibility [message #426876] Tue, 20 October 2009 03:16 Go to next message
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 #426886 is a reply to message #426876] Tue, 20 October 2009 03:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It matters on restore if you want to restore datafiles from a date before the last backup. In your example, if you want to recover at 16:05 you have to give UNTIL before restore to tell Oracle to search for previous backup otherwise it will take the last one which is too late.

Regards
Michel
Re: Restore database Until Time: possibility [message #426889 is a reply to message #426876] Tue, 20 October 2009 04:03 Go to previous messageGo to next message
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
Re: Restore database Until Time: possibility [message #426891 is a reply to message #426889] Tue, 20 October 2009 04:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes on all points.

Regards
Michel
Re: Restore database Until Time: possibility [message #426893 is a reply to message #426876] Tue, 20 October 2009 04:41 Go to previous message
chetanaZ
Messages: 132
Registered: October 2009
Location: UK
Senior Member
Many Thanks Michel

Sorry for the delayed reply
I was thinking your 'Yes' is for my points or database restore points Smile

BTW thanks for clearing my understanding

Regards,
Chetana
Previous Topic: 'Recover' Command Not applying archivelogs
Next Topic: Restore backup from another (non-default) location
Goto Forum:
  


Current Time: Mon Nov 04 11:59:35 CST 2024