本帖最后由 wrd54123 于 2012-3-28 12:59 编辑
机器之前有过断电,启动启动报如下错:
Errors in file /home/oracle/app/oracle/diag/rdbms/eplus134/eplus134/trace/eplus134_ora_34406482.trc:
ORA-01578: ORACLE data block corrupted (file # 3, block # 176)
ORA-01110: data file 3: '/home/oracle/app/oracle/oradata/eplus134/undotbs01.dbf'
Error 1578 happened during db open, shutting down database
USER (ospid: 34406482): terminating the instance due to error 1578
Instance terminated by USER, pid = 34406482
ORA-1092 signalled during: ALTER DATABASE OPEN...
试了_offline_rollback_segments和_corrupted_rollback_segments来跳过坏块,发现都不行还是启不来
启动到mount查询
SQL> select * from v$database_block_corruption;
FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
3 7744 1 0 FRACTURED
3 240 1 0 FRACTURED
3 4874 1 0 FRACTURED
3 8312 1 0 FRACTURED
3 2263 1 0 FRACTURED
3 404 1 0 FRACTURED
3 176 1 0 FRACTURED
18 1798 1 0 FRACTURED
18 18643 1 0 FRACTURED
19 36364 1 0 FRACTURED
19 36298 1 0 FRACTURED
坏块的文件好多啊