OraFAQ Forum: Backup & Recovery » Restore old Rman Level 0 backup

Home » RDBMS Server » Backup & Recovery » Restore old Rman Level 0 backup (10.2.0.2,AIX5L)

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

Restore old Rman Level 0 backup [message #393364]

Sun, 22 March 2009 03:08

ravindrapareta
Messages: 2
Registered: March 2009

Junior Member

i have old rman level0 backup(test) and need to store this through RMAN duplicate on DEV1 database.
test database control file file does not have old level0 backup information.

please suggest

Report message to a moderator

Re: Restore old Rman Level 0 backup [message #393383 is a reply to message #393364]

Sun, 22 March 2009 07:26

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

As part of level0 backup of test database, you are supposed to maintain
a controlfile autobackup also.
You can use that.

Report message to a moderator

Re: Restore old Rman Level 0 backup [message #393403 is a reply to message #393364]

Sun, 22 March 2009 10:29

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You could CATALOG the backup on the TEST database to tell the controlfile about the backup.

Report message to a moderator

Re: Restore old Rman Level 0 backup [message #393863 is a reply to message #393383]

Tue, 24 March 2009 13:56

ravindrapareta
Messages: 2
Registered: March 2009

Junior Member

Thanks!
But i need to restore old backup on database dev1 not TEST.
Test database is running fine with current data

Report message to a moderator

Re: Restore old Rman Level 0 backup [message #393864 is a reply to message #393863]

Tue, 24 March 2009 14:10

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>But i need to restore old backup on database dev1 not TEST.
Yes. That is what we were addressing too.
In order to use the backup from TEST, you need to make the control file understand that it has a level0 backup.
quoting EBrian,
>>You could CATALOG the backup on the TEST database to tell the controlfile about the backup.

Report message to a moderator

Re: Restore old Rman Level 0 backup [message #393910 is a reply to message #393863]

Tue, 24 March 2009 20:46

alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com

Senior Member

ravindrapareta wrote on Wed, 25 March 2009 02:56

Thanks!
But i need to restore old backup on database dev1 not TEST.
Test database is running fine with current data

You can restore the database to dev server as name TEST, then using NID to change the db name.
Regards,
Alex

[Updated on: Wed, 25 March 2009 02:09] by Moderator

Report message to a moderator

Re: Restore old Rman Level 0 backup [message #393915 is a reply to message #393910]

Tue, 24 March 2009 21:50

ebrian
Messages: 2794
Registered: April 2006

Senior Member

alexzeng wrote on Tue, 24 March 2009 21:46

You can restore the database to dev server as name TEST, then using NID to change the db name.
Regards,
Alex

The OP still needs a way to let the controlfile know about the old backup.

Report message to a moderator

Re: Restore old Rman Level 0 backup [message #393918 is a reply to message #393364]

Tue, 24 March 2009 23:02

alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com

Senior Member

You are right! Catalog is still required.

Report message to a moderator

Previous Topic:	rman backup command concepts
Next Topic:	RMAN Archive Backups

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 13:38:26 CDT 2024