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

    ORA-600 kcbr_apply_change_11

    惜分飞发表于 2023-06-25 02:57:47
    love 0

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

    标题:ORA-600 kcbr_apply_change_11

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

    客户active dataguard应用日志报ORA-600 kcbr_apply_change_11错误

    Sun Jun 25 10:31:25 2023
    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT  LOGFILE DISCONNECT FROM SESSION
    Sun Jun 25 10:31:25 2023
    MRP0 started with pid=32, OS id=6380 
     started logmerger process
    Sun Jun 25 10:31:30 2023
    Managed Standby Recovery starting Real Time Apply
    Parallel Media Recovery started with 4 slaves
    Waiting for all non-current ORLs to be archived...
    All non-current ORLs have been archived.
    Media Recovery Log D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\xffWIN\ARCHIVELOG\2023_06_23\O1_MF_1_196319_L99NQQSN_.ARC
    Sun Jun 25 10:31:31 2023
    Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\xffwin\xff\trace\xff_pr03_1540.trc  (incident=180300):
    ORA-00600: 内部错误代码, 参数: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []
    Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\xffwin\xff\incident\incdir_180300\xff_pr03_1540_i180300.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT  LOGFILE DISCONNECT FROM SESSION
    Sun Jun 25 10:31:32 2023
    Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\xffwin\xff\trace\xff_pr02_752.trc  (incident=180292):
    ORA-00600: 内部错误代码, 参数: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []
    Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\xffwin\xff\incident\incdir_180292\xff_pr02_752_i180292.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\xffwin\xff\trace\xff_rfs_6032.trc:
    ORA-01265: 无法删除 ARCHIVED LOG /u01/oracle/fast_recovery_area/xffDG/archivelog/2023_05_28/o1_mf_1_192064_l74rj3jz_.arc
    ORA-27056: 无法删除文件
    OSD-04029: 无法获取文件属性
    O/S-Error: (OS 3) 系统找不到指定的路径。
    Archived Log entry 35084 added for thread 1 sequence 196424 rlc 1013082900 ID 0xe513780f dest 3:
    RFS[7]: Opened log for thread 1 sequence 196430 dbid -451738353 branch 1013082900
    Slave exiting with ORA-600 exception
    Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\xffwin\xff\trace\xff_pr02_752.trc:
    ORA-00600: 内部错误代码, 参数: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []
    Sun Jun 25 10:31:41 2023
    Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\xffwin\xff\trace\xff_pr04_3696.trc  (incident=180308):
    ORA-00600: 内部错误代码, 参数: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []
    Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\xffwin\xff\incident\incdir_180308\xff_pr04_3696_i180308.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Sun Jun 25 10:31:41 2023
    Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\xffwin\xff\trace\xff_mrp0_6380.trc  (incident=180268):
    ORA-00600: 内部错误代码, 参数: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []
    Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\xffwin\xff\incident\incdir_180268\xff_mrp0_6380_i180268.trc
    Use ADRCI or Support Workbench to package the incident.
    See Note 411.1 at My Oracle Support for error and packaging details.
    Recovery Slave PR02 previously exited with exception 600
    Sun Jun 25 10:31:41 2023
    MRP0: Background Media Recovery terminated with error 448
    Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\xffwin\xff\trace\xff_pr00_7812.trc:
    ORA-00448: 后台进程正常结束
    Managed Standby Recovery not using Real Time Apply
    Sun Jun 25 10:31:41 2023
    Slave exiting with ORA-600 exception
    Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\xffwin\xff\trace\xff_pr03_1540.trc:
    ORA-00600: 内部错误代码, 参数: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []
    Sun Jun 25 10:31:43 2023
    Sweep [inc][180308]: completed
    Sweep [inc][180300]: completed
    Sweep [inc][180292]: completed
    Sweep [inc][180268]: completed
    Sweep [inc2][180300]: completed
    Sweep [inc2][180292]: completed
    Sweep [inc2][180268]: completed
    Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\xffwin\xff\trace\xff_pr04_3696.trc:
    ORA-00448: 后台进程正常结束
    ORA-00600: 内部错误代码, 参数: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []
    Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\xffwin\xff\trace\xff_pr04_3696.trc:
    ORA-00339: 归档日志未包含任何重做
    ORA-00334: 归档日志: 'D:\APP\ADMINISTRATOR\ORADATA\xff\REDO02.LOG'
    ORA-00600: 内部错误代码, 参数: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []
    Slave exiting with ORA-600 exception
    Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\xffwin\xff\trace\xff_pr04_3696.trc:
    ORA-00600: 内部错误代码, 参数: [kcbr_apply_change_11], [], [], [], [], [], [], [], [], [], [], []
    

    通过分析可能为:Bug 31104809 – ORA-600: [kcbr_apply_change_11] during adg recovery (Doc ID 31104809.8)
    官方WORKAROUND:
    In ADG, mount the database (do not open it) and restart media recovery; once
    the affected redo log sequence is applied, open the ADG in read only mode.

    • 12c启动报kcratr_nab_less_than_odr
    • 又一例ORA-600 kcratr_nab_less_than_odr
    • ORA-00322 ORA-00312恢复
    • ORA-00742 ORA-00312 故障恢复
    • Patch SCN工具快速解决ORA-600 2662问题
    • ORA-600 kcratr_scan_lastbwr 恢复
    • ora-600 kcratr_scan_lastbwr
    • 分享一次ORA-01113 ORA-01110故障处理过程
    • Oracle 19c 断电异常恢复
    • ORA-600 3417和ORA-600 3005故障处理
    • 正常open库报ORA-600 2662,ORA-600 4097错误
    • tab$被恶意删除sys用户之外记录


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