冷備份-----刪除Undo資料表空間

1.刪除undo資料表空間

rm -f undotbs01.dbf

2.報錯

SQL> create table t3 as select * from dba_objects where rownum < 3;
create table t3 as select * from dba_objects where rownum < 3
                                 *
ERROR at line 1:
ORA-01116: error in opening database file 2
ORA-01110: data file 2: '/u01/app/Oracle/oradata/demo/undotbs01.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3

 

3.恢複資料檔案

alter database datafile 2 online

 

4.alter system checkpoint

select status from v$datafile;