- 论坛徽章:
- 0
|
数据库启动报如下错误：
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [28], [25], [], [], [], [], []
从网上搜这倒是个比较典型的错误，主要是UNDO表空间有腐败段造成的！
但查看undo_tablespace是空的！
SQL> show parameter undo;
NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
undo_management string
MANUAL
undo_retention integer
900
undo_suppress_errors boolean
FALSE
undo_tablespace string
数据文件里也没有UNDO！
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/OraHome1/dbs/dbsora9gq.dbf
/OraHome1/dbs/rollbackora9gq.dbf
/OraHome1/dbs/tempora9gq.dbf
/OraHome1/dbs/TSDATAora9gq.dbf
/OraHome1/dbs/TSINDEXora9gq.dbf
SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
ROLLBACK
TEMP
TSDATA
TSINDEX
SQL> select segment_name,tablespace_name,status from dba_rollback_segs;
SEGMENT_NAME TABLESPACE_NAME STATUS
------------------------------ ------------------------------ ----------------
SYSTEM SYSTEM ONLINE
RB1 ROLLBACK ONLINE
RB2 ROLLBACK ONLINE
RB3 ROLLBACK ONLINE
RB4 ROLLBACK ONLINE
因为没有就建一个，但手动创建UNDO表空间出错：
SQL> create undo tablespace undo2 datafile '/OraHome1/dbs/undo2.dbf' size 200M;
create undo tablespace undo2 datafile '/OraHome1/dbs/undo2.dbf' size 200M
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [28], [25], [], [], [], [],[]
又追踪了ORA-00604错误后还是老错误！
请问这样的情况该如何解决？？？
谢谢！！！ |
|
免费注册
发表于 2011-03-22 08:47
