This discussion is archived
2 Replies Latest reply: Feb 19, 2013 7:46 PM by Hemant K Chitale RSS

restore to older dbid

441858 Newbie
Currently Being Moderated
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
...
...
  • 1. Re: restore to older dbid
    mseberg Guru
    Currently Being Moderated
    Hello;

    Do a point in time recovery of Database A. Then just change the DBID number. ( DBNEWID utility )

    Restrictions and Usage Notes for the SET DBID Command

    You should only run the SET DBID command in the following specialized circumstances:

    You are not connected to a recovery catalog and want to restore the control file or server parameter file.
    You are connected to a recovery catalog and want to restore the control file, but the database name is not unique in the recovery catalog.
    The server parameter file is lost and you want to restore it.

    Best Regards

    mseberg
  • 2. Re: restore to older dbid
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    You would SET DBID before the RESTORE CONTROLFILE


    Hemant K Chitale

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points