ORA-00354、ORA-00353和ORA-00312是Oracle数据库中常见的错误代码,通常与重做日志(redo log)文件的损坏有关。下面是对这三个错误代码的具体解释、可能的原因、常见解决方案以及预防建议。 错误代码解释 ORA-00354: 损坏重做日志块标头。这表示重做日志文件的某个块头部分已损坏。 ORA-00353: 日志损坏接近块XXX。这...
ORA-00312: online log 1 thread 1: '/oracle/oradata/TSMISC02/redo01.log'<o:p></o:p> 或者:<o:p></o:p> sys@TSMISC02> ALTER SYSTEM DUMP LOGFILE '/oracle/oradata/TSMISC02/redo01.log'; <o:p></o:p> ALTER SYSTEM DUMP LOGFILE '/oracle/oradata/TSMISC02/redo01.log'<o:p></...
ORA-00354: corrupt redo log block header ORA-00353: log corruption near block 3740 change 0 time 04/11/2006 13:49:56 ORA-00312: online log 1 thread 1: '/oracle/oradata/TSMISC02/redo01.log' 或者: sys@TSMISC02> ALTER SYSTEM DUMP LOGFILE '/oracle/oradata/TSMISC02/redo01.log'; ALTE...
ORA-01110: data file 1: 'D:\APP\HENRY\ORADATA\ORACLE11G\SYSTEM01.DBF' SQL> recover database until cancel;ORA-00279: 更改 12905266 (在 04/12/2020 06:00:06 生成) 对于线程 1 是必需的ORA-00289: 建议: D:\APP\HENRY\FLASH_RECOVERY_AREA\ORACLE11G\ARCHIVELOG\2020_04_13\O1_MF_1_658_%U...
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' ...
ORA-00354: corrupt redo log block header ORA-00353: log corruption near block 604525 change 10551037679542time10/28/2009 11:29:50 ORA-00312: online log 2 thread 1:'/oradata/3/TOOLS/stdby_redo/srl1.log' Errorsinfile /tools/oracle/admin/TOOLS/bdump/tools_arc0_2143.trc ...
ORA-00354: corrupt redo log block header ORA-00353: log corruption near block 64358 change 4696142 time 01/02/2010 22:08:46 ORA-00312: online log 1 thread 1: 'H:\ORACLE\SOL\ORIGLOGA\LOG_G11M1.DBF' first of all there is no .log file in H:\ORACLE\SOL\ORIGLOGA folder while if i...
ORA-00353: 日志损坏接近块 更改 时间 ORA-00312: 联机日志 线程 : '' ORA-00354 oerr ora 354 00354, 00000, "corrupt redo log block header" // *Cause: The block header on the redo block indicated by the accompanying // error, is not reasonable. ...
ora-28002报错处理步骤 故障现象: 报错解释: 处理方法种类: 1、修改密码 2、修改用户profile,将PASSWORD_LIFE_TIME修改为unlimited 此次处理步骤按照方法2执行,生产环境建议定期更新密码保证数据安全。 1、查看报错用户现有profile是否为默认值 2、查看profile default的RESOURCE_NAM...ORA...
今天启动本地Oracle数据库发现如下报错:ORA-00354:损坏重做日志块标头ORA-00353:日志损坏接近块35696更改12913198时间04/12/202008:27:58ORA-00312:联机日志1线程1:'D:\\APP\\HENRY\\ORADATA\\ORACLE11G\\REDO01.LOG',网上也搜了很多解决办法,但是都不好使。有没