RMAN catalog full resync fails with ORA-02290
Problem
Having registered an Oracle 11.2.0.2 database successfully with an Oracle RMAN 11.1.0.7 recovery catalog, I initiated a backup.
RMAN subsequently performed an implicit resync of the recovery catalog with the target database’s controlfile which failed to the following error(s).
*********************************************************************** starting full resync of recovery catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03008: error while performing automatic resync of recovery catalog ORA-02290: check constraint (RMAN11G.RT_C_STATUS) violated ************************************************************************
Solution
The solution is to upgrade the RMAN recovery catalog schema to 11.2.0.2. This is required by the RMAN client and can be achieved by executing the following command at the RMAN prompt, once connected to the catalog database:
$ rman catalog rman11g/rman11g@rmancat Recovery Manager: Release 11.2.0.2.0 - Production on Wed Sep 14 07:45:56 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to recovery catalog database RMAN> upgrade catalog; recovery catalog owner is RMAN11G enter UPGRADE CATALOG command again to confirm catalog upgrade RMAN> upgrade catalog; recovery catalog upgraded to version 11.02.00.02 DBMS_RCVMAN package upgraded to version 11.02.00.02 DBMS_RCVCAT package upgraded to version 11.02.00.02
N.B.
You will notice, to confirm your action, Oracle prompts for the “upgrade catalog” command to be entered twice before upgrading the schema.
Oracle Doc ID: 1331611.1 suggests that the issue is caused by patch for Bug 9044053. I do not have patch 9044053 applied to the target database and the platform is Linux (OEL) not Windows.
