RE: Help on Rman Restore
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 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_at_proquest.com<mailto:mark.bobak_at_il.proquest.com> www.proquest.com<http://www.proquest.com> www.csa.com<http://www.csa.com>
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Allen, Brandon Sent: Monday, November 24, 2008 11:08 AM To: nagaraj.chk_at_gmail.com; oracle-l_at_freelists.org 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.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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.
http://www.freelists.org/webpage/oracle-l Received on Mon Nov 24 2008 - 10:49:01 CST