（高手帮我看下)非归档，无备份，要对1个还原文件进行介...
11G, 非归档，无备份，需要对1个还原文件进行介质恢复，日志已覆盖,无法介质恢复
把这个文件offline drop后是可以打开数据库的
现在我想把这个还原文件去掉，或者重建一个新的还原表空间，drop掉旧的还原表空间，但都因目前这个还原文件需要恢复，无法进行，请高手指教如何达到这个目的，或者有更好的方法
SQL> alter database datafile 159 offline drop;
Database altered.
SQL> alter database open;
Database altered.
SQL> create undo tablespace undotbs2 datafile '/pool02/test2/db/apps_st/data/undotbs2.dbf' size 1024M
2 ;
create undo tablespace undotbs2 datafile '/pool02/test2/db/apps_st/data/undotbs2.dbf' size 1024M
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 159 cannot be read at this time
ORA-01110: data file 159: '/u02/temp_file/undo02.dbf'
SQL> drop tablespace APPS_UNDOTS1;
drop tablespace APPS_UNDOTS1
*
ERROR at line 1:
ORA-30013: undo tablespace 'APPS_UNDOTS1' is currently in use
SQL> alter tablespace APPS_UNDOTS1 drop datafile '/u02/temp_file/undo02.dbf';
alter tablespace APPS_UNDOTS1 drop datafile '/u02/temp_file/undo02.dbf'
*
ERROR at line 1:
ORA-03264: cannot drop offline datafile of locally managed tablespace
SQL>alter database datafile 159 online;
alter database datafile 159 online
*
ERROR at line 1:
ORA-01113: file 159 needs media recovery
ORA-01110: data file 159: '/u02/temp_file/undo02.dbf'
SQL> recover datafile 159;
ORA-00279: change 10159863563234 generated at 11/30/2012 09:55:58 needed for
thread 1
ORA-00289: suggestion :
/pool02/test2/db/apps_st/data_01/archive/1_1141_791038004.dbf
ORA-00280: change 10159863563234 for thread 1 is in sequence #1141
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/pool02/test2/db/apps_st/data_01/archive/1_1141_791038004.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /pool02/test2/db/apps_st/data_01/archive
Oldest online log sequence 1142
Current log sequence 1144
目录下这个1141 日志文件已经没有了，在线日志也无法恢复
楼上，无法创建呀
SQL> create undo tablespace undotbs2 datafile '/pool02/test2/db/apps_st/data/undotbs2.dbf' size 1024M
2 ;
create undo tablespace undotbs2 datafile '/pool02/test2/db/apps_st/data/undotbs2.dbf' size 1024M
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 159 cannot be read at this time
ORA-01110: data file 159: '/u02/temp_file/undo02.dbf'
页:
[1]