You are requested to restore a database (into another one) from RMAN backup on tape which was done 2 month ago. You requested tape from your storage company, you have your backup copied over to your server - if that is your preference. And all of a sudden you realize that DBID has been changed AFTER you took your backup - say your database has been refreshed from production and this is a part of the process.
No problem! Just do that:
Eestore the controlfile, then the backup as follows:
RMAN> startup nomount force;
RMAN> restore controlfile from '/db/backup/MYDB/25jul09/c-3431719427-20090723-00';
RMAN> alter database mount;
This should mount the controlfile with the old DBID
Now you may proceed with the database restore - catalog you backup pieces, run restore & recover, apply archive logs (from the same tape) if necessary...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment