【控制文件丢失-恢复-1】(五)
u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06
o1_mf_annnn_BACKUP_JADL10G_000_1_b5nlkxph_.bkp
o1_mf_ncnnf_TAG20141106T013740_b5nr3599_.bkp
o1_mf_ncsnf_BACKUP_JADL10G_000_1_b5nlkr13_.bkp
o1_mf_ncsnf_TAG20141106T001636_b5nmdmv8_.bkp
o1_mf_ncsnf_TAG20141106T021509_b5ntbwdp_.bkp
o1_mf_ncsnf_TAG20141106T052124_b5o59df8_.bkp
o1_mf_ncsnf_TAG20141106T103719_b5oqr4bc_.bkp
o1_mf_nnndf_BACKUP_JADL10G_000_1_b5nljc9p_.bkp
o1_mf_nnndf_TAG20141106T001636_b5nmc58w_.bkp
o1_mf_nnndf_TAG20141106T021509_b5nt9fsr_.bkp
o1_mf_nnndf_TAG20141106T052124_b5o56ok0_.bkp
o1_mf_nnndf_TAG20141106T103719_b5oqpzy9_.bkp
[oracle@oracle ~]$ rman target /
Recovery Manager: Release 10.2.0.5.0 - Production on Thu Nov 6 10:56:40 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: jadl10g (not mounted)
----也可以采用如下的命令执行恢复，注意此路径的中备份必须存在，是ncsnf开头的。
RMAN> restore controlfile from '/u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_ncsnf_TAG20141106T103719_b5oqr4bc_.bkp';
Starting restore at 06-NOV-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=/u01/oracle/oradata/jadl10g/control01.ctl
output filename=/u01/oracle/flash_recovery_area/jadl10g/control02.ctl
Finished restore at 06-NOV-14
RMAN> alter database mount; --启动到mount
database mounted
released channel: ORA_DISK_1
RMAN> recover database; --恢复数据库
Starting recover at 06-NOV-14
Starting implicit crosscheck backup at 06-NOV-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK
Crosschecked 1 objects
Finished implicit crosscheck backup at 06-NOV-14
Starting implicit crosscheck copy at 06-NOV-14
using channel ORA_DISK_1
Finished implicit crosscheck copy at 06-NOV-14
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_ncsnf_TAG20141106T103719_b5oqr4bc_.bkp
File Name: /u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_31_b5or9wnr_.arc
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 31 is already on disk as file /u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_31_b5or9wnr_.arc
archive log thread 1 sequence 32 is already on disk as file /u01/oracle/oradata/jadl10g/redo02.log
archive log filename=/u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_31_b5or9wnr_.arc thread=1 sequence=31
archive log filename=/u01/oracle/oradata/jadl10g/redo02.log thread=1 sequence=32
media recovery complete, elapsed time: 00:00:03
Finished recover at 06-NOV-14
RMAN>
alter database open resetlogs; ---执行该命令后，需要重新备份数据库，之前的备份无效了。
database opened
RMAN> backup database;
Starting backup at 06-NOV-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u0