1, 数据库日志报错ORA-00327,注意此处有乱码
Errors in file /oracle/app/oracle/diag/rdbms/tyolap/tyolap3/trace/tyolap3_lgwr_22388.trc:
ORA-00327: 脠脮脮I 31 (脌M戮<80> 3 碌脛): <8c><8d>贸w麓贸脨隆 102400 脡脵矛露脣霉脨猫脪陋碌脛 1048576
ORA-00312: 戮<80>脡脧脠脮脮I 31 脌M戮<80> 3: '+DATA/tyolap/onlinelog/redo31a'
Errors in file /oracle/app/oracle/diag/rdbms/tyolap/tyolap3/trace/tyolap3_lgwr_22388.trc:
ORA-00321: 脠脮脮I 31 (脌M戮<80> 3 碌脛): <9f>o路篓赂眉脨脗脠脮脮I<99>n<98>脣卯^
ORA-00312: 戮<80>脡脧脠脮脮I 31 脌M戮<80> 3: '+DATA/tyolap/onlinelog/redo31a'
查看报错具体内容,应该是redo文件+DATA/tyolap/onlinelog/redo31a损坏
[oracle@dtydb5 scripts]$ oerr ora 327
00327, 00000, "log %s of thread %s, physical size %s less than needed %s"
// *Cause: A log file has shrunk in size. This is likely
// to have been caused by operator or operating system error.
// *Action: Restore the log file from backup. If backup is not available,
// drop this log and re-create. If the database was shut down
// cleanly, no further action should be required; otherwise
// incomplete recovery may be required.
[oracle@dtydb5 scripts]$ oerr ora 312
00312, 00000, "online log %s thread %s: '%s'"
// *Cause: This message reports the filename for details of another message.
// *Action: Other messages will accompany this message. See the
// associated messages for the appropriate action to take.
[oracle@dtydb5 scripts]$ oerr ora 321
00321, 00000, "log %s of thread %s, cannot update log file header"
// *Cause: Cannot write to the log file.
// *Action: Restore the access to the file.
2,进一步查看trc文件,具体原因没看明白,但基本已可以确定是日志文件损坏
DE: Problem Key 'ORA 313' was flood controlled (0x1) (no incident)
ORA-00313: ?????? 31 (???? 3) ?????
ORA-00313: ?????? 31 (???? 3) ?????
DDE rules only execution for: ORA 312
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
DDE Action 'DB_STRUCTURE_INTEGRITY_CHECK' was flood controlled
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (FLOOD CONTROLLED, 5 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
3,查看此redo文件的状态,status为INVALID,另一个为stale,系统还在正常运行中.
31 3 575 2 536,870,912 YES ACTIVE
32 3 576 2 536,870,912 NO CURRENT
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------- ---
31 STALE ONLINE +DATA/tyolap/onlinelog/redo31a NO
ONLINE +DATA/tyolap/onlinelog/redo31b NO
32 INVALID ONLINE +DATA/tyolap/onlinelog/redo32a NO
ONLINE +DATA/tyolap/onlinelog/redo32b NO
STATUS VARCHAR2(7) Status of the log member:
INVALID - File is inaccessible
STALE - File's contents are incomplete
DELETED - File is no longer used
null - File is in use
4,日志文件损坏,最简单的方法就是在线重建日志文件了
sys@TYOLAP3(dtydb5)> ALTER DATABASE DROP LOGFILE MEMBER '+DATA/tyolap/onlinelog/redo31a';
数据库已更改。
sys@TYOLAP3(dtydb5)> ALTER DATABASE ADD LOGFILE MEMBER '+DATA/tyolap/onlinelog/redo31a' to group 31;
数据库已更改。
sys@TYOLAP3(dtydb5)> alter system switch logfile;
系统日志恢复正常
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------- ---
31 ONLINE +DATA/tyolap/onlinelog/redo31a NO
ONLINE +DATA/tyolap/onlinelog/redo31b NO
32 ONLINE +DATA/tyolap/onlinelog/redo32a NO
ONLINE +DATA/tyolap/onlinelog/redo32b NO
5,系统恢复正常了,但是日志文件损坏的原因还不是特清楚。
分享到:
相关推荐
使用工具IMPDP导入数据时ORA-39002、ORA-39070错误排查。使用工具IMPDP导入数据时ORA-39002、ORA-39070错误排查 使用工具IMPDP导入数据时ORA-39002、ORA-39070错误排查
ora-00604 错误 解决 方法 ora-00604 错误 解决 方法 ora-00604 错误 解决 方法 ora-00604 错误 解决 方法 ora-00604 错误 解决 方法ora-00604 错误 解决 方法
oracle数据库ora-01152和ora-01110的解决办法
Oracle 11gr2连Oracle 19c 报ORA-28040 ORA-01017解决方法
Drop goldengate用户时,报ORA-00604 ORA-20782 ORA-06512错误
离线误删空间文件导致的ORA-01033及ORA-01145问题的解决办法,在解决ORA-01033的过程中,又出现ORA-01145 * 第 1 行出现错误: ORA-01145: 除非启用了介质恢复, 否则不允许立即脱机 接着的解决步骤
oracle网络配置(listener_ora-sqlnet_ora-tnsnames_ora).mht
在运行查询SELECT * FROM V$SESSION 会出现ORA-29275:部分多字节字符的错误,这是什么原因开始我不得其解,网上也没有介绍什么好办法。本文给出答案。
ORACLE ORA-00132 ORA-00214
oracle启动失败,ORA-00702报错,windows,linux系统下解决办法
客户端进行连接的时候,系统不定期出现ora-12520,ora-12516的连接问题, 问题解决方案建议: 1、增加process和session的连接数。 2、检查连接的应用,是不是有没有释放的连接。 3、将修改参数local_listener中的vip为...
ORA-12541 TNSno listener 的解决方案 ORA-12541 TNSno listener 的解决方案
oracle数据库优化之后,报错报错“ora-00838”的处理方法
Oracle_ORA-12518故障_处理,希望在此与大家分享,能够在实际的工作中提高解决问题的能力
OGG之ORA-01403案例,包括这个案例所遇到的错误详解,对使用的参数进行了详细的解说
如果内存块仍然不够满足需求,那么就会出现ORA- 04031错误。这些错误同样可能发生在ASM的实例中。默认的共享池的大小基本能够满足大部分的环境,但是如果遇到ORA-04031错误的时候可能就需要增大。 当遇到这个错误的...
断电与ORA-600问题集断电与ORA-600问题集断电与ORA-600问题集断电与ORA-600问题集断电与ORA-600问题集断电与ORA-600问题集断电与ORA-600问题集断电与ORA-600问题集
ORA-20011,ORA06564错误分析
ora-00845