Cold backup ----- Delete Undo tablespace

1. Delete the undo tablespace

Rm-f undotbs01.dbf

2. Error

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. Restore data files

Alter database datafile 2 online

 

4. alter system checkpoint

Select status from v $ datafile;