RMAN 恢复 Controlfile
NAME
--------------------------------------------------------------------------------
/home/oracle/app/oracle/oradata/orcl/control01.ctl
/home/oracle/app/oracle/fast_recovery_area/orcl/control02.ctl
total 1147140-rw-r-----. 1 oracle oinstall 9797632 May 4 14:35 o1_mf_ncnnf_TAG20180504T143519_fgqzs8z6_.bkp-rw-r-----. 1 oracle oinstall 9797632 May 4 16:43 o1_mf_ncnnf_TAG20180504T164353_fgr7bbtk_.bkp-rw-r-----. 1 oracle oinstall 9830400 May 4 15:39 o1_mf_ncsnf_TAG20180504T153957_fgr3lgw1_.bkp-rw-r-----. 1 oracle oinstall 9830400 May 4 15:42 o1_mf_ncsnf_TAG20180504T154139_fgr3pgd5_.bkp-rw-r-----. 1 oracle oinstall 1135411200 May 4 15:42 o1_mf_nnndf_TAG20180504T154139_fgr3on7k_.bkp这里选择最新的,及o1_mf_ncsnf_TAG20180504T154139_fgr3pgd5_.bkp;
b.关闭数据库:shutdown abort(这里只能强制关闭,shutdown immediate 会报错)
c.启动数据库到nomount状态
d.进入RMAN,执行:
RMAN> restore controlfile from '/home/oracle/app/oracle/fast_recovery_area/ORCL/backupset/2018_05_04/o1_mf_ncnnf_TAG20180504T164353_fgr7bbtk_.bkp';
Starting restore at 04-MAY-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=7 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/home/oracle/app/oracle/oradata/orcl/control01.ctl
output file name=/home/oracle/app/oracle/fast_recovery_area/orcl/control02.ctl
Finished restore at 04-MAY-18
e.启动到mount
alter database mount;
f.恢复数据库
recover database
g.open数据库
alter database open resetlogs;
至此完成controlfile的 恢复。
PS:小弟初学入门中,如有错误或不全面的地方还请各位大神指正,感谢!