ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],

发布于:2025-04-19 ⋅ 阅读:(23) ⋅ 点赞:(0)

因客户机房断电,2台主机和共享存储全部断电,来电后,集群启动正常,实例无法正常启动,手动启动报错如下

SQL > startup;
ORACLE instance started.

Total System Global Area 3.9551E+10 bytes
Fixed Size            2261688 bytes
Variable Size         7918849352 bytes
Database Buffers     3.1407E+10 bytes
Redo Buffers          223019008 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[1180], [535296], [535344], [], [], [], [], [], [], []

查看日志,如下

Completed redo scan
 read 23622 KB redo, 1696 data blocks need recovery
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_297546.trc  (incident=256454):
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [1180], [535296], [535344], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_256454/orcl1_ora_297546_i256454.trc
Thu Apr 17 10:05:32 2025
Dumping diagnostic data in directory=[cdmp_20250417100532], requested by (instance=1, osid=297546), summary=[incident=256454].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Abort recovery for domain 0
Aborting crash recovery due to error 600
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_297546.trc:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [1180], [535296], [535344], [], [], [], [], [], [], []
Abort recovery for domain 0
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_297546.trc:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [1180], [535296], [535344], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...
Thu Apr 17 10:06:21 2025
Decreasing number of real time LMS from 6 to 0
Thu Apr 17 10:06:24 2025
Sweep [inc][256454]: completed
Sweep [inc2][256454]: completed

查看备份,发现备份正常

恢复过程如下

1、启动数据库到nomount状态

2、进入rman下操作
  RMAN> set dbid=3663509161
  RMAN> restore controlfile from '/backup/rman/c-3663509161-20250416-03';
  RMAN> alter database mount;
  RMAN> recover database delete archivelog;
  RMAN> alter database open resetlogs;
 


网站公告

今日签到

点亮在社区的每一天
去签到