RMAN repository error - ORA-02290 on RT_C_STATUS

From: Lou Avrami <avramil_at_concentric.net>
Date: Tue, 07 Jun 2011 15:19:27 -0400 (EDT)
Message-Id: <20110607191927.AF6A33D1_at_swiftsure.cnc.net>

Hi there Oracle-L,

We're getting interesting errors when trying to run RMAN backups against a particular database, involving the repository table RT and the RT_C_STATUS check constraint:

RMAN-03002: failure of allocate command at 06/06/2011 14:12:31
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 06/06/2011 14:12:31
ORA-02290: check constraint (RMANCAT.RT_C_STATUS) violated

This error occurs consistently for just one out of about 100 databases in this RMAN repository database.

Oracle Support suggested running the UPGRADE REPOSITORY comamnd, but that doesn't seem to have worked.

Has anyone encountered previously encountered this problem? Any ideas or suggestions would be appreciated.

Lou Avrami

Received on Tue Jun 07 2011 - 14:19:27 CDT

Original text of this message