幾天在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> 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>

問題解決

oracle ORA-00607,ORA-006000錯誤

相關文章