IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    存储断电导致ORA-00325故障恢复

    惜分飞发表于 2023-11-11 13:51:51
    love 0

    联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

    标题:存储断电导致ORA-00325故障恢复

    作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

    由于存储断电,数据库启动最初报错

    Reconfiguration complete
     parallel recovery started with 32 processes
    Started redo scan
    Completed redo scan
     read 22887 KB redo, 2025 data blocks need recovery
    Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl11/trace/orcl11_ora_25449.trc  (incident=25522):
    ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [203596], [1537], [3046], []
    Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl11/incident/incdir_25522/orcl11_ora_25449_i25522.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Abort recovery for domain 0
    Aborting crash recovery due to error 600
    Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl11/trace/orcl11_ora_25449.trc:
    ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [203596], [1537], [3046], []
    Abort recovery for domain 0
    Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl11/trace/orcl11_ora_25449.trc:
    ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [203596], [1537], [3046], []
    ORA-600 signalled during: ALTER DATABASE OPEN...
    

    尝试重建ctl之后,恢复数据库报错ORA-00325错误
    ORA-00325


    [oracle@xifenfei ~]$ oerr ora 325
    00325, 00000, "archived log for thread %s, wrong thread # %s in header"
    // *Cause:  The archived log is corrupted or for another thread. Can not
    //          use the log for applying redo.
    // *Action: Find correct archived log.
    

    归档日志文件的头部中的线程编号和实际使用的线程编号不匹配的时候报出的错误。该错误的常见情形是由于线程 ID (thread ID) 没有被正确分配或更新造成的,如从主控制档(control file)恢复用户表空间后更改线程 ID 但系统没有知道,导致系统在访问归档日志文件时,由于归档日志文件的头部中的线程编号与实际使用的线程编号不匹配,而出现该错误。

    尝试强制拉库,报ORA-600 2662错误
    ORA-600-2662


    尝试修改scn继续启动库报ORA-600 kclchkblk_4
    ORA-600-kclchkblk_4

    继续调整scn,数据库open成功.后续就是各种收尾工作(比如undo回滚段,tempfile,各种ORA-600错误等)

    • ORA-600 ksuloget2 恢复
    • ora-600 2662和ora-600 kclchkblk_4恢复
    • 因为人工误操作导致resetlogs scn不一致恢复
    • ora-600 kcratr_scan_lastbwr
    • Patch SCN工具快速解决ORA-600 2662问题
    • Patch SCN一键解决ORA-600 2662故障
    • ORA-600 kcratr_scan_lastbwr 恢复
    • ORA-00600 [2662]和ORA-00600 [4194]恢复
    • ORA-600 kcbzpbuf_1故障恢复
    • 正常open库报ORA-600 2662,ORA-600 4097错误
    • ORA-600 3600恢复—-resetlogs scn异常
    • Oracle Recovery Tools实战批量坏块修复


沪ICP备19023445号-2号
友情链接