问题二:
然后,我重新启动数据库后,发现报错:
'/export/home/oracle/oradata/oracle/rbstest01.ora'
数据文件不存在,由于数据库是非归档方式于是我:
alter database datafile '/export/home/oracle/oradata/oracle/rbstest01.ora' offline drop;
数据库能够正常启动
我在SQL*PLUS中运行:
SQL> drop tablespace rbstest;
drop tablespace rbstest
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 13 cannot be read at this time
ORA-01110: data file 13: '/export/home/oracle/oradata/oracle/rbstest01.ora'
然后运行:
SQL> select tablespace_name from dba_tablespaces;
select tablespace_name from dba_tablespaces
*
ERROR at line 1:
ORA-00376: file 13 cannot be read at this time
ORA-01110: data file 13: '/export/home/oracle/oradata/oracle/rbstest01.ora'
但是在V$rollname和v$rollstat中已经没有以上创建的2个回滚段的任何信息了
我在初始化参数中加了
_corrupted_rollback_segments=(rbstest1,rbstest2)
重新启动数据库后还是不行
现在查询
dba_tablespaces,dba_rollback_segs 等视图,还是报错:
SQL> select file_name from dba_data_files;
ERROR:
ORA-00376: file 13 cannot be read at this time
ORA-01110: data file 13: '/export/home/oracle/oradata/oracle/rbstest01.ora'
改怎么处理呢?
SQL> alter rollback segment rbstest01 offline;
alter rollback segment rbstest01 offline
*
ERROR at line 1:
ORA-01598: rollback segment 'RBSTEST01' is not online
SQL> drop rollback segment rbstest01;
drop rollback segment rbstest01
*
ERROR at line 1:
ORA-01545: rollback segment 'RBSTEST01' specified not available