Re: Question about "Upgrade catalog"

From: <mccmx_at_hotmail.com>
Date: 4 Jan 2006 01:24:26 -0800
Message-ID: <1136366666.123566.54560@f14g2000cwb.googlegroups.com>

> Lets say i have a 9.2.0.4 database that i have just upgraded to
> 10.1.0.3. I understand that I need to run "upgrade catalog" in RMAN
> after upgrading databases. But what happens to other 9.2.0.x
> databases that are using the same RMAN catalog? Would it impact other
> databases? Or does "Upgrade catalog" command affect only the
> currently connected target database, never affectng other databaes
> that are sharing the same RMAN catalog? Thank you in advance.

The "upgrade catalog" command will only affect the schema in the RMAN database which contains the catalog for the target database(s). So it depends on whether you use the same catalog schema for all of your databases.

Are you connecting to RMAN with the same catalog user for all of your target databases..?

If so, the "upgrade catalog" command will impact all of them. If not, it will only affect the schema which is used for the upgraded database.

Cheers

Matt Received on Wed Jan 04 2006 - 03:24:26 CST