Thu Sep 15 15:48:44 2011Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/trace/orcl_pr1a_1747.trc (incident=135489):ORA-00600: internal error code, arguments: [3020], [3], [264946], [12847858], [], [], [], [], [], [], [], []ORA-10567: Redo is inconsistent with data block (file# 3, block# 264946, file offset is 2170437632 bytes)ORA-10564: tablespace UNDOTBS1ORA-01110: data file 3: '/data/assyfile/assdata/undotbs01.dbf'ORA-10560: block type 'KTU UNDO BLOCK'Incident details in: /var/local/oracle/diag/rdbms/orcl/orcl/incident/incdir_135489/orcl_pr1a_1747_i135489.trckewastUnPackStats(): bad magic 1 (0x7fff36429606, 0)Errors in file /var/local/oracle/diag/rdbms/orcl/orcl/incident/incdir_135489/orcl_pr1a_1747_i135489.trc:ORA-00339: archived log does not contain any redoORA-00334: archived log: '/var/local/oracle/oradata/orcl/redo03.log'ORA-00600: internal error code, arguments: [3020], [3], [264946], [12847858], [], [], [], [], [], [], [], []ORA-10567: Redo is inconsistent with data block (file# 3, block# 264946, file offset is 2170437632 bytes)ORA-10564: tablespace UNDOTBS1ORA-01110: data file 3: '/data/assyfile/assdata/undotbs01.dbf'ORA-10560: block type 'KTU UNDO BLOCK'
各位大虾: 昨天下午从库的 MRP0 进程突然停掉,从库恢复中断,但是日志还在传送。检查alert日志,发现恢复下面归档日志的时候报上面的错:
Media Recovery Log /data/assyfile/arch/1_83006_744887639.dbf
我把主库的上面这个日志拷到从库,重启从库,还是不行,请帮忙看看。
各位大虾: 昨天下午从库的 MRP0 进程突然停掉,从库恢复中断,但是日志还在传送。检查alert日志,发现恢复下面归档日志的时候报上面的错:
Media Recovery Log /data/assyfile/arch/1_83006_744887639.dbf
我把主库的上面这个日志拷到从库,重启从库,还是不行,请帮忙看看。
recover database until cancelhttp://blog.chinaunix.net/space.php?uid=411974&do=blog&id=88361
再REGISTER,然后APPLY。
这个也报一样的错;2、1_83006_744887639.dbf这个归档重新COPY了一份到STANDBY库,但是没有REGISTER,直接做上面的操作,也报一样的错。REGISTER 是怎么个搞法?3、刚好中秋12号有个冷备,忘记用了。周日上面急着要恢复,直接重新做了standby,但是做之前把冷备的undotbs01.dbf 文件拷过来,执行了一下:
restore datafile 3;
recover standby database;
结果还是一样的过不去,错误信息一样。估计整个冷备恢复以后再跑还是不行。
上周五Metalink回复说可能是新问题,正在转往国外处理。也不知道是老套路,还是真的有这么个Bug。
这个链接用到的关键步骤:alter database open resetlogs;
恐怕不适合standby从库吧,而且我的从库是能open readonly的,只是不能恢复。