本文详细描述了Oracle 11g物理备库在遇到数据块错误（ORA-10562、ORA-01110）和归档日志应用问题时，如何通过RMAN进行验证、备份、恢复和日志同步等一系列操作，最终成功恢复备库的完整性和功能。
生产上的一套 11G 物理备库出现故障，存放数据文件和归档日志的挂载盘发生故障，导致出现数据块错误。
数据库报警日志中的错误如下：
| ORA-10562: Error occurred while applying redo to data block (file# 28, block# 1336760) ORA-10564: tablespace TS_TRAN_INDEX ORA-01110: data file 28: '/ORADATA/data/GTFDBDG/datafile/o1_mf_ts_tran__9jqlcv5b_.dbf' ORA-10560: block type '0' ORA-00600: internal error code, arguments: [4553], [2], [0], [], [], [], [], [], [], [], [], [] Errors in file /u01/app/oracle/diag/rdbms/gtfdbdg/gtfdb/trace/gtfdb_pr0f_3437.trc: ORA-00338: log 10 of thread 1 is more recent than control file ORA-00312: online log 10 thread 1: '/ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_10_c3l6yy9y_.log' ORA-00338: log 10 of thread 1 is more recent than control file ORA-00312: online log 10 thread 1: '/ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_10_c3l6yxxm_.log' ORA-00607: Internal error occurred while making a change to a data block ORA-00602: internal programming exception ORA-07445: exception encountered: core dump [kdxlin()+4108] [SIGSEGV] [ADDR:0xC] [PC:0x9188AE2] [Address not mapped to object] [] Errors in file /u01/app/oracle/diag/rdbms/gtfdbdg/gtfdb/trace/gtfdb_pr0f_3437.trc: ORA-00338: log 15 of thread 2 is more recent than control file ORA-00312: online log 15 thread 2: '/ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_15_c3l6z47s_.log' ORA-00338: log 15 of thread 2 is more recent than control file ORA-00312: online log 15 thread 2: '/ORADATA/redolog/GTFDBDG/onlinelog/o1_mf_15_c3l6z3vo_.log' Slave exiting with ORA-10562 exception Errors in file /u01/app/oracle/diag/rdbms/gtfdbdg/gtfdb/trace/gtfdb_pr0d_26650.trc: ORA-10562: Error occurred while applying redo to data block (file# 31, block# 1321407) ORA-10564: table |
最低0.47元/天 解锁文章
645
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
