RMAN repository error - ORA-02290 on RT_C_STATUS

  • From: Lou Avrami <avramil@xxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 07 Jun 2011 15:19:27 -0400 (EDT)

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.

Thanks,
Lou Avrami

--
//www.freelists.org/webpage/oracle-l


Other related posts: