冷备份----删除系统表空间

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;