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

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <shastry17@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 27 Dec 2007 08:14:32 -0500

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@alias 
RMAN> UPGRADE CATALOG; If you are using the Oracle Recovery Manager
catalog, enter the following command: 

$ rman catalog username/password@alias 
RMAN> UPGRADE CATALOG; 

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

Thanks,
Ananth



Other related posts: