undo表空間刪除的問題，求解。

counter1219

undo表空間數(shù)據(jù)文件'/archdata/migtemp/undotbs01.dbf'  被誤刪了，現(xiàn)在應(yīng)該怎么操作，


SQL>  alter database datafile '/archdata/migtemp/undotbs01.dbf' offline for drop;

Database altered.

SQL>  create undo tablespace undotbs8 datafile '/archdata/migtemp/undotbs08.dbf' size 1000M;
create undo tablespace undotbs8 datafile '/archdata/migtemp/undotbs08.dbf' size 1000M
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00376: file 3 cannot be read at this time
ORA-01110: data file 3: '/archdata/migtemp/undotbs01.dbf'


想按照下面的操作操作下去，操作不了了，
steps
/archdata/migtemp/undotbs01.dbf

1) recover datafile '/archdata/migtemp/undotbs01.dbf' ;

2) alter database datafile '/archdata/migtemp/undotbs01.dbf' offline for drop;

3) create undo tablespace undotbs8 datafile '/archdata/migtemp/undotbs08.dbf' size 1000M;  (from above post)

4) alter system set undo_tablespace=undotbs8 scope=both;

5) alter system set undo_management=manual scope = spfile;

6) shutodwn immediate;

7) startup

select status,  TABLESPACE_NAME ,file_name from dba_data_files;

alter database open;