RE: RMAN repository error - ORA-02290 on RT_C_STATUS
- From: Lou Avrami <avramil@xxxxxxxxxxxxxx>
- To: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxx>,"oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 07 Jun 2011 16:26:08 -0400 (EDT)
Hey Tom,
Both of the database involved here are 11.2.
The constraint RT_C_STATUS is checking for the values of 'D','E','O' for
STATUS, the same as for 9.2.
The logical assumption would be that something is trying to insert an record
with an invalid value ... but I have no explanation why this is occurring.
We've run a couple of weeks of backups on the particular target database and
not encountered issues until now.
"Kosher", indeed. :-)
Lou
> ---- Mercadante, Thomas F (LABOR) <Thomas.Mercadante@xxxxxxxxxxxx> wrote:
> >
> > Lou,
> >
> > I have a 9.2 and 10.2 Rman repositories here.
> >
> > The check constraint you mention exists in the 9.2 repos and it's
> > restrictions are the STATUS column has to have values of ('D','E','O').
> >
> > The 10.2 repository does not have the check constraint but has a
> > differently named one (RT_C1_STATUS) with valid values of ('D','E','O','I').
> >
> > So I'm wondering if the specific database that is having this issue is
> > maybe a 10.2 database using a 9.2 repository attempting to store a value of
> > 'I' in the STATUS column.
> >
> > Just sayin. I can think of several ways to fix this. They may not kosher.
> >
> > But that's just me.
> >
> > Tom
> >
> > -----Original Message-----
> > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> > On Behalf Of Lou Avrami
> > Sent: Tuesday, June 07, 2011 3:19 PM
> > To: oracle-l@xxxxxxxxxxxxx
> > Subject: RMAN repository error - ORA-02290 on RT_C_STATUS
> >
> > 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
> >
> >
> >
> >
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
