1、首先热备份数据库

alter tablespace SYSTEM begin backup;

! cp /u01/app/oracle/oradata/SAFE/system01.dbf /u02/backup/SAFE

alter tablespace SYSTEM end backup;

alter tablespace UNDOTBS1 begin backup;

! cp /u01/app/oracle/oradata/SAFE/undotbs01.dbf /u02/backup/SAFE

alter tablespace UNDOTBS1 end backup;

alter tablespace SYSAUX begin backup;

! cp /u01/app/oracle/oradata/SAFE/sysaux01.dbf /u02/backup/SAFE

alter tablespace SYSAUX end backup;

alter tablespace USERS begin backup;

! cp /u01/app/oracle/oradata/SAFE/users01.dbf /u02/backup/SAFE

alter tablespace USERS end backup;

alter database backup controlfile to '/u02/backup/SAFE/control01.dbf';

[oracle@zhang SAFE]$ ls

control01.ctl  sysaux01.dbf  system01.dbf  undotbs01.dbf  users01.dbf

2、模拟灾难

[root@zhang\:/u01/app/oracle/oradata/SAFE]#rm *.dbf

3、转储文件

alter database rename file '/u01/app/oracle/oradata/SAFE/system01.dbf' to '/u02/backup/SAFE/system01.dbf';

alter database rename file '/u01/app/oracle/oradata/SAFE/undotbs01.dbf' to '/u02/backup/SAFE/undotbs01.dbf';

alter database rename file '/u01/app/oracle/oradata/SAFE/sysaux01.dbf' to '/u02/backup/SAFE/sysaux01.dbf';

alter database rename file '/u01/app/oracle/oradata/SAFE/users01.dbf' to '/u02/backup/SAFE/users01.dbf';

4、恢复数据库

SQL> recover database;

Media recovery complete.

5、开库

SQL> alter database open;

Database altered.