RMAN>upgrade Catalog Failed with ORA-02292 (Doc ID 1303486.1)

Last updated on APRIL 11, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.2.0.1 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

Upgrade Catalog schema to 11.2 failed with,

RMAN> upgrade catalog;

error creating remove_null_db_unique_name_rows_from_node
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-02292: integrity constraint (RMAN.TSATT_F2) violated - child record found

Or,

error creating remove_null_db_unique_name_rows_from_node
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571:===========================================================
RMAN-6004: ORACLE error from recovery catalog database:
ORA-1: unique constraint (RMAN.SITE_TFATT_P) violated

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms