ORA-00600 dbkif_find_next_record_1----惜分飞

最新推荐文章于 2024-08-14 20:32:47 发布

weixin_34072159

最新推荐文章于 2024-08-14 20:32:47 发布

阅读量1k

点赞数

文章标签：数据库操作系统

原文链接：https://yq.aliyun.com/articles/675821

版权

数据库版本信息

 
         SQL>  
         select 
         *  
         from 
         v$version; 
        
         BANNER 
        
         -------------------------------------------------------------------------------- 
        
         Oracle  
         Database 
         11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production 
        
         PL/SQL Release 11.2.0.1.0 - Production 
        
         CORE    11.2.0.1.0  Production 
        
         TNS  
         for 
         64- 
         bit 
         Windows: Version 11.2.0.1.0 - Production 
        
         NLSRTL Version 11.2.0.1.0 - Production

数据库启动报ORA-00600 dbkif_find_next_record_1错误

 
         alter database  
         open 
        
         Beginning crash recovery of 1 threads 
        
         parallel recovery started with 3 processes 
        
         Started redo scan 
        
         Completed redo scan 
        
         read 
         133 KB redo, 72 data blocks need recovery 
        
         Started redo application at 
        
         Thread 1: logseq 49070, block 14720 
        
         Recovery of Online Redo Log: Thread 1 Group 2 Seq 49070 Reading mem 0 
        
         Mem 
         # 0: D:\APP\xff\ORADATA\ORCL\REDO02.LOG 
        
         Completed redo application of 0.09MB 
        
         Errors  
         in 
         file 
         d:\app\xff\diag\rdbms\orcl\orcl\trace\orcl_ora_2340.trc  (incident=477756): 
        
         ORA-00600: ??????, ??: [dbkif_find_next_record_1], [], [], [], [], [], [], [], [], [], [], [] 
        
         Incident details  
         in 
         : d:\app\xff\diag\rdbms\orcl\orcl\incident\incdir_477756\orcl_ora_2340_i477756.trc 
        
         Wed Sep 26 10:52:07 2018 
        
         Trace dumping is performing  
         id 
         =[cdmp_20180926105207] 
        
         Wed Sep 26 10:52:08 2018 
        
         Aborting crash recovery due to error 600 
        
         Errors  
         in 
         file 
         d:\app\xff\diag\rdbms\orcl\orcl\trace\orcl_ora_2340.trc: 
        
         ORA-00600: ??????, ??: [dbkif_find_next_record_1], [], [], [], [], [], [], [], [], [], [], [] 
        
         Errors  
         in 
         file 
         d:\app\xff\diag\rdbms\orcl\orcl\trace\orcl_ora_2340.trc: 
        
         ORA-00600: ??????, ??: [dbkif_find_next_record_1], [], [], [], [], [], [], [], [], [], [], [] 
        
         ORA-600 signalled during: alter database  
         open 
         ...

这里比较明显，数据库是在做实例恢复的时候遭遇到ORA-600 dbkif_find_next_record_1错误,无法正常应用日志导致该错误,具体原因由于:the NAB and finds it is less than the block# from the on-disk-RBA recorded，对于这种问题，通过人工修改next available block# in the Online Redo Log的相关记录,即可正常open数据库,而且理论上数据0丢失