
Oracle instance terminated immediate after instance startup due to following mentioned oracle error:
Cause:
A mismatch has been detected between Redo records and rollback (Undo) records.
We are validating the Undo record number relating to the change being applied against the maximum undo record number recorded in the undo block. This error is reported when the validation fails. This error may indicate a rollback segment corruption.
Note: This may require a recovery from a database backup depending on the situation.
Adrci logs are as follows:
Errors in file /u01/app/oracle/diag/rdbms/db1/db1/trace/db1_smon_11168.trc (incident=1014790): ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] replication_dependency_tracking turned off (no async multimaster replication found) Incident details in: /u01/app/oracle/diag/rdbms/db1/db1/incident/incdir_1014790/db1_smon_11168_i1014790.trc 2016-06-30 11:13:35.355000 +05:30 Starting background process QMNC QMNC started with pid=25, OS id=11249 ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE Completed: ALTER DATABASE OPEN 2016-06-30 11:13:36.558000 +05:30 db_recovery_file_dest_size of 163840 MB is 1.12% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Doing block recovery for file 3 block 26014 Resuming block recovery (PMON) for file 3 block 26014 Block recovery from logseq 13618, block 56 to scn 3980712372 Recovery of Online Redo Log: Thread 1 Group 1 Seq 13618 Reading mem 0 Mem# 0: /u02/oradata/db1/redo_1_1.log Mem# 1: /u02/oradata/db1/redo_1_2.log Mem# 2: /u02/oradata/db1/redo_1_3.log Block recovery stopped at EOT rba 13618.106.16 Block recovery completed at rba 13618.106.16, scn 0.3980712368 Doing block recovery for file 3 block 160 Resuming block recovery (PMON) for file 3 block 160 Block recovery from logseq 13618, block 56 to scn 3980712329 Recovery of Online Redo Log: Thread 1 Group 1 Seq 13618 Reading mem 0 Mem# 0: /u02/oradata/db1/redo_1_1.log Mem# 1: /u02/oradata/db1/redo_1_2.log Mem# 2: /u02/oradata/db1/redo_1_3.log Block recovery completed at rba 13618.59.16, scn 0.3980712330 Errors in file /u01/app/oracle/diag/rdbms/db1/db1/trace/db1_smon_11168.trc: ORA-01595: error freeing extent (10) of rollback segment (3)) ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] Starting background process SMCO SMCO started with pid=29, OS id=11268 Trace dumping is performing id=[cdmp_20160630111337] 2016-06-30 11:13:37.819000 +05:30 Starting background process CJQ0 CJQ0 started with pid=28, OS id=11276 2016-06-30 11:13:41.579000 +05:30 Errors in file /u01/app/oracle/diag/rdbms/db1/db1/trace/db1_j001_11285.trc (incident=1014942): ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/db1/db1/incident/incdir_1014942/db1_j001_11285_i1014942.trc Errors in file /u01/app/oracle/diag/rdbms/db1/db1/trace/db1_j004_11291.trc: 2016-06-30 11:13:43.111000 +05:30 Doing block recovery for file 3 block 26014 Resuming block recovery (PMON) for file 3 block 26014 Block recovery from logseq 13618, block 56 to scn 3980712372 Recovery of Online Redo Log: Thread 1 Group 1 Seq 13618 Reading mem 0 Mem# 0: /u02/oradata/db1/redo_1_1.log Mem# 1: /u02/oradata/db1/redo_1_2.log Mem# 2: /u02/oradata/db1/redo_1_3.log Block recovery completed at rba 13618.106.16, scn 0.3980712374 Errors in file /u01/app/oracle/diag/rdbms/db1/db1/trace/db1_j000_11283.trc (incident=1014934): ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/db1/db1/incident/incdir_1014934/db1_j000_11283_i1014934.trc Trace dumping is performing id=[cdmp_20160630111343] 2016-06-30 11:13:45.937000 +05:30 Doing block recovery for file 3 block 26014 Resuming block recovery (PMON) for file 3 block 26014 Block recovery from logseq 13618, block 56 to scn 3980712372 Recovery of Online Redo Log: Thread 1 Group 1 Seq 13618 Reading mem 0 Mem# 0: /u02/oradata/db1/redo_1_1.log Mem# 1: /u02/oradata/db1/redo_1_2.log Mem# 2: /u02/oradata/db1/redo_1_3.log Block recovery completed at rba 13618.106.16, scn 0.3980712374 Errors in file /u01/app/oracle/diag/rdbms/db1/db1/trace/db1_j000_11283.trc: ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] Errors in file /u01/app/oracle/diag/rdbms/db1/db1/trace/db1_j001_11285.trc (incident=1014943): ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/db1/db1/incident/incdir_1014943/db1_j001_11285_i1014943.trc 2016-06-30 11:13:46.903000 +05:30 Trace dumping is performing id=[cdmp_20160630111346] 2016-06-30 11:13:48.279000 +05:30 Errors in file /u01/app/oracle/diag/rdbms/db1/db1/trace/db1_j001_11285.trc: ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] Trace dumping is performing id=[cdmp_20160630111349] Incident details in: /u01/app/oracle/diag/rdbms/db1/db1/incident/incdir_1019488/db1_j001_11285_i1019488.trc Errors in file /u01/app/oracle/diag/rdbms/db1/db1/incident/incdir_1019488/db1_j001_11285_i1019488.trc: ORA-00603: ORACLE server session terminated by fatal error ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] Trace dumping is performing id=[cdmp_20160630111351] 2016-06-30 11:13:53.489000 +05:30 Doing block recovery for file 3 block 26014 Resuming block recovery (PMON) for file 3 block 26014 Block recovery from logseq 13618, block 56 to scn 3980712372 Recovery of Online Redo Log: Thread 1 Group 1 Seq 13618 Reading mem 0 Mem# 0: /u02/oradata/db1/redo_1_1.log Mem# 1: /u02/oradata/db1/redo_1_2.log Mem# 2: /u02/oradata/db1/redo_1_3.log Block recovery completed at rba 13618.106.16, scn 0.3980712374 Errors in file /u01/app/oracle/diag/rdbms/db1/db1/trace/db1_pmon_11144.trc (incident=1014702): ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/db1/db1/incident/incdir_1014702/db1_pmon_11144_i1014702.trc 2016-06-30 11:13:55.766000 +05:30 Errors in file /u01/app/oracle/diag/rdbms/db1/db1/trace/db1_pmon_11144.trc: ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], [] PMON (ospid: 11144): terminating the instance due to error 472 Instance terminated by PMON, pid = 11144
Workaround:
Startup database in mount mode:
SQL> startup mount;
Check current undo tablespace:
SQL> show parameter undo_tablespace;
Alter undo management to ‘MANUAL’:
SQL> alter system set undo_management='MANUAL' scope=spfile;
Bounce database to open mode, meanwhile please verify adrci logs, if there is problem.
SQL> shut immediate; SQL> startup;
Create new undo tablespace if everything is fine in adrci logs:
SQL> create undo tablespace newundotbs datafile '/u02/oradata/db1/newundotbs01.dbf' size 5G autoextend on next 300M maxsize 31G;
Change default undo tablespace to new one:
SQL> alter system set undo_tablespace='NEWUNDOTBS' scope=spfile;
Alter undo management to ‘AUTO’:
SQL> alter system set undo_management='AUTO' scope=spfile;
Bounce the database:
SQL> shut immediate; SQL> startup;
Verify current undo tablespace:
SQL> show parameter undo_tablespace
done.
Thank you.
Stay Tune. 🙂
Thank you so much ,it is working ,thanks for your great effort
Great, it has been a great help to me