出现 ORA-01555 ORA-00704: ORA-00604: 如何解决？

ALLSTARS_ORACLE

进行一些测试，先新建了表空间tb1，
create tablespace tb1 datafile '/oracle/oradata/ABCD/tb1.dbf' size 100m;
建立了表
create table aa(a int ) tablespace tb1;

然后OS下删除了数据文件tb101.dbf，

此时在其他sql窗口中，仍然向aa表里插入了1万行数据；
关闭数据库，重新打开数据库；发现不能启动；
就使用alter database create  datafile 重建了tb101.dbf， 然后使用recover datafile 5 发现不能恢复tb101.dbf；
再使用 alter system set "_allow_resetlogs_corruption"=TRUE scope=spfile; 打开数据库，发现出错；
alert中有如下错误：

Fri Jan 17 14:51:09 2014
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jan 17 14:51:09 2014
SMON: enabling cache recovery
ORA-01555 caused by SQL statement below (SQL ID: 4krwuz0ctqxdt, SCN: 0x0000.0010911d):
select ctime, mtime, stime from obj$ where obj# = :1
Errors in file /oracle/diag/rdbms/abcd/ABCD/trace/ABCD_ora_5366.trc:
ORA-00704: ????????
ORA-00704: ????????
ORA-00604: ?? SQL ?? 1 ????
ORA-01555: ????: ???? 8 (??? "_SYSSMU8_2012382730$") ??
Errors in file /oracle/diag/rdbms/abcd/ABCD/trace/ABCD_ora_5366.trc:
ORA-00704: ????????
ORA-00704: ????????
ORA-00604: ?? SQL ?? 1 ????
ORA-01555: ????: ???? 8 (??? "_SYSSMU8_2012382730$") ??
Error 704 happened during db open, shutting down database
USER (ospid: 5366): terminating the instance due to error 704
Instance terminated by USER, pid = 5366
ORA-1092 signalled during: alter database open...
opiodr aborting process unknown ospid (5366) as a result of ORA-1092
Fri Jan 17 14:51:12 2014
ORA-1092 : opitsk aborting process

应该是执行 select ctime, mtime, stime from obj$ where obj# = :1 时出错，那么，我该如何处理呢？



SQL> conn / as sysdba
已连接到空闲例程。
SQL> startup mount
ORACLE 例程已经启动。

Total System Global Area  897740800 bytes
Fixed Size                    2258440 bytes
Variable Size                  553650680 bytes
Database Buffers          335544320 bytes
Redo Buffers                    6287360 bytes
数据库装载完毕。
SQL> alter database datafile 5 offline;

数据库已更改。

SQL>
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01555: snapshot too old: rollback segment number 8 with name
"_SYSSMU8_2012382730$" too small
进程 ID: 3981
会话 ID: 1 序列号: 5


我的是 11.2.0.4的环境；
我在网上查了这个 ORA-01555: snapshot too old: rollback segment number 8 with name 错误，惜总有文章对于 11g 这种情况，做了一些说明；以及对于 _offline_rollback_segments和_corrupted_rollback_segments  ；  
使用道具 举报