因客户机房断电,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;