RE: How to UPGRADE CATALOG in RMAN after post release upgrade?

Ananth,  

My guess is that you would run the Rman executable out of the 10.2.0.3 Oracle home connecting to the existing catalog, and then issue the UPGRADE CATALOG command. But that is just a guess.  

A caution though - if you do this, your existing Rman backups for other 10.2.0.1 databases may not work. You need to test this!  

I would test by creating a new 10.2.0.3 rman catalog and registering some of the older databases in it. If they register ok, then you should not have a problem, and you could go ahead and upgrade your existing catalog.  

You will probably be ok. The Rman catalog is pretty stable - no changes between releases (especially between the releases that you are going thru). We are running two rman catalogs (9.2.0.7 & 10.2.0.2) in a 9.2.0.7 database with no problems at all.  

Good Luck!  

Tom

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Shastry(DBA) Sent: Thursday, December 27, 2007 7:35 AM To: oracle-l
Subject: How to UPGRADE CATALOG in RMAN after post release upgrade?

Hi Gurus,

We have upgraded the PROD from 10.2.01 to 10.2.0.3 <http://10.2.0.3/> and we are at the stage where oracel is asking for RMAN catalog upgrade as we are using RMAN for backup purpose How to do this basically?
If we do Catalog upgrade,Will this affect to other RMAN backups? we are using common catalog for many prod databases backup.

I am looking for some light...like whether can we upgrade and how to do so....
Will this affect other RMAN backups?

But I see the Oracle upgrade readme says the below information, but doesn't say how to do it exactly.

If you are using the Oracle Recovery Manager catalog, enter the following command:

$ rman catalog username/password_at_alias

RMAN> UPGRADE CATALOG; If you are using the Oracle Recovery Manager catalog, enter the following command:

$ rman catalog username/password_at_alias

RMAN> UPGRADE CATALOG; Can anyone please help me out on this as I am not aware much on RMAN?

Thanks,
Ananth

--
http://www.freelists.org/webpage/oracle-l