oracle ORA-00607,ORA-006000错误

几天在shutdown oracle时报错：

SQL> shutdown immediate

ORA-00607: Internal error occurred while making a change to a data block

ORA-00600: internal error code, arguments: [4194], [55], [29], [], [], [], [],

这是由于undo表空间引起的，undo表空间设置为auto，改变为manual后，可以顺利shutdown数据库，但是这也不是最中解决办法。

可以选择重建undo，

SQL> create undo tablespace undo2 datafile '/app/oracle/oradata/lqd/undo2.dbf' size 200M;

Tablespace created.

SQL> alter system set undo_tablespace =undo2 scope=spfile;

System altered.

SQL> drop tablespace undotbs1 including contents and datafiles;

Tablespace dropped.

SQL> 

SQL> 

SQL> create undo tablespace undotbs1 datafile '/app/oracle/oradata/lqd/undotbs01.dbf' size 200M;

Tablespace created.

SQL> alter system set undo_tablespace=undotbs1;

alter system set undo_tablespace=undotbs1

*

ERROR at line 1:

ORA-02097: parameter cannot be modified because specified value is invalid

ORA-30014: operation only supported in Automatic Undo Management mode

SQL> alter system set undo_tablespace=undotbs1 scope=spfile;

System altered.

SQL> drop tablespace undo2 including contents and datafiles;

Tablespace dropped.

SQL> alter system set undo_management=auto scope=spfile;

System altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  608174080 bytes

Fixed Size                  1220820 bytes

Variable Size             171970348 bytes

Database Buffers          427819008 bytes

Redo Buffers                7163904 bytes

Database mounted.

Database opened.

SQL> show parameter undo

NAME                                 TYPE        VALUE

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

undo_management                      string      AUTO

undo_retention                       integer     900

undo_tablespace                      string      UNDOTBS1

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startu[

SP2-0042: unknown command "startu[" - rest of line ignored.

SQL> startup

ORACLE instance started.

Total System Global Area  608174080 bytes

Fixed Size                  1220820 bytes

Variable Size             171970348 bytes

Database Buffers          427819008 bytes

Redo Buffers                7163904 bytes

Database mounted.

Database opened.

SQL> 

问题解决

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

转载于:http://blog.itpub.net/22418990/viewspace-721079/