• ORA-00600: internal error code, arguments


    通过rman将11g异机升级到19c时,应用归档时报错,报错如下

    RMAN>  recover database ;

    Starting recover at 2023-10-15 21:10:02
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=5776 device type=DISK

    starting media recovery
    media recovery failed
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of recover command at 10/15/2023 21:10:03
    ORA-00283: recovery session canceled due to errors
    RMAN-11003: failure during parse/execution of SQL statement: alter database recover
     if needed start until cancel using backup controlfile
    ORA-00283: recovery session canceled due to errors
    ORA-00600: internal error code, arguments: [kcnibrUpdate], [0], [1], [], [], [], [], [], [], [], [], []

    RMAN>

    查找MOS文档:ORA-00600: internal error code, arguments: [kcnibrUpdate] report during Managed recovery (MRP) (Doc ID 2798541.1)
    根据文档操作如下

    orcl:/home/oracle@testdb> sqlplus / as sysdba

    SQL*Plus: Release 19.0.0.0.0 - Production on Sun Oct 15 21:11:02 2023
    Version 19.3.0.0.0

    Copyright (c) 1982, 2019, Oracle.  All rights reserved.


    Connected to:
    Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    Version 19.3.0.0.0

    SQL> select blktype,count(*) from x$kccblkcor group by blktype;

       BLKTYPE   COUNT(*)
    ---------- ----------
             6          1

    SQL> Select * from v$controlfile_record_section where type='DATABASE BLOCK CORRUPTION' ;

    TYPE                         RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX
    ---------------------------- ----------- ------------- ------------ -----------
    LAST_INDEX LAST_RECID     CON_ID
    ---------- ---------- ----------
    DATABASE BLOCK CORRUPTION             80          8384            1           1
             1          1          0


    SQL> exec dbms_backup_restore.resetcfilesection(35)

    PL/SQL procedure successfully completed.

    SQL> Select * from v$controlfile_record_section where type='DATABASE BLOCK CORRUPTION' ;

    TYPE                         RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX
    ---------------------------- ----------- ------------- ------------ -----------
    LAST_INDEX LAST_RECID     CON_ID
    ---------- ---------- ----------
    DATABASE BLOCK CORRUPTION             80          8384            0           0
             0          0          0

    操作结束后继续rman操作recover database操作正常

    orcl:/home/oracle@testdb>rman target /

    Recovery Manager: Release 19.0.0.0.0 - Production on Sun Oct 15 21:11:44 2023
    Version 19.3.0.0.0

    Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

    connected to target database: ORCL (DBID=768804399, not open)

                                                            

    RMAN> recover database;                     

    Starting recover at 2023-10-15 21:12:34
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=5776 device type=DISK

    starting media recovery

    archived log for thread 1 with sequence 14 is already on disk as file /u01/archivelog/1_14_1150285015.dbf
    archived log for thread 1 with sequence 15 is already on disk as file /u01/archivelog/1_15_1150285015.dbf
    archived log file name=/u01/archivelog/1_14_1150285015.dbf thread=1 sequence=14
    archived log file name=/u01/archivelog/1_15_1150285015.dbf thread=1 sequence=15
    unable to find archived log
    archived log thread=1 sequence=16
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of recover command at 10/15/2023 21:12:36
    RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 16 and starting SCN of 87204796002

    RMAN>

  • 相关阅读:
    XR Interaction ToolKit
    排序算法复习 | 插入排序(直接插入排序、希尔排序)与选择排序(直接选择排序、堆排序)
    解决Huggingface被墙下载模型的问题
    Qt 样式表大全整理
    洗衣洗鞋店小程序对接水洗唛打印,一键预约,支付无忧
    智谱API调用
    linux环境下熟悉又陌生的sudo命令
    vue 按钮权限
    私域流量对企业的好处
    Git 服务器搭建
  • 原文地址:https://blog.csdn.net/kevinyu998/article/details/133848026