OraFAQ Forum: Backup & Recovery » Restore database Until Time: possibility

Home » RDBMS Server » Backup & Recovery » Restore database Until Time: possibility (Oracle 9.2.0.6.0 on windows / Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Restore database Until Time: possibility [message #426886 is a reply to message #426876]

Tue, 20 October 2009 03:50

Michel Cadot
Messages: 68645
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

Report message to a moderator

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

Report message to a moderator