RE: Help on Rman Restore

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
  • To: "Brandon.Allen@xxxxxxxxxxx" <Brandon.Allen@xxxxxxxxxxx>, "nagaraj.chk@xxxxxxxxx" <nagaraj.chk@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 24 Nov 2008 11:49:01 -0500

Actually, Brandon, a read of the original posting shows that he did, in fact, 
unregister the old database from the old catalog, "As part of it, I have 
unregistered the production database on rman catalog on server A and I have 
changed my database DBID using NID tool in server B and registered with new 
DBID to the catalog database."

So, that explains why he can't find anything under the old DBID.  As Brandon 
mentioned, you'll need to restore the catalog database and recover to a point 
in time from before you unregistered the old DB.

-Mark
--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxx<mailto:mark.bobak@xxxxxxxxxxxxxxx>
www.proquest.com<http://www.proquest.com>
www.csa.com<http://www.csa.com>

ProQuest...Start here.

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Allen, Brandon
Sent: Monday, November 24, 2008 11:08 AM
To: nagaraj.chk@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Help on Rman Restore

I don't understand why you changed the dbid to begin with but I guess it's a 
bit late for that question.  How are you querying the rman catalog when trying 
to find info on the old dbid?  You might need to use the "set dbid" command 
first if you're going through rman, or if you're just querying via sql*plus and 
the data isn't there in, for example, rc_database, then maybe someone already 
unregistered the old database and deleted all the old backup information 
associated with it, in which case you'll probably want to try restoring an old 
copy of your recovery catalog from before that was done.

Regards,
Brandon


From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Nagaraj S

Also when i queried on rman catalog I could not found the old DBID information


________________________________
Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.

Other related posts: