Shulou(Shulou.com)06/01 Report--

Recently, due to the power outage in the computer room, the database host was shut down abnormally. After the host returned to normal, an error was reported when the database was started:

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

Check the alert log and the error is as follows:

... Omit.

ALTER DATABASE OPEN # misreported during the open phase

Beginning crash recovery of 1 threads # is doing crash recovery

Parallel recovery started with 2 processes

Started redo scan

Completed redo scan

Read 2095 KB redo, 98 data blocks need recovery

Errors in file / opt/oracle/diag/rdbms/stgorcl/stgorcl/trace/stgorcl_ora_22775.trc (incident=89339):

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

Incident details in: / opt/oracle/diag/rdbms/stgorcl/stgorcl/incident/incdir_89339/stgorcl_ora_22775_i89339.trc

... Omit.

According to the abnormal shutdown event of the host, it is speculated that the database file may be damaged due to the abnormal shutdown of the host. Combined with the error information of the database, it is suspected that the controlfile is damaged.

Through the kcratr_nab_less_than_odr keyword, find a document Alter database open fails with ORA-00600 kcratr_nab_less_than_odr (document ID 1296264.1) that matches this fact in MOS, compare the document with the "Call Stack Trace" of / opt/oracle/diag/rdbms/stgorcl/stgorcl/incident/incdir_89339/stgorcl_ora_22775_i89339.trc, and basically confirm that the event is consistent with the document description.

-Call Stack Trace-

Ksedst1

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.