air script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_2101176755.hm contents of repair script: # restore and recover datafile restore datafile 4; recover datafile 4; RMAN>
REPAIR FAILURE; Strategy: The repair includes complete media recovery with no data loss Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_2101176755.hm contents of repair script: # restore and recover datafile restore datafile 4; recover datafile 4; Do you really want to execute the above repair (enter YES or NO) YES executing repair script Starting restore at 21-JUN-07 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/orcl/users01.dbf channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2007_06_21/o1_mf_nnnd f_TAG20070621T043615_37m7gpfp_.bkp channel ORA_DISK_1: piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2007_06_21/o1_ mf_nnndf_TAG20070621T043615_37m7gpfp_.bkp tag=TAG20070621T043615 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 Finished restore at 21-JUN-07 Starting recover at 21-JUN-07 using channel ORA_DISK_1 starting media recovery archived log for thread 1 with sequence 20 is already on disk as file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_06_21/o1_mf_1_2 0_37m7lhgx_.arc archived log for thread 1 with sequence 21 is already on disk as file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_06_21/o1_mf_1_2 1_37m7llgp_.arc archived log for thread 1 with sequence 22 is already on disk as file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_06_21/o1_mf_1_2 2_37m7logv_.arc archived log for thread 1 with sequence 23 is already on disk as file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_06_21/o1_mf_1_2 3_37n046y3_.arc
channel ORA_DISK_1: starting archived log restore to default destination channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=16 channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=17 channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=18 channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=19 channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2007_06_21/o1_mf_an nnn_TAG20070621T043805_37m7l46t_.bkp channel ORA_DISK_1: piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2007_06_21/o 1_mf_annnn_TAG20070621T043805_37m7l46t_.bkp tag=TAG20070621T043805 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 archived log file name=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_06_21/o1 _mf_1_16_37n7ptq0_.arc thread=1 sequence=16 channel default: deleting archived log(s) archived log file name=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_06_21/o1 _mf_1_16_37n7ptq0_.arc RECID=20 STAMP=625844810 archived log file name=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2007_06_21/o1 _mf_1_17_37n7ptrv_.arc thread=1 sequence=17 channel default: deleting archived log(s) archived log file name=/u01/app/oracle/flash_re |