生产上的一套 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 |