ORA-00600: internal error code, arguments: [2032]

ktyl000 2014-02-11

遇到一个问题记录下来,呵呵

Shutdown immediate时候出现

SQL> shutdown immediate

ORA-00600: internal error code, arguments: [2032], [12587038], [12587038],

[8192], [2], [255], [0], [767], [], [], [], []

 

并且插入数据的时候出现

ORA-01110: 数据文件 3: '/data/Oracle/ORCL/undotbs01.dbf' 语句:insert into xxx(

xxx) values(xxx)

[2014-02-11 16:09:58] Connection::ExecSQL错误:ORA-01578: ORACLE数据块损坏 (文件号 3,块号 4126)

 

一般出现这个情况下是undo表空间损坏导致

 

 

更改系统undo表空间即可

查询undo表空间

SQL> show parameter undo_

 

NAME                                TYPE        VALUE

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

undo_management                      string      AUTO

undo_retention                      integer    900

undo_tablespace                      string      UNDOTBS1

 

SQL> select tablespace_name,contents from dba_tablespaces where contents='UNDO';

 

TABLESPACE_NAME                CONTENTS

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

UNDOTBS1                      UNDO

查询位置

SQL> select name from v$datafile;

 

NAME

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

/data/oracle/ORCL/system01.dbf

/data/oracle/ORCL/sysaux01.dbf

/data/oracle/ORCL/undotbs01.dbf

/data/oracle/ORCL/users01.dbf

/data/oracle/ORCL/example01.dbf

/data/oracle/ORCL/center/center01.dbf

/data/oracle/ORCL/test.dbf

/data/oracle/ORCL/test1.dbf

/data/oracle/ORCL/test2.dbf

/data/oracle/ORCL/system_02.dbf

 

添加文件

查询之前大小

SQL> select sum(bytes)/1024/1024 "current undo size(M)" from dba_data_files where tablespace_name='UNDOTBS1';

 

 

current undo size(M)

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

                2735

 

添加文件

SQL> create undo tablespace undo02 datafile '/data/oracle/ORCL/undotbs02.dbf' size 2800M;

系统已更改。

 

更改undo空间

SQL> alter system set undo_tablespace=undo02; 

 

System altered.

 

SQL> show parameter undo_

 

NAME                                TYPE        VALUE

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

undo_management                      string      AUTO

undo_retention                      integer    900

undo_tablespace                      string      UNDO02

 

验证

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

 

Total System Global Area  447778816 bytes

Fixed Size                  1337128 bytes

Variable Size            310380760 bytes

Database Buffers          130023424 bytes

Redo Buffers                6037504 bytes

Database mounted.

Database opened. 

当然可以手动模拟undo表空间损坏,这里不在演示

相关推荐