OraFAQ Forum: Backup & Recovery » rman restore/recovery to previous cold backups

Home » RDBMS Server » Backup & Recovery » rman restore/recovery to previous cold backups (oracle 11g / Solaris 10)

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

rman restore/recovery to previous cold backups [message #593010]

Tue, 13 August 2013 09:46

smac
Messages: 16
Registered: August 2013

Junior Member

My scenario is:
database is in archivelog mode.
I run DLY cold backups including controlfile & archivelogs and keep 3 gens of backups and archivelogs to 3 days also.
What is the correct procedure to restore back to an old cold backup.
Database is backed up Mon,Tue,Wed on Thur we require to bring database back to Tuesday DLY security.

I have tried:
startup mount
restore database from tag 'DLYTUE'
recover database

( this just rolls forward on all archive logs once it restores datafiles, not getting to point to alter database open resetlogs.)

Next tried to :

recover database archivelog tag 'DLYTUE'
( same outcome )

What is the correct rman procedure including should I remove old archive logs from working OS directory ?
Aslo need to know once I restore back and open database to TUE security how do you tidy up the archive logs and dumps which are no longer require ie: weds..

I have read about using the set until time option but how to I get obsolute time from when cold backup completed if this is the correct procedure.

thanks

Report message to a moderator

Re: rman restore/recovery to previous cold backups [message #593013 is a reply to message #593010]

Tue, 13 August 2013 09:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>What is the correct procedure to restore back to an old cold backup.

Testing, testing, testing & actually documenting what works!

With a correct & complete cold backup, after the file restore is completed then all that is required is STARTUP.
The database won't know that it is actually a copy or what was done after the previous SHUTDOWN IMMEDIATE

Report message to a moderator

Re: rman restore/recovery to previous cold backups [message #593014 is a reply to message #593010]

Tue, 13 August 2013 09:53

John Watson
Messages: 8961
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and PLEASE read How to use [code] tags and make your code easier to read

Set the UNITL TIME to what date/time you want to restore and recover up to, and RMAN will work out the rest.

Report message to a moderator

Re: rman restore/recovery to previous cold backups [message #593095 is a reply to message #593013]

Wed, 14 August 2013 02:02

smac
Messages: 16
Registered: August 2013

Junior Member

Not really useful Black Swan, its through testing testing testing I have come to forums for an answer and if it was as simple as just startup i would not be looking for advice from senior DBA's, but thanks for trying.

Report message to a moderator

Re: rman restore/recovery to previous cold backups [message #593097 is a reply to message #593014]

Wed, 14 August 2013 02:04

smac
Messages: 16
Registered: August 2013

Junior Member

John my next test is using the UNTIL TIME and then just calling restore database / recover database and letting RMAN do the hard work, BUT how do you find the obsolute time from when cold backup completed or do you work from start of cold backup ?
If you can expand on this it would be very useful.
thanks

Report message to a moderator

Re: rman restore/recovery to previous cold backups [message #593100 is a reply to message #593097]

Wed, 14 August 2013 02:18

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you want to just restore the cold backup you don't need to recover and until time: just restore and open resetlogs.

If you want to restore and recover to another time than the backup, you have to set UNTIL TIME/SEQUENCE/SCN. You can find the SCN with the LIST BACKUP command.

Regards
Michel

Report message to a moderator

Re: rman restore/recovery to previous cold backups [message #593102 is a reply to message #593097]

Wed, 14 August 2013 02:41

John Watson
Messages: 8961
Registered: January 2010
Location: Global Village

Senior Member

smac wrote on Wed, 14 August 2013 08:04

John my next test is using the UNTIL TIME and then just calling restore database / recover database and letting RMAN do the hard work, BUT how do you find the obsolute time from when cold backup completed or do you work from start of cold backup ?
If you can expand on this it would be very useful.
thanks

Surely your business requirement is to restore/recover the database to the state it was in at a particular time? When your backup was accomplished is irrelevant to this. If you are not concerned with any particular time, then Michel and BS have already answered. But their technique will not work when you make open backups.

Report message to a moderator

Re: rman restore/recovery to previous cold backups [message #593104 is a reply to message #593102]

Wed, 14 August 2013 02:56

smac
Messages: 16
Registered: August 2013

Junior Member

Guy's, I am confused not.
When I run my cold backups including archivelogs it gives me options to either retore back to the cold backup or restore and rollforward to a point in time.
If I just want to go back to the cold backup point is it correct then I just call:
startup mount
restore datbase from tag 'DLYTUE'
shutdown immediate
startup

Not sure john on your statement with this will not work with open backups

I think maybe I am causing problems as I tried to call recover database until cancel from RMAN rather than SQL.
If I do this then CANCEL I should be able to '.... open resetlogs' from SQL.

[Updated on: Wed, 14 August 2013 03:48]

Report message to a moderator

Re: rman restore/recovery to previous cold backups [message #593119 is a reply to message #593104]

Wed, 14 August 2013 04:47

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

startup mount;
restore database from tag 'DLYTUE';
alter database open resetlogs;

Regards
Michel

[Edit: typo]

[Updated on: Wed, 21 August 2013 08:27]

Report message to a moderator

Re: rman restore/recovery to previous cold backups [message #593852 is a reply to message #593119]

Wed, 21 August 2013 08:26

maksydba
Messages: 1
Registered: August 2013
Location: Bangladesh

Junior Member

thanks

Report message to a moderator

Previous Topic:	unrecognised punctuation symbol
Next Topic:	LRM-00101: unknown parameter name 'partition_options'

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 16:02:05 CST 2024