ORA-19633: controlfile record 234 is out of sync with recovery catalog

From: Alexander Skwar <alexander_at_skwar.name>
Date: Wed, 18 Jul 2007 15:40:51 +0200
Message-ID: <6491378.fGlmkVyoaZ@kn.gn.rtr.message-center.info>

Hello.

Oracle 9.2.0.4 on Solaris Sparc.

I played around a bit with RMAN to get a "feeling" for it. I made some backups and also deleted the backup files RMAN had created. I also removed the archived redo log files.

Now I'm trying to have RMAN remove obsolete files from the disks.

RMAN> delete force obsolete redundancy = 2 device type disk; [...]

Backup Set           50     18-JUL-07         
  Backup Piece       268    18-JUL-07          /tmp/backup/cfc-3007484779-20070718-00?;
Backup Set           54     18-JUL-07         
  Backup Piece       272    18-JUL-07          /tmp/sicherung/BNRTEST/c-3007484779-20070718-01.ctl
Backup Set           56     18-JUL-07         
  Backup Piece       274    18-JUL-07          /tmp/sicherung/BNRTEST/c-3007484779-20070718-02.ctl
Backup Set           58     18-JUL-07         
  Backup Piece       276    18-JUL-07          /tmp/sicherung/BNRTEST/c-3007484779-20070718-03.ctl
Backup Set           60     18-JUL-07         
  Backup Piece       278    18-JUL-07          /tmp/sicherung/BNRTEST/c-3007484779-20070718-04.ctl
Backup Set           62     18-JUL-07         
  Backup Piece       280    18-JUL-07          /tmp/sicherung/BNRTEST/c-3007484779-20070718-05.ctl
Backup Set           64     18-JUL-07         
  Backup Piece       282    18-JUL-07          /tmp/sicherung/BNRTEST/c-3007484779-20070718-06.ctl
Backup Set           66     18-JUL-07         
  Backup Piece       284    18-JUL-07          /tmp/sicherung/BNRTEST/c-3007484779-20070718-07.ctl

Do you really want to delete the above objects (enter YES or NO)? yes

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of delete command on ORA_DISK_1 channel at 07/18/2007 15:17:39 ORA-19633: controlfile record 234 is out of sync with recovery catalog

What can I do about ORA-19633? According to the documentation, it seems that there isn't much I can do, is there? I found:

,----[ http://download.oracle.com/docs/cd/B10501_01/server.920/a96525/e19400.htm#1000823 ]
| ORA-19633 controlfile record string is out of sync with recovery catalog
|
| Cause: The control file record describing the file to be deleted in
| a call to deleteBackupPiece, deleteDataFilecopy, proxyDelete
| or deleteArchivedLog does not match the validation data supplied
| by Recovery Manager.
|
| Action: Contact Oracle Support Services.
`----

Well, I'm sort of lost. Gladly this only happened to some test database and not to a production DB.

Thanks for any help,

Alexander Skwar Received on Wed Jul 18 2007 - 08:40:51 CDT