ORA-02290: check constraint (RMAN_DB1.AL_C_STATUS) violated
89578Jan 2 2004 — edited Jan 2 2004I got the following error when I attempted to reset database after the incomplete recovery.
RMAN> reset database;
new incarnation of database registered in recovery catalog
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 (RMAN_DB1.AL_C_STATUS) violated
RMAN> resync catalog;
starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 01/01/2004 22:54:03
ORA-02290: check constraint (RMAN_DB1.AL_C_STATUS) violated
RMAN> report schema;
starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 01/01/2004 22:54:12
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 01/01/2004 22:54:12
ORA-02290: check constraint (RMAN_DB1.AL_C_STATUS) violated
Does anybody know how to solve this problem?
Thanks