暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

​Oracle故障处理之MRP进程启动报错:ORA-00600: arguments: [2619], [227424], []

数据与人 2020-12-15
602

问题背景:
客户数据库服务架构为一主一备,某日备库操作系统意外重启,重启后Oracle MRP进程起不来


报错如下

ORA-00600: internal error code, arguments: [2619], [227424], [], []


1> 检查MRP进程



    SQL> select process,status from v$managed_standby;


    PROCESS STATUS
    ------- ------------
    ARCH CONNECTED
    ARCH CONNECTED
    MRP0 WAIT_FOR_LOG
    RFS RECEIVING


    没有MRP进程,说明备库没有处于恢复状态。


    尝试启动MRP进程


      alter database recover managed standby database disconnect from session ;


      MRP进程启动报错

      报错日志如下:

        Clearing online redo logfile 5 complete
        Media Recovery Log oraarchivelog/xxxx/oradb_1_227424_866810169.arc
        Errors in file u01/oracle/diag/rdbms/oradb/oradb/trace/oradb_pr00_5429.trc (incident=48266):
        ORA-00600: internal error code, arguments: [2619], [227424], [], [], [], [], [], [], [], [], [], []
        Incident details in: u01/oracle/diag/rdbms/oradb/oradb/incident/incdir_48266/oradb_pr00_5429_i48266.trc
        Completed: ALTER DATABASE RECOVER managed standby database disconnect from session
        Use ADRCI or Support Workbench to package the incident.
        See Note 411.1 at My Oracle Support for error and packaging details.
        Errors with log oraarchivelog/oradb/oradb_1_227424_866810169.arc
        MRP0: Background Media Recovery terminated with error 600
        Errors in file u01/oracle/diag/rdbms/oradb/oradb/trace/oradb_pr00_5429.trc:
        ORA-00600: internal error code, arguments: [2619], [227424], [], [], [], [], [], [], [], [], [], []
        Recovery interrupted!
        Errors in file u01/oracle/diag/rdbms/oradb/oradb/trace/oradb_pr00_5429.trc:
        ORA-00600: internal error code, arguments: [2619], [227424], [], [], [], [], [], [], [], [], [], []
        Errors in file u01/oracle/diag/rdbms/oradb/oradb/trace/oradb_mrp0_5426.trc (incident=48257):
        ORA-00600: internal error code, arguments: [2619], [227424], [], [], [], [], [], [], [], [], [], []
        ORA-10877: error signaled in parallel recovery slave
        ORA-10877: error signaled in parallel recovery slave
        ORA-10877: error signaled in parallel recovery slave
        ORA-10877: error signaled in parallel recovery slave
        ORA-10877: error signaled in parallel recovery slave
        ORA-10877: error signaled in parallel recovery slave
        ORA-10877: error signaled in parallel recovery slave
        Incident details in: u01/oracle/diag/rdbms/oradb/oradb/incident/incdir_48257/oradb_mrp0_5426_i48257.trc
        Use ADRCI or Support Workbench to package the incident.
        See Note 411.1 at My Oracle Support for error and packaging details.
        MRP0: Background Media Recovery process shutdown (oradb)
        Dumping diagnostic data in directory=[cdmp_20180328134814], requested by (instance=1, osid=5429 (PR00)), summary=[incident=48266].
        Sweep [inc][48266]: completed
        Sweep [inc][48257]: completed
        Sweep [inc2][48266]: completed
        Sweep [inc2][48257]: completed


        发现这个600错误是备库在执行恢复的过程中,发现227424这个归档日志有问题或者找不到,导致日志应用失败
        错误日志:

          Errors with log oraarchivelog/oradb/oradb_1_227424_866810169.arc


          既然这条日志有问题,把归档日志下的这条日志删除,然后从主库传输过来这条日志


          2> 手动重新应用这条日志

            alter database register OR replace logfile '/home/oracle/oradb_1_227424_866810169.arc';


            3> 开启日志应用

              alter database recover managed standby database disconnect from session;


              或者数据库open状态下

                alter database recover managed standby database using current logfile disconnect from session;


                修复完成,问题解决




                往期回顾


                MySQL故障处理之启动报错-The server quit without updating PID file[FAILED]
                MySQL故障处理之使用外部数据源连接WIN版本的MySQL时,测试连接无法通过


                客官长按关注

                吾辈自强不息



                文章转载自数据与人,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

                评论