菜单

manbetx2.0手机版ORA-16038/ORA-00742: Log read detects lost write in thread

2019年8月23日 - Html/Html5

ORA-16038/ORA-00742: Log read detects lost write in thread

爱人碰到Oracle数据库的 REDO LOG “写错过”,产生数据库,且不或者运营。

日志如下:redo log 5不能归档,并且侦测到“写错失”。最后变成Oracle宕机。
Errors in file
/u01/app/oracle/diag/rdbmsdbcontrol/GZDBCONTROL/trace/GZDBCONTROL_ora_32198.trc:
ORA-16038: log 5 sequence# 23 cannot be archived
ORA-00742: Log read detects lost write in thread %d sequence %d block
%d
ORA-00312: online log 5 thread 1:
‘/u01/app/oracle/fast_recovery_area/GZDBCONTROL/onlinelog/o1_mf_5_d61ctj3y_.log’
USER (ospid: 32198): terminating the instance due to error 16038
System state dump requested by (instance=1, osid=32198),
summary=[abnormal instance termination].
System State dumped to trace file
/u01/app/oracle/diag/rdbmsdbcontrol/GZDBCONTROL/trace/GZDBCONTROL_diag_32167_20161227110109.trc
Dumping diagnostic data in directory=[cdmp_20161227110109], requested
by (instance=1, osid=32198), summary=[abnormal instance
termination].

标题原因:
这两种清空都也许引致“写错过”爆发:操作系统、存款和储蓄系统、Oracle内部错误。

解决办法:
应用dump推断是还是不是真正发生了“写遗失”。
SQL> alter system dump logfile
‘/u01/app/oracle/fast_recovery_area/GZDBCONTROL/onlinelog/o1_mf_5_d61ctj3y_.log’
validate;

ERROR at line 1:
ORA-00742: Log read detects lost write in thread %d sequence %d block
%d
ORA-00334: archived log:
‘/u01/app/oracle/fast_recovery_area/GZDBCONTROL/onlinelog/o1_mf_5_d61ctj3y_.log’

从地点dump的结果肯定产生了“写错失”清空,清空难点redo
logfile使其苏醒符合规律归档。

SQL> alter database clear unarchived logfile group 5;

依照上述步骤,朋友的Oracle数据库不荒谬运维。
最终,不要忘记做贰遍全备份。

参考:
Database Crashe with ORA-16038/ORA-742 Errors (文档 ID 2064718.1)
http://docs.oracle.com/cd/E11882\_01/server.112/e17766/e0.htm

转载请评释:
十字螺丝钉
QQ:463725310
site: www.dbhelp.net(有越多更新的原委,迎接访谈)
http://blog.chinaunix.net/uid/23284114.html
E-MAIL:houora#gmail.com(#请自行替换为@)

http://www.bkjia.com/Javascript/1183567.htmlwww.bkjia.comtruehttp://www.bkjia.com/Javascript/1183567.htmlTechArticleORA-16038/ORA-00742: Log read detects lost write
in thread 朋友蒙受Oracle数据库的 REDO LOG
“写遗失”,变成数据库,且不能够运营。 日志如下:redo log 5无…

相关文章

发表评论

电子邮件地址不会被公开。 必填项已用*标注

网站地图xml地图