Home » RDBMS Server » Backup & Recovery » Restore old Rman Level 0 backup (10.2.0.2,AIX5L)
Restore old Rman Level 0 backup [message #393364] Sun, 22 March 2009 03:08 Go to next message
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
Re: Restore old Rman Level 0 backup [message #393383 is a reply to message #393364] Sun, 22 March 2009 07:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Restore old Rman Level 0 backup [message #393403 is a reply to message #393364] Sun, 22 March 2009 10:29 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You could CATALOG the backup on the TEST database to tell the controlfile about the backup.
Re: Restore old Rman Level 0 backup [message #393863 is a reply to message #393383] Tue, 24 March 2009 13:56 Go to previous messageGo to next message
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
Re: Restore old Rman Level 0 backup [message #393864 is a reply to message #393863] Tue, 24 March 2009 14:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Restore old Rman Level 0 backup [message #393910 is a reply to message #393863] Tue, 24 March 2009 20:46 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: Restore old Rman Level 0 backup [message #393918 is a reply to message #393364] Tue, 24 March 2009 23:02 Go to previous message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
You are right! Catalog is still required.
Previous Topic: rman backup command concepts
Next Topic: RMAN Archive Backups
Goto Forum:
  


Current Time: Wed Dec 07 16:28:12 CST 2016

Total time taken to generate the page: 0.05254 seconds