冷备份----删除系统表空间
冷备份----删除系统表空间
1.rm -f system01.dbf
2.关闭数据库报错
SQL> shutdown immediate
ORA-01116: error in opening database file 1
ORA-01110: data file 1: '/u01/app/Oracle/oradata/demo/system01.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
3.强制关闭数据库
SQL> shutdown abort
ORACLE instance shut down.
4.恢复文件到原来路径下
cp system01.dbf /u01/app/oracle/oradata/demo/
5.启动到mount状态
startup mount
6.恢复数据库
recover database ;
7.启动数据库
alter database open;
评论暂时关闭