Re: RMAN
From: joel garry <joel-garry_at_home.com>
Date: Fri, 20 Jan 2012 16:58:56 -0800 (PST)
Message-ID: <0819c94a-4505-4b2c-b1a8-68ce162a8729_at_kg1g2000pbb.googlegroups.com>
On Jan 20, 8:38 am, ExecMan <artme..._at_yahoo.com> wrote:
> Hi,
>
> On Monday we started receiving this error in our backup log:
>
> RMAN-00571:
> ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> ===============
> RMAN-00571:
> ===========================================================
> RMAN-03009: failure of delete command on d4 channel at 01/20/2012
> 02:31:24
> ORA-19633: control file record 6197 is out of sync with recovery
> catalog
>
> We do not use a recovery catalog, we use the control file. Oracle
> has been less than helpful, telling us that the only way to solve this
> bug is to use a recovery catalog. I find that funny as we have 20
> databases, each using their control file, and this is the first time
> it has ever happened.
>
> At any rate, I cannot find a solution. Can anyone help? I'm also
> thinking if I can just delete all the backups, will it clear those
> records from the control file, and I can start with a fresh level 0
> backup.
>
> Thanks!
Date: Fri, 20 Jan 2012 16:58:56 -0800 (PST)
Message-ID: <0819c94a-4505-4b2c-b1a8-68ce162a8729_at_kg1g2000pbb.googlegroups.com>
On Jan 20, 8:38 am, ExecMan <artme..._at_yahoo.com> wrote:
> Hi,
>
> On Monday we started receiving this error in our backup log:
>
> RMAN-00571:
> ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> ===============
> RMAN-00571:
> ===========================================================
> RMAN-03009: failure of delete command on d4 channel at 01/20/2012
> 02:31:24
> ORA-19633: control file record 6197 is out of sync with recovery
> catalog
>
> We do not use a recovery catalog, we use the control file. Oracle
> has been less than helpful, telling us that the only way to solve this
> bug is to use a recovery catalog. I find that funny as we have 20
> databases, each using their control file, and this is the first time
> it has ever happened.
>
> At any rate, I cannot find a solution. Can anyone help? I'm also
> thinking if I can just delete all the backups, will it clear those
> records from the control file, and I can start with a fresh level 0
> backup.
>
> Thanks!
See MOS Bug 6402384: ORA-19633: CONTROL FILE RECORD 765 IS OUT OF SYNC
WITH RECOVERY CATALOG
"Delete and recreate the controlfile which the customer does not want
to do"
It appears the controlfile records for backup pieces are reused before
those of backup sets, allowing duplicate set names.
I notice this is fixed in 10.2.0.5 and 11.1.0.7 patch sets.
What a choice: create a catalog, which would let you fix the
controlfile records through syncronization or re-create the
controlfile, with incarnation issues. Anything else would be scarier.
jg
-- _at_home.com is bogus. http://www.extremetech.com/computing/114803-megauploads-demise-what-happens-to-your-files-when-a-cloud-service-diesReceived on Fri Jan 20 2012 - 18:58:56 CST