1.数据库open状态，有自动备份的信息，恢复控制文件
RMAN> restore controlfile to '/home/oracle/control01.ctl' from autobackup;

Starting restore at 14-MAR-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=544 devtype=DISK

recovery area destination: /oracle/u01/app/oracle/flash_recovery_area
database name (or database unique name) used for search: ORA10G
channel ORA_DISK_1: autobackup found in the recovery area
channel ORA_DISK_1: autobackup found: /oracle/u01/app/oracle/flash_recovery_area/ORA10G/autobackup/2009_03_14/o1_mf_s_681463726_4vov1jf8_.bkp
channel ORA_DISK_1: control file restore from autobackup complete
Finished restore at 14-MAR-09

RMAN> exit

Recovery Manager complete.
ora10g@linux5 /home/oracle$ ls -l control*
-rw-r----- 1 oracle oinstall 7061504 Mar 14 08:10 control01.ctl

2.无法mount，在nomount状态下知道备份文件的名称，恢复控制文件
RMAN> restore controlfile to '/home/oracle/control01.ctl' from '/oracle/u01/app/oracle/flash_recovery_area/ORA10G/autobackup/2009_03_14/o1_mf_s_681463726_4vov1jf8_.bkp';

Starting restore at 14-MAR-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=526 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 14-MAR-09
注：此种情况在10g中亦可以通过自动备份的信息进行恢复（from autobackup），在9i环境下通过自动备份的信息进行恢复会报错，只能使用这种方法进行恢复

secooler
09.03.13

-- The End --

ITPub博客

【实验】从RMAN备份中恢复controlfile控制文件

最新文章