RE: Steps to Upgrade Rman Catalog Database.

Dhan,

It might be a better idea to simply create a new Oracle user in the database where the existing rman catalog exists and create a new 10.2.0.4 catalog. We do this here.

We have one "repository" database (called repo) that holds all of our general-usage catalog schemas. In it, we have a 9.2, 10.2.0.2 and 10.2.0.3 Rman catalogs. Each individual database then simply connects to the correct catalog.

Each Rman catalog is relatively small.

Hope this helps.

Tom

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Shanmugam, Dhandapani
Sent: Monday, September 22, 2008 5:07 PM To: oracle-l_at_freelists.org
Subject: Steps to Upgrade Rman Catalog Database.

We have created a new Oracle 10.2.0.3 rman recovery catalog which works fine with our Oracle 9 and 10 (10.2.0.3) databases on Solaris Server

Problem is that I also just created a new installation of Oracle 10.2.0.4 on a new Solaris server but I can't seem to register my new database from this server. I get the following message when I connect from the 10.2.0.4 client to the 10.2.0.3 RMAN catalog database:

$ rman target sys/$SYS catalog rman/xxxxxxx_at_ccrcat

Recovery Manager: Release 10.2.0.4.0 - Production on Tue May 27 09:50:14 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ASCT (DBID=2479914243) connected to recovery catalog database
PL/SQL package RMAN.DBMS_RCVCAT version 10.02.00.03 in RCVCAT database is not current
PL/SQL package RMAN.DBMS_RCVMAN version 10.02.00.03 in RCVCAT database is not current

From metalink i understood that
RMAN catalog schema version should be atleast equal to or greater than its target database. So yes upgrade to 10.2.0.4 According to this metalink note: RMAN Compatibility Matrix Doc ID: Note:73431.1 ,
My question is what are the steps I need to follow for upgrading catalog database. Also i have installed 10.2.0.4 oracle software on rman catalog database server.Kindly advice on this

Thanks and Regards,
Dhan

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 23 2008 - 07:20:47 CDT