【控制文件丢失-恢复-1】(三)
le/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_3_b5ozgwpw_.arc
File Name: /u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_5_b5p1c4ho_.arc
File Name: /u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_1_b5p24r2c_.arc
File Name: /u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_5_b5ozjrrr_.arc
File Name: /u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_4_b5p1c4do_.arc
File Name: /u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_6_b5p1c4l4_.arc
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 /u01/oracle/oradata/jadl10g/system01.dbf
restoring datafile 00002 to /u01/oracle/oradata/jadl10g/undotbs01.dbf
restoring datafile 00003 to /u01/oracle/oradata/jadl10g/sysaux01.dbf
restoring datafile 00004 to /u01/oracle/oradata/jadl10g/users01.dbf
restoring datafile 00005 to /u01/oracle/oradata/jadl10g/example01.dbf
channel ORA_DISK_1: reading from backup piece /u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T123548_b5oyo4xm_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/oracle/flash_recovery_area/JADL10G/backupset/2014_11_06/o1_mf_nnndf_TAG20141106T123548_b5oyo4xm_.bkp tag=TAG20141106T123548
channel ORA_DISK_1: restore complete, elapsed time: 00:00:46
Finished restore at 06-NOV-14
RMAN> recover database;
Starting recover at 06-NOV-14
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 3 is already on disk as file /u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_3_b5ozgwpw_.arc
archive log thread 1 sequence 4 is already on disk as file /u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_4_b5p1c4do_.arc
archive log thread 1 sequence 1 is already on disk as file /u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_1_b5p24r2c_.arc
archive log filename=/u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_3_b5ozgwpw_.arc thread=1 sequence=3
archive log filename=/u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_4_b5p1c4do_.arc thread=1 sequence=4
archive log filename=/u01/oracle/flash_recovery_area/JADL10G/archivelog/2014_11_06/o1_mf_1_1_b5p24r2c_.arc thread=1 sequence=1
unable to find archive log
archive log thread=1 sequence=2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/06/2014 13:46:47
RMAN-06054: media recovery requesting unknown log: thread 1 seq 2 lowscn 424301
RMAN>
recover database until logseq 2; ---注意此处：恢复到日志序列号为2的地方，之后的数据肯定就是丢失啦
Starting recover at 06-NOV-14
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:03
Finished recover at 06-NOV-14
RMAN> alter database open resetlogs; ---打开数据库
database opened
RMAN> ex