Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

restore to older dbid

441858Feb 19 2013 — edited Feb 19 2013

Oracle11gR2 RHEL5

I am trying to restore a database to an older DBID and I am trying to figure out the right point to place the 'set dbid <dbid>' command.

Here is the scenario:

Database A is backed up (using recovery catalog) and has a dbid of 565656. Database A is then duplicated (from a recent copy of prod) and it now has a dbid of 787878.

Now we want to restore Database A to its previous backup which has a dbid of 565656. What would be the correct sequence to do this to prevent the 'RMAN-20001: target database not found in recovery catalog' error? At what point would we place the 'set dbid' command?

rman
connect target /
connect catalog rman@catdb
set dbid 565656
shutdown immediate
startup nomount
restore controlfile.....
alter database mount
restore database
...
...

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 19 2013

Added on Feb 19 2013

#performance-availability, #recovery-manager-rman

2 comments

386 views