冷备份-----删除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;