- 论坛徽章:
- 0
|
undo表空间数据文件'/archdata/migtemp/undotbs01.dbf' 被误删了,现在应该怎么操作,
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;
|
|