客户数据库在执行RMAN备份时碰到这个错误。
错误信息如下：
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure OF backup command at 03/25/2012 02:31:18 RMAN-00600: internal error, arguments [8201] [] [] [] [] |
根据MOS文档Rman Backup Failed With Error Rman-00600 [8201] [ID 412786.1]描述，导致错误的原因是控制文件中记录的信息和CATALOG中记录的信息出现了不一致的地方。Oracle给出的解决方案是CATALOG的全同步，不过执行RECYNC CATALOG后问题依旧：
RMAN> resync catalog; RMAN> SHOW ALL; RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 45 DAYS; CONFIGURE BACKUP OPTIMIZATION OFF; # DEFAULT CONFIGURE DEFAULT DEVICE TYPE TO DISK; # DEFAULT CONFIGURE CONTROLFILE AUTOBACKUP OFF; # DEFAULT CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # DEFAULT CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # DEFAULT CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # DEFAULT CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # DEFAULT CONFIGURE MAXSETSIZE TO UNLIMITED; # DEFAULT CONFIGURE ENCRYPTION FOR DATABASE OFF; # DEFAULT CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # DEFAULT RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure OF SHOW command at 03/26/2012 10:10:03 RMAN-00600: internal error, arguments [8201] [] [] [] [] |
进一步查询MOS，发现Oracle在Bug 6035495 – ORA-19909 during MRP / RMAN-600 on resync [ID 6035495.8]文档中给出了更详细的描述。这个错误一般都发生在包含备库的情况，确认影响的版本是10.2.0.3，Oracle在10.2.0.4和11.1.0.6中fixed了这个问题。
而解决问题的方法是在备库执行RESET DATABASE命令，而在主库执行控制文件的重建。不过控制文件的重建则意味着停机以及备份信息的丢失，可以考虑暂时通过NOCATALOG方式的备份来避免错误的产生。
Pingback: RMAN-600(8201)错误的重现 | yangtingkun
Pingback: RMAN-600(8201)错误的解决 | yangtingkun
Pingback: 恢复数据库出现ORA-38727 | yangtingkun
Pingback: 恢复导致ORA-600(kccfhb_1)错误 | yangtingkun