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

    ORA-600 ksvworkmsgalloc: bad reaper

    惜分飞发表于 2025-05-19 15:21:44
    love 0

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

    标题:ORA-600 ksvworkmsgalloc: bad reaper

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

    有一个朋友说他们想把12c的库还原到19c版本中然后进行升级测试,结果在打开库的过程中发现几个错误,让我给帮忙分析下
    resetlogs 报ORA-00392 ORA-00312

    SQL> alter database open resetlogs upgrade;
    alter database open resetlogs upgrade
    *
    ERROR at line 1:
    ORA-00392: log 7 of thread 1 is being cleared, operation not allowed
    ORA-00312: online log 7 thread 1: '/DBS1/data/NDBS/onlinelog/redo07_m1.log '
    ORA-00312: online log 7 thread 1: '/DBS1/arch/NDBS/onlinelog/redo07_m2.log '
    

    这个错误一般是由于redo状态不对,比如标记为了CLEARING_CURRENT,处理操作

    SQL> select group#,status from v$log;
    
              GROUP# STATUS
    ---------------- ----------------
                   1 CLEARING
                   2 CLEARING
                   3 CLEARING
                   4 CLEARING
                  10 CLEARING
                   6 CLEARING
                   7 CLEARING_CURRENT
                   8 CLEARING
                   9 CLEARING
                   5 CLEARING
    
    10 rows selected.
    
    
    SQL> alter database clear logfile group 7;
    
    Database altered.
    
    SQL> select group#,status from v$log;
    
              GROUP# STATUS
    ---------------- ----------------
                   1 CLEARING
                   2 CLEARING
                   3 CLEARING
                   4 CLEARING
                  10 CLEARING
                   6 CLEARING
                   7 CURRENT
                   8 CLEARING
                   9 CLEARING
                   5 CLEARING
    
    10 rows selected.
    

    再次reseltogs报ORA-600 ksvworkmsgalloc: bad reaper错误

    SQL> alter database open resetlogs upgrade;
    alter database open resetlogs upgrade
    *
    ERROR at line 1:
    ORA-00600: internal error code, arguments: [ksvworkmsgalloc: bad reaper], [0x080010003], [], [], []
    

    这个错误通过查询MOS 发现Open Resetlogs Fail with ORA-00600[ksvworkmsgalloc: bad reaper] (Doc ID 2728106.1)文章中描述,由于non-ASM to ASM环境redo文件在clear的时候触发该问题
    KSVWORKMSGALLOW


    是由于db_create_online_log_dest_1参数没有设置导致,对于该库是由asm环境到文件系统,估计也是在resetlogs的时候clear redo报出来该错误,解决办法给该库设置上
    db_create_online_log_dest_1=/DBS1/data,db_create_online_log_dest_2=/DBS1/arch,然后打开库成功
    QQ20250519-231821

    • Patch SCN工具一键恢复ORA-600 kcbzib_kcrsds_1
    • ORA-600 kcbzib_kcrsds_1报错
    • ORA-00742 ORA-00312 恢复
    • 重建ctl遭遇ORA-01163 ORA-01110和ORA-600 kccccfl_1错误
    • 数据库open报ORA-600 kcratr_scan_lastbwr故障处理
    • 19c非归档数据库断电导致ORA-00742故障恢复
    • 重建控制文件丢失undo异常恢复—ORA-01173模拟与恢复
    • Oracle 19C 报ORA-704 ORA-01555故障处理
    • File #xxx found in data dictionary but not in controlfile. Creating OFFLINE file ‘MISSING00XXX’ in the controlfile
    • resetlogs强制拉库失败并使用备份system文件还原数据库故障处理
    • system01.dbf文件被offline,导致数据库报ORA-01245 ORA-01110故障恢复
    • 第一例Oracle 21c恢复咨询



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