（高手帮我看下)非归档，无备份，要对1个还原文件进行介...

ALLSTARS_ORACLE

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'