（1）准备全备份

RMAN> backup database;

（2）由于ASM，先关闭两个INSTANCE，删除数据文件，联机日志，控制文件

SQL> startup mount

ASMCMD> ls
group_1.257.794232617
group_2.258.794232619
group_3.265.794234279
group_4.266.794234285
ASMCMD> rm *

（3）启动到nomount，从备份中恢复控制文件

SQL> startup nomount

RMAN> restore controlfile from '+rac_disk/racdb/backupset/2012_09_27/ncsnf0_TAG20120927T093645_0.279.795087479';

（4）启动到mount，恢复数据库

SQL> alter database mount;

RMAN> restore database;

Starting restore at 27-SEP-12
Starting implicit crosscheck backup at 27-SEP-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
Crosschecked 1 objects
Finished implicit crosscheck backup at 27-SEP-12

Starting implicit crosscheck copy at 27-SEP-12
using channel ORA_DISK_1
Finished implicit crosscheck copy at 27-SEP-12

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: +rac_disk/RACDB/FLASHBACK/1_56_794232606.dbf
File Name: +rac_disk/RACDB/FLASHBACK/1_57_794232606.dbf
File Name: +rac_disk/RACDB/FLASHBACK/1_58_794232606.dbf
File Name: +rac_disk/RACDB/FLASHBACK/2_27_794232606.dbf
File Name: +rac_disk/RACDB/FLASHBACK/2_28_794232606.dbf
File Name: +rac_disk/RACDB/BACKUPSET/2012_09_27/ncsnf0_TAG20120927T093645_0.279.795087479

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to +RAC_DISK/racdb/datafile/system.259.794232627
restoring datafile 00002 to +RAC_DISK/racdb/datafile/undotbs1.260.794232647
restoring datafile 00003 to +RAC_DISK/racdb/datafile/sysaux.261.794232657
restoring datafile 00004 to +RAC_DISK/racdb/datafile/undotbs2.263.794232675
restoring datafile 00005 to +RAC_DISK/racdb/datafile/users.264.794232683
restoring datafile 00006 to +RAC_DISK/racdb/datafile/xhm.302.795004969
restoring datafile 00007 to +RAC_DISK/racdb/datafile/users.301.795004951
channel ORA_DISK_1: reading from backup piece +RAC_DISK/racdb/backupset/2012_09_27/nnndf0_tag20120927t093645_0.278.795087409
channel ORA_DISK_1: restored backup piece 1
piece handle=+RAC_DISK/racdb/backupset/2012_09_27/nnndf0_tag20120927t093645_0.278.795087409 tag=TAG20120927T093645
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
Finished restore at 27-SEP-12
注意查看加黑部分，ORACLE自动注册了最新的闪回区里的archivelog。
查看v$archived_log和磁盘中的最新archivelog记录。控制文件中确实已存在最新的archivelog。

（5）由于使用旧控制文件，需要不完全恢复。

SQL> recover database using backup controlfile until cancel;

如果使用RMAN，方法如下：
run{
set until sequence 59 thread 1;
restore database;
recover database;
}

（6）以resetlogs打开数据库

SQL> alter database open resetlogs;