遇到一个案例,数据库open报ORA-16038,ORA-00354等错误 查询该redo状态(使用Oracle数据库异常恢复检查脚本(Oracle Database Recovery Check)脚本收集),确认为inactive 由于inactive 状态的redo损坏,无法被arch进程归档导致数据库无法正常open,尝试强制clear联机日志 由于25号文件属于offline状态,导致联机日志无法正常被clear,...
ORA-00312: online log 2 thread 1:'/oradata/3/TOOLS/stdby_redo/srl1.log' Wed Oct 28 11:42:05 2009 Errorsinfile /tools/oracle/admin/TOOLS/bdump/tools_arc0_2143.trc: ORA-16038: log 2sequence# 13831 cannot be archived ORA-00354: corrupt redo log block header ORA-00312: online log 2...
Problem Description: ORA-16038: log 2 sequence# 13831 cannot be archived ORA-00354: corrupt redo log block header ORA-00312: online log 2 thread 1: '/oradata/3/TOOLS/stdby_redo/srl1.log' ? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 ...
Hi Guys, Need your support to resolve one of the oracle issues, Below are errors visible in alert.log in oracle, ORA-16038: log 24 sequence# 660467 cannot be archived ORA-00354: corrupt redo log block header ORA-00312: online log 24 thread 1: '/oracle/PRD/origlogB/log_g24_m1.dbf'....
ORA-16038: log 1 sequence# 397 cannot be archived ORA-00354: corrupt redo log block header ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log' Opening with internal Resource Manager plan replication_dependency_tracking turned off (no async multimaster replication found...
总结故障原因:oracle启动关闭未完成而重复启动关闭数据库报错:ORA-03113,oracle闪回空间满报错ORA-16038,oracle的pfile参数文件u... 查看原文 ORCAL数据库问题:日志文件损坏解决方案 ORCAL数据库问题数据库日志文件损坏修复 ora-01034 ; ora-27101 ora-24324 ora-24324 ; ora-01041 ora-01034 ora-03113 ora-00354 ...
:ORA-03113,oracle闪回空间满数据库实例启动报错ORA-16038,oracle的pfile参数文件undo表空间设置与spfile参数文件undo表空间设置不一致导致报错:ORA-30012。...成功开库。总结故障原因:oracle启动关闭未完成而重复启动关闭数据库报错:ORA-03113,oracle闪回空间满报错ORA-16038,oracle的pfile参数文件undo表空间设置与 ...
ORA-00316 ORA-00312故障处理 数据库启动报ORA-00316,ORA-00312,无法正常启动 通过Oracle数据库异常恢复检查脚本(Oracle Database Recovery Check)分析,确认是当前redo损坏 对于这种情况,只能是屏蔽一致性,强制拉库,结果在拉库过程中报ORA-600 2662错误 这个错误相对比较简单,修改下相关scn即可,数据库open成功...
ORA-00742错误不太好模拟,这里简单模拟一下ORA-00312. 首先创建测试表,并进行相关update操作,在进行update的同时,通过strace lgwr进程定位相关偏移量。 SQL> select a.object_id,dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) blk# from test0413 2 a; OBJECT_ID FILE# BL...
ORA-00354: corrupt redo log block header --->发现redo log header有损坏 ORA-00353: log corruption near block 385521 change 1314765 time 06/03/2015 19:05:47 ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log' ...