RMAN catalog Recreation Problems/Questions ....

!! Please do not post Off Topic to this List !!

Dear List,

I have Production DB in 8.1.6.2.0(64bit) on one box, and RMAN catalog database
(8.1.6.2.0) on another box. I need to upgrade both the DBs to 8.1.7.1.0. I have
no problem upgrading the production DB to 8.1.7.0.0 and the to 8.1.7.1.0 patch
level.  

The box on which catalog DB exists has another production DB which was upgraded
to 8.1.7.1.0. and so I CAN NOT upgrade catalog DB to 8.1.7.1.0 using normal upgrade procedure. I must upgrade to base line release first(8.1.7.0.0) and then patch needs to be applied. Since patch was already applied, my only option
could be to recreate the catalog database in 8.1.7.1.0 and then DO THE FULL IMPORT. My questions would be:

[1] Do I need to do the FULL IMPORT of the catalog database? and then issue
the
"upgrade catalog" command twice to upgrade the catalog to work with the latest
RMAN version? [OR]

[2] Do I just recreate the empty catalog DB in 8.1.7.1.0 and then follow the

regular procedure to create RMAN schema and register the DB and then take the
fresh cold backup to start with, followed by the regular daily incremental backups?

[3]If I follow [2], I may loose the catalog info for 8.1.6.2.0. backups. Is
the
8.1.6.2.0 catalog data useful after upgrading the DB to 8.1.7.1.0?

Could someone Please answer my above questions and suggest an appropriate procedure to
upgrade the catalog DB to 8.1.7.1.0.

• Janardhana Babu

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janardhana Babu
  INET: jbdonga_at_ucdavis.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).