Summary of oracle8i undo tablespace Corruption (ORA-01092 and ORA-00600 "4193") in the case of incomplete database recovery experience

A server power-down restart causes the recovery Catalog Library of the backup production environment to fail to start, prompting the Ora-01092 routine to terminate. Forcibly disconnecting the connection

To view the trace log:

Wed Jan 10 08:41:37 2018

Errors in file D:\Oracle\admin\l3bckdb\bdump\l3bckdbSMON.TRC:

Ora-00600:internal error code, arguments: [4193], [1836], [1844], [], [], [], [], []

Wed Jan 10 08:41:39 2018

Errors in file D:\Oracle\admin\l3bckdb\bdump\l3bckdbSNP1.TRC:

Ora-00600:internal error code, arguments: [4193], [1926], [1934], [], [], [], [], []

Recovery of Online Redo log:thread 1 Group 3 Seq Reading Mem 0

mem# 0 errs 0:d:\oracle\oradata\l3bckdb\redo01. LOG

Wed Jan 10 08:41:42 2018

Recovery of Online Redo log:thread 1 Group 3 Seq Reading Mem 0

mem# 0 errs 0:d:\oracle\oradata\l3bckdb\redo01. LOG

Wed Jan 10 08:41:42 2018

Smon:terminating instance due to error 600

Instance terminated by Smon, PID = 2744

Find the relevant information, found ra-600[4913] Error 2 argument meaning, the ora-600[4913] belongs to the kernel undo transaction module

[1836] Undo record SEQ number

[1844] Redo record SEQ number

An error was raised due to an inconsistent undo sequence and redo sequence.

WORKAROUND: Rebuild the Undo tablespace with the following steps:

C:/>set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

C:/>sqlplus "/As SYSDBA"

Sql*plus:release 8.1.7.0.0-production on Wednesday January 10 11:28:47 2018

(c) Copyright: Oracle Corporation. All rights reserved.

Connect to:

Oracle8i Enterprise Edition Release 8.1.7.0.0-production

With the partitioning option

Jserver Release 8.1.7.0.0-production

Sql> Select File#,name from V$datafile where file#=2;

file# NAME

---------- ----------------------------------------

2 d:/oracle/oradata/bccheck/rbs01. Dbf

sql> shutdown Immediate

ORA-01109: The database is not open.

The database has been uninstalled.

The Oracle routine is closed.

Sets the Rollback_segments initialization parameter in the Init.ora file to the restricted mode of the Mount database after the annotation is set.

#rollback_segments = (RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6)

Sql> startup Restrict Mount

Oracle routine is started.

Total System Global area 219895052 bytes

Fixed Size 70924 bytes

Variable Size 75116544 bytes

Database buffers 144629760 bytes

Redo buffers 77824 bytes

The database is loaded.

Drop the corrupted RBS data file online and retry opening the database

Sql> drop tablespace RBS including contents;

Drop tablespace RBS including contents

*

ERROR in row 1:

Ora-01548:active rollback segment ' RBS0 ' found, terminate dropping tablespace

--Error ORA-01548, indicating an active rollback segment

Sql> select Segment_name,tablespace_name,status from Dba_rollback_segs;

Segment_name Tablespace_name STATUS

------------------------------ ------------------------------ ----------------

System System ONLINE

RBS0 RBS NEEDS RECOVERY

RBS1 RBS NEEDS RECOVERY

RBS2 RBS NEEDS RECOVERY

RBS3 RBS NEEDS RECOVERY

RBS4 RBS NEEDS RECOVERY

RBS5 RBS NEEDS RECOVERY

RBS6 RBS NEEDS RECOVERY

8 rows have been selected

sql> shutdown Immediate

--Normal Shutdown database Add implicit function _corrupted_rollback_segments, modify parameter file to add implicit parameter

_corrupted_rollback_segments= (RBS0,RBS1,RBS2,RBS3,RBS4,RBS5,RBS6) after opening the database in restricted mode

Sql> startup Restrict

Sql> select Segment_name,tablespace_name,status from Dba_rollback_segs;

Segment_name Tablespace_name STATUS

------------------------------ ------------------------------ ----------------

System System ONLINE

RBS0 RBS NEEDS RECOVERY

RBS1 RBS NEEDS RECOVERY

RBS2 RBS NEEDS RECOVERY

RBS3 RBS NEEDS RECOVERY

RBS4 RBS NEEDS RECOVERY

RBS5 RBS NEEDS RECOVERY

RBS6 RBS NEEDS RECOVERY

8 rows have been selected

Sql> drop tablespace RBS including contents;

Drop tablespace RBS including contents

*

ERROR in row 1:

Ora-01548:active rollback segment ' RBS0 ' found, terminate dropping tablespace

Force the removal of required rollback segments

After you delete the table space that contains the corrupted rollback segment, and start to build the rollback segment table space

Query rollback segment Status

Gracefully shuts down the database, _corrupted_rollback_segments the implied parameters in the parameter file, and joins the rollback_segments to all rollback segments.

Normal Startup database

Summary of oracle8i undo tablespace Corruption (ORA-01092 and ORA-00600 "4193") in the case of incomplete database recovery experience