RMAN Upgrade Catalog Bug in 11.2.0.2

RMAN> CONNECT CATALOG *

connected to recovery catalog database

PL/SQL package RMAN.DBMS_RCVCAT version 11.02.00.01 in RCVCAT database is not current

PL/SQL package RMAN.DBMS_RCVMAN version 11.02.00.01 in RCVCAT database is not current

RMAN>

RMAN> **end-of-file**

RMAN> upgrade catalog;

recovery catalog owner is RMAN

enter UPGRADE CATALOG command again to confirm catalog upgrade

RMAN> upgrade catalog;

error creating set_site_key_for_single_site_dbs

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-06004: ORACLE error from recovery catalog database: ORA-00001: unique constraint (RMAN.SITE_TFATT_P) violated

RMAN>

he issue is due to a bad statement in the recover.bsq file and it is addressed as the Bad statement in bug# 10157249.

To fix this issue please do the following:

- From the $ORACLE_HOME of the rman executable used to perform the upgrade of the catalog:

- Make a copy of the $ORACLE_HOME/rdbms/admin/recover.bsq file

- Edit $ORACLE_HOME/rdbms/admin/recover.bsq and change:

update site_tfatt set site_key = onesite_row.site_key where

tf_key in (select tf_key from df, dbinc

where dbinc.dbinc_key = df.dbinc_key

and dbinc.db_key = onesite_row.db_key);

To read:

update site_tfatt set site_key = onesite_row.site_key where

tf_key in (select tf_key from tf, dbinc

where dbinc.dbinc_key = tf.dbinc_key

and dbinc.db_key = onesite_row.db_key);

The sub-query should look for tf_key in TF table (instead of DF table).

- Connect with rman to the catalog database and run the upgrade again.

About these ads

About April C Sims

Oracle DBA for over a decade...enough said.
This entry was posted in Uncategorized and tagged , , . Bookmark the permalink.

3 Responses to RMAN Upgrade Catalog Bug in 11.2.0.2

  1. charlesdschultz says:

    I have a great idea – let’s make 10g stable. End of what support?

  2. Pingback: ORA-02291: integrity constraint (RMAN.RLH_F1) violated « Oracle Blog – Tecnología Informática Buenos Aires

  3. Pingback: ORA-00201: control file version 10.2.0.4.0 incompatible with ORACLE version 10.2.0.3.0 « Oracle Blog – Tecnología Informática Buenos Aires

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s