00600 [4000], [2411] Error resolution

The developed oracle System, linux platform, and version 10.2.0.1.0. A ORA-00600 error is prompted during an rman backup. After exiting, you only need to query the DBA_JOBS, database

The developed oracle System, linux platform, and version 10.2.0.1.0. A ORA-00600 error is prompted during an rman backup. After exiting, you only need to query the DBA_JOBS, database

The Oracle system, linux platform, and version 10.2.0.1.0 used by friends.

A ORA-00600 error is prompted during an rman backup. After exiting, as long as you query DBA_JOBS, the database prompts a ORA-00600 error and the database shuts down automatically.

I. Fault symptom

Read alert. log as follows:

We can see that the SMON process reports an error when the database is started:

Ii. Fault Analysis

There are two main faults: ORA-00600 [4000], [2426], [], [], [], [], [], [] and ORA-00600 [4000], [2411], [], [], [], [], [], []

1) ORA-00600 [4000], [2426], [], [], [], [], [], []

Open the tftdb_smon_4289.trc file and you can see the following information:

It seems that the table smon_scn_time has a problem. The smon process in this table is updated every 6 seconds and the map information of scn and time is written. The creation statement is as follows:

Run the query:

However, the following statement can be correctly executed:

ORA-00600 error also occurs when you execute to rownum <2000. The database is down.

Check whether the database has bad blocks and execute the data Bad blocks:

No bad blocks are found.