Re: Help on Rman Restore
- From: "Nagaraj S" <nagaraj.chk@xxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxx
- Date: Thu, 27 Nov 2008 00:58:55 +0530
Hi,
I tried the restore in nocatalog mode and follow the below note. It is
successful.
Note 403883.1 Title: How To Restore Controlfile From A Backupset Without A
Catalog Or Autobackup
Regards,
Nagaraj.
On Mon, Nov 24, 2008 at 10:19 PM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx>wrote:
> 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 <mark.bobak@xxxxxxxxxxxxxxx>
> www.proquest.com
> 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:
