ORA-00600: internal error code, arguments: [2023], [5], [1], [], [], [], [], []

ORA-00600: internal error code, arguments: [2023], [5], [1], [], [], [], [], []

Undo 手动清除回滚段方法

 

检查alertlog 发现一直在报如下错误

Thu Aug 23 07:48:59 2012

SMON: about to recover undo segment 14

Thu Aug 23 07:48:59 2012

Errors in file /export/home/oracle/admin/DEMOSFCS/bdump/demosfcs_smon_2038.trc:

ORA-00600: internal error code, arguments: [2023], [5], [1], [], [], [], [], []

Thu Aug 23 07:48:59 2012

License high water mark = 5

Thu Aug 23 07:49:02 2012

ALTER DATABASE CLOSE NORMAL

Thu Aug 23 07:49:03 2012

ORACLE Instance DEMOSFCS (pid = 6) - Error 600 encountered while recovering tran

saction (14, 41) on object 40314.

Thu Aug 23 07:49:03 2012

Errors in file /export/home/oracle/admin/DEMOSFCS/bdump/demosfcs_smon_2038.trc:

ORA-00600: internal error code, arguments: [2023], [5], [1], [], [], [], [], []

SMON: mark undo segment 14 as needs recovery

查看object 40314

SQL> select object_name,object_type,owner from dba_objects where object_id=40314;

 

OBJECT_NAME

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

OBJECT_TYPE        OWNER

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

SYS_LOB0000040313C00001$$

LOB                MGSSFCS

 

SQL> select owner,table_name,segment_name from dba_lobs where segment_name='SYS_LOB0000040313C00001$$';

 

OWNER                          TABLE_NAME

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

SEGMENT_NAME

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

MGSSFCS                        COMMON_MAIL_LOB

SYS_LOB0000040313C00001$$

 

 

SQL> select segment_id,segment_name, owner,status from dba_rollback_segs;

 

SEGMENT_ID SEGMENT_NAME                   OWNER  STATUS

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

         0 SYSTEM                         SYS    ONLINE

         1 _SYSSMU1$                      PUBLIC ONLINE

         2 _SYSSMU2$                      PUBLIC ONLINE

         3 _SYSSMU3$                      PUBLIC ONLINE

         4 _SYSSMU4$                      PUBLIC ONLINE

         5 _SYSSMU5$                      PUBLIC ONLINE

         6 _SYSSMU6$                      PUBLIC ONLINE

         7 _SYSSMU7$                      PUBLIC ONLINE

         8 _SYSSMU8$                      PUBLIC ONLINE

         9 _SYSSMU9$                      PUBLIC ONLINE

        10 _SYSSMU10$                     PUBLIC ONLINE

 

SEGMENT_ID SEGMENT_NAME                   OWNER  STATUS

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

        14 _SYSSMU14$                     PUBLIC NEEDS RECOVERY

查看14号回滚段需要恢复，使用方法：

将数据库关闭

Sql>shutdown immediate;

修改pfile文件，增加如下参数：

*._corrupted_rollback_segments=(_SYSSMU14$)

*._offline_rollback_segments=(_SYSSMU14$)

开启数据库

Sql>create spfile from pfiel;

Sql>startup;

SQL> drop rollback segment "_SYSSMU14$";

 

Rollback segment dropped.

 

SQL> create undo tablespace undotbs1 datafile '/Orabackup/DEMOSFCS/undotbs04.dbf' size 1024M autoextend on maxsize 4000M;

 

Tablespace created.

 

SQL> show parameter undo;

 

NAME                                 TYPE        VALUE

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

undo_management                      string      AUTO

undo_retention                       integer     900

undo_suppress_errors                 boolean     FALSE

undo_tablespace                      string      UNDOTBS

SQL> alter system set undo_tablespace=undotbs1;

 

System altered.

 

SQL> drop tablespace undotbs including contents and datafiles;

 

Tablespace dropped.

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24849178/viewspace-741674/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24849178/viewspace-741674/