ORA-00600 [4194] 故障处理

1. 问题现象

启动数据库，数据进行实例恢复完成后，能成功open，但数据库在几分钟后自动宕掉，通过alert日志，可以看到宕库前报错是ORA-00600 arguments: [4194]。

  

   

    

     

    
    

     

      alter database open
     
    
   

    

     

    
    

     

      Beginning crash recovery of 1 threads
     
    
   

    

     

    
    

     

      parallel recovery started with 3 processes
     
    
   

    

     

    
    

     

      Started redo scan -----> 扫描redo，进行实例恢复
     
    
   

    

     

    
    

     

      Completed redo scan
     
    
   

    

     

    
    

     

      read 149 KB redo, 107 data blocks need recovery
     
    
   

    

     

    
    

     

      Started redo application at
     
    
   

    

     

    
    

     

      Thread 1: logseq 84918, block 3
     
    
   

    

     

    
    

     

      Recovery of Online Redo Log: Thread 1 Group 3 Seq 84918 Reading mem 0
     
    
   

    

     

    
    

     

      Mem# 0: /data/orauser01/app/oradata/orcl/redo03.log
     
    
   

    

     

    
    

     

      Completed redo application of 0.12MB -----> 进行实例恢复完成
     
    
   

    

     

    
    

     

      Completed crash recovery at
     
    
   

    

     

    
    

     

      Thread 1: logseq 84918, block 302, scn 13343268733370
     
    
   

    

     

    
    

     

      107 data blocks read, 107 data blocks written, 149 redo k-bytes read
     
    
   

    

     

    
    

     

      Wed Mar 24 18:10:56 2021
     
    
   

    

     

    
    

     

      Thread 1 advanced to log sequence 84919 (thread open)
     
    
   

    

     

    
    

     

      Thread 1 opened at log sequence 84919
     
    
   

    

     

    
    

     

      Current log# 1 seq# 84919 mem# 0:
     
    
  
 

文章来源: wenyusuran.blog.csdn.net，作者：文宇肃然，版权归原作者所有，如需转载，请联系作者。

原文链接：wenyusuran.blog.csdn.net/article/details/122581930