冷备份-----删除Undo表空间
冷备份-----删除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;
评论暂时关闭