ORA-19633: controlfile record 234 is out of sync with recovery catalog
Alexander Skwar
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
Alexander Skwar
> What can I do about ORA-19633?
In private mail, it's been suggested to try a "crosscheck backup;" and/or
"crosscheck backup of archivelog all;". I did that and tried to do a
"delete force backupset 16;" afterwards.
Sadly, this did not help at all - I'm still getting ORA-19633 :(
I don't know, is it just me, or is that RMAN thingie incredible fragile?
I've got my doubts if it's wise to trust important information to this
tool... :(
Anyway - is there anything else I could do to fix this problem? Also
I'd be interested in knowing how I exactly got myself into this
situation. It's most certainly because I did something wrong - but what?
Well, thanks anyway,
Alexander Skwar