使用crosscheck backupset或crosscheck backup之后,提示所有备份集都为available状态,当他执行delete obsolete时,提示有两个文件需要删除。
实际上,obsolete的backupset的状态也会是AVAILABLE的。
对于OBSOLETE的备份集做删除操作,最好是按照如下步骤:
1.crosscheck backupset;或crosscheck backup;
2.report obsolete;
3.delete obsolete;
RMAN> crosscheck backup; using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_118_1_896624153.db RECID=109 STAMP=896624154 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_121_1_896624448.arch RECID=112 STAMP=896624449 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_122_1_896624526.spfile RECID=113 STAMP=896624526 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_123_1_896624527.ctl RECID=114 STAMP=896624530 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_24/o1_mf_s_896624531_c580jntq_.bkp RECID=115 STAMP=896624532 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_125_1_896807312.db RECID=116 STAMP=896807313 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896807507_c5fm6orr_.bkp RECID=117 STAMP=896807509 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_127_1_896807515.arch RECID=118 STAMP=896807515 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_128_1_896807543.spfile RECID=119 STAMP=896807543 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_129_1_896807544.ctl RECID=120 STAMP=896807547 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896807548_c5fm7yvv_.bkp RECID=121 STAMP=896807550 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_131_1_896807869.db RECID=122 STAMP=896807871 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896808065_c5fmr484_.bkp RECID=123 STAMP=896808068 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_133_1_896808078.arch RECID=124 STAMP=896808078 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_134_1_896808105.spfile RECID=125 STAMP=896808105 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_135_1_896808107.ctl RECID=126 STAMP=896808110 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896808111_c5fmsjt5_.bkp RECID=127 STAMP=896808112 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_137_1_897123382.db RECID=128 STAMP=897123383 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_30/o1_mf_s_897123538_c5q7tn7w_.bkp RECID=129 STAMP=897123540 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_139_1_897123549.arch RECID=130 STAMP=897123549 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_140_1_897123616.spfile RECID=131 STAMP=897123616 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_141_1_897123617.ctl RECID=132 STAMP=897123620 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_30/o1_mf_s_897123622_c5q7x768_.bkp RECID=133 STAMP=897123623 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_143_1_897409343.db RECID=134 STAMP=897409344 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_12_02/o1_mf_s_897409479_c5xbpd56_.bkp RECID=135 STAMP=897409484 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_145_1_897409492.arch RECID=136 STAMP=897409492 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_146_1_897409589.spfile RECID=137 STAMP=897409589 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_147_1_897409591.ctl RECID=138 STAMP=897409594 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_12_02/o1_mf_s_897409595_c5xbswyr_.bkp RECID=139 STAMP=897409596 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_149_1_897409811.db RECID=140 STAMP=897409811 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_12_02/o1_mf_s_897410027_c5xc7g0h_.bkp RECID=141 STAMP=897410029 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_151_1_897410038.arch RECID=142 STAMP=897410038 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_152_1_897410156.spfile RECID=143 STAMP=897410156 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/data2/backup/ORCL_153_1_897410158.ctl RECID=144 STAMP=897410161 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_12_02/o1_mf_s_897410162_c5xccnjn_.bkp RECID=145 STAMP=897410164 Crosschecked 35 objects
RMAN> report obsolete; RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 2 Report of obsolete backups and copies Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Archive Log 2786 24-NOV-15 /data2/orcl/recover_log/archive_log/1_2736_893168897.dbf Archive Log 2787 24-NOV-15 /data2/orcl/recover_log/archive_log/1_2737_893168897.dbf Archive Log 2788 24-NOV-15 /data2/orcl/recover_log/archive_log/1_2738_893168897.dbf Backup Set 98 24-NOV-15 Backup Piece 109 24-NOV-15 /data2/backup/ORCL_118_1_896624153.db Archive Log 2789 24-NOV-15 /data2/orcl/recover_log/archive_log/1_2739_893168897.dbf Backup Set 101 24-NOV-15 Backup Piece 112 24-NOV-15 /data2/backup/ORCL_121_1_896624448.arch Backup Set 102 24-NOV-15 Backup Piece 113 24-NOV-15 /data2/backup/ORCL_122_1_896624526.spfile Backup Set 103 24-NOV-15 Backup Piece 114 24-NOV-15 /data2/backup/ORCL_123_1_896624527.ctl Archive Log 2790 24-NOV-15 /data2/orcl/recover_log/archive_log/1_2740_893168897.dbf Backup Set 104 24-NOV-15 Backup Piece 115 24-NOV-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_24/o1_mf_s_896624531_c580jntq_.bkp Archive Log 2791 24-NOV-15 /data2/orcl/recover_log/archive_log/1_2741_893168897.dbf Archive Log 2792 24-NOV-15 /data2/orcl/recover_log/archive_log/1_2742_893168897.dbf Archive Log 2793 25-NOV-15 /data2/orcl/recover_log/archive_log/1_2743_893168897.dbf Archive Log 2794 25-NOV-15 /data2/orcl/recover_log/archive_log/1_2744_893168897.dbf Archive Log 2795 25-NOV-15 /data2/orcl/recover_log/archive_log/1_2745_893168897.dbf Archive Log 2796 25-NOV-15 /data2/orcl/recover_log/archive_log/1_2746_893168897.dbf Archive Log 2797 25-NOV-15 /data2/orcl/recover_log/archive_log/1_2747_893168897.dbf Archive Log 2798 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2748_893168897.dbf Archive Log 2799 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2749_893168897.dbf Backup Set 105 26-NOV-15 Backup Piece 116 26-NOV-15 /data2/backup/ORCL_125_1_896807312.db Archive Log 2800 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2750_893168897.dbf Backup Set 106 26-NOV-15 Backup Piece 117 26-NOV-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896807507_c5fm6orr_.bkp Archive Log 2801 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2751_893168897.dbf Backup Set 107 26-NOV-15 Backup Piece 118 26-NOV-15 /data2/backup/ORCL_127_1_896807515.arch Backup Set 108 26-NOV-15 Backup Piece 119 26-NOV-15 /data2/backup/ORCL_128_1_896807543.spfile Backup Set 109 26-NOV-15 Backup Piece 120 26-NOV-15 /data2/backup/ORCL_129_1_896807544.ctl Backup Set 110 26-NOV-15 Backup Piece 121 26-NOV-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896807548_c5fm7yvv_.bkp Backup Set 111 26-NOV-15 Backup Piece 122 26-NOV-15 /data2/backup/ORCL_131_1_896807869.db Archive Log 2802 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2752_893168897.dbf Backup Set 112 26-NOV-15 Backup Piece 123 26-NOV-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896808065_c5fmr484_.bkp Archive Log 2803 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2753_893168897.dbf Backup Set 113 26-NOV-15 Backup Piece 124 26-NOV-15 /data2/backup/ORCL_133_1_896808078.arch Backup Set 114 26-NOV-15 Backup Piece 125 26-NOV-15 /data2/backup/ORCL_134_1_896808105.spfile Backup Set 115 26-NOV-15 Backup Piece 126 26-NOV-15 /data2/backup/ORCL_135_1_896808107.ctl Archive Log 2804 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2754_893168897.dbf Backup Set 116 26-NOV-15 Backup Piece 127 26-NOV-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896808111_c5fmsjt5_.bkp Archive Log 2805 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2755_893168897.dbf Archive Log 2806 27-NOV-15 /data2/orcl/recover_log/archive_log/1_2756_893168897.dbf Archive Log 2807 27-NOV-15 /data2/orcl/recover_log/archive_log/1_2757_893168897.dbf Archive Log 2808 27-NOV-15 /data2/orcl/recover_log/archive_log/1_2758_893168897.dbf Archive Log 2809 27-NOV-15 /data2/orcl/recover_log/archive_log/1_2759_893168897.dbf Archive Log 2810 27-NOV-15 /data2/orcl/recover_log/archive_log/1_2760_893168897.dbf Archive Log 2811 28-NOV-15 /data2/orcl/recover_log/archive_log/1_2761_893168897.dbf Archive Log 2812 28-NOV-15 /data2/orcl/recover_log/archive_log/1_2762_893168897.dbf Archive Log 2813 28-NOV-15 /data2/orcl/recover_log/archive_log/1_2763_893168897.dbf Archive Log 2814 28-NOV-15 /data2/orcl/recover_log/archive_log/1_2764_893168897.dbf Archive Log 2815 28-NOV-15 /data2/orcl/recover_log/archive_log/1_2765_893168897.dbf Archive Log 2816 29-NOV-15 /data2/orcl/recover_log/archive_log/1_2766_893168897.dbf Archive Log 2817 29-NOV-15 /data2/orcl/recover_log/archive_log/1_2767_893168897.dbf Archive Log 2818 29-NOV-15 /data2/orcl/recover_log/archive_log/1_2768_893168897.dbf Archive Log 2819 29-NOV-15 /data2/orcl/recover_log/archive_log/1_2769_893168897.dbf Archive Log 2820 29-NOV-15 /data2/orcl/recover_log/archive_log/1_2770_893168897.dbf Archive Log 2821 29-NOV-15 /data2/orcl/recover_log/archive_log/1_2771_893168897.dbf Archive Log 2822 29-NOV-15 /data2/orcl/recover_log/archive_log/1_2772_893168897.dbf Archive Log 2823 30-NOV-15 /data2/orcl/recover_log/archive_log/1_2773_893168897.dbf Archive Log 2824 30-NOV-15 /data2/orcl/recover_log/archive_log/1_2774_893168897.dbf Archive Log 2825 30-NOV-15 /data2/orcl/recover_log/archive_log/1_2775_893168897.dbf Backup Set 117 30-NOV-15 Backup Piece 128 30-NOV-15 /data2/backup/ORCL_137_1_897123382.db Archive Log 2827 30-NOV-15 /data2/orcl/recover_log/archive_log/1_2777_893168897.dbf Backup Set 118 30-NOV-15 Backup Piece 129 30-NOV-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_30/o1_mf_s_897123538_c5q7tn7w_.bkp Archive Log 2826 30-NOV-15 /data2/orcl/recover_log/archive_log/1_2776_893168897.dbf Backup Set 119 30-NOV-15 Backup Piece 130 30-NOV-15 /data2/backup/ORCL_139_1_897123549.arch Backup Set 120 30-NOV-15 Backup Piece 131 30-NOV-15 /data2/backup/ORCL_140_1_897123616.spfile Backup Set 121 30-NOV-15 Backup Piece 132 30-NOV-15 /data2/backup/ORCL_141_1_897123617.ctl Archive Log 2828 30-NOV-15 /data2/orcl/recover_log/archive_log/1_2778_893168897.dbf Backup Set 122 30-NOV-15 Backup Piece 133 30-NOV-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_30/o1_mf_s_897123622_c5q7x768_.bkp Archive Log 2829 30-NOV-15 /data2/orcl/recover_log/archive_log/1_2779_893168897.dbf Archive Log 2830 01-DEC-15 /data2/orcl/recover_log/archive_log/1_2780_893168897.dbf Archive Log 2831 01-DEC-15 /data2/orcl/recover_log/archive_log/1_2781_893168897.dbf Archive Log 2832 01-DEC-15 /data2/orcl/recover_log/archive_log/1_2782_893168897.dbf Archive Log 2833 01-DEC-15 /data2/orcl/recover_log/archive_log/1_2783_893168897.dbf Archive Log 2834 01-DEC-15 /data2/orcl/recover_log/archive_log/1_2784_893168897.dbf Archive Log 2835 01-DEC-15 /data2/orcl/recover_log/archive_log/1_2785_893168897.dbf Archive Log 2836 02-DEC-15 /data2/orcl/recover_log/archive_log/1_2786_893168897.dbf Archive Log 2837 02-DEC-15 /data2/orcl/recover_log/archive_log/1_2787_893168897.dbf Archive Log 2838 02-DEC-15 /data2/orcl/recover_log/archive_log/1_2788_893168897.dbf Archive Log 2839 02-DEC-15 /data2/orcl/recover_log/archive_log/1_2789_893168897.dbf Backup Set 124 02-DEC-15 Backup Piece 135 02-DEC-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_12_02/o1_mf_s_897409479_c5xbpd56_.bkp Backup Set 126 02-DEC-15 Backup Piece 137 02-DEC-15 /data2/backup/ORCL_146_1_897409589.spfile Backup Set 127 02-DEC-15 Backup Piece 138 02-DEC-15 /data2/backup/ORCL_147_1_897409591.ctl Backup Set 128 02-DEC-15 Backup Piece 139 02-DEC-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_12_02/o1_mf_s_897409595_c5xbswyr_.bkp Backup Set 130 02-DEC-15 Backup Piece 141 02-DEC-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_12_02/o1_mf_s_897410027_c5xc7g0h_.bkp
RMAN> delete obsolete; RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 2 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 Deleting the following obsolete backups and copies: Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Archive Log 2786 24-NOV-15 /data2/orcl/recover_log/archive_log/1_2736_893168897.dbf Archive Log 2787 24-NOV-15 /data2/orcl/recover_log/archive_log/1_2737_893168897.dbf Archive Log 2788 24-NOV-15 /data2/orcl/recover_log/archive_log/1_2738_893168897.dbf Backup Set 98 24-NOV-15 Backup Piece 109 24-NOV-15 /data2/backup/ORCL_118_1_896624153.db Archive Log 2789 24-NOV-15 /data2/orcl/recover_log/archive_log/1_2739_893168897.dbf Backup Set 101 24-NOV-15 Backup Piece 112 24-NOV-15 /data2/backup/ORCL_121_1_896624448.arch Backup Set 102 24-NOV-15 Backup Piece 113 24-NOV-15 /data2/backup/ORCL_122_1_896624526.spfile Backup Set 103 24-NOV-15 Backup Piece 114 24-NOV-15 /data2/backup/ORCL_123_1_896624527.ctl Archive Log 2790 24-NOV-15 /data2/orcl/recover_log/archive_log/1_2740_893168897.dbf Backup Set 104 24-NOV-15 Backup Piece 115 24-NOV-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_24/o1_mf_s_896624531_c580jntq_.bkp Archive Log 2791 24-NOV-15 /data2/orcl/recover_log/archive_log/1_2741_893168897.dbf Archive Log 2792 24-NOV-15 /data2/orcl/recover_log/archive_log/1_2742_893168897.dbf Archive Log 2793 25-NOV-15 /data2/orcl/recover_log/archive_log/1_2743_893168897.dbf Archive Log 2794 25-NOV-15 /data2/orcl/recover_log/archive_log/1_2744_893168897.dbf Archive Log 2795 25-NOV-15 /data2/orcl/recover_log/archive_log/1_2745_893168897.dbf Archive Log 2796 25-NOV-15 /data2/orcl/recover_log/archive_log/1_2746_893168897.dbf Archive Log 2797 25-NOV-15 /data2/orcl/recover_log/archive_log/1_2747_893168897.dbf Archive Log 2798 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2748_893168897.dbf Archive Log 2799 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2749_893168897.dbf Backup Set 105 26-NOV-15 Backup Piece 116 26-NOV-15 /data2/backup/ORCL_125_1_896807312.db Archive Log 2800 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2750_893168897.dbf Backup Set 106 26-NOV-15 Backup Piece 117 26-NOV-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896807507_c5fm6orr_.bkp Archive Log 2801 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2751_893168897.dbf Backup Set 107 26-NOV-15 Backup Piece 118 26-NOV-15 /data2/backup/ORCL_127_1_896807515.arch Backup Set 108 26-NOV-15 Backup Piece 119 26-NOV-15 /data2/backup/ORCL_128_1_896807543.spfile Backup Set 109 26-NOV-15 Backup Piece 120 26-NOV-15 /data2/backup/ORCL_129_1_896807544.ctl Backup Set 110 26-NOV-15 Backup Piece 121 26-NOV-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896807548_c5fm7yvv_.bkp Backup Set 111 26-NOV-15 Backup Piece 122 26-NOV-15 /data2/backup/ORCL_131_1_896807869.db Archive Log 2802 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2752_893168897.dbf Backup Set 112 26-NOV-15 Backup Piece 123 26-NOV-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896808065_c5fmr484_.bkp Archive Log 2803 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2753_893168897.dbf Backup Set 113 26-NOV-15 Backup Piece 124 26-NOV-15 /data2/backup/ORCL_133_1_896808078.arch Backup Set 114 26-NOV-15 Backup Piece 125 26-NOV-15 /data2/backup/ORCL_134_1_896808105.spfile Backup Set 115 26-NOV-15 Backup Piece 126 26-NOV-15 /data2/backup/ORCL_135_1_896808107.ctl Archive Log 2804 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2754_893168897.dbf Backup Set 116 26-NOV-15 Backup Piece 127 26-NOV-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896808111_c5fmsjt5_.bkp Archive Log 2805 26-NOV-15 /data2/orcl/recover_log/archive_log/1_2755_893168897.dbf Archive Log 2806 27-NOV-15 /data2/orcl/recover_log/archive_log/1_2756_893168897.dbf Archive Log 2807 27-NOV-15 /data2/orcl/recover_log/archive_log/1_2757_893168897.dbf Archive Log 2808 27-NOV-15 /data2/orcl/recover_log/archive_log/1_2758_893168897.dbf Archive Log 2809 27-NOV-15 /data2/orcl/recover_log/archive_log/1_2759_893168897.dbf Archive Log 2810 27-NOV-15 /data2/orcl/recover_log/archive_log/1_2760_893168897.dbf Archive Log 2811 28-NOV-15 /data2/orcl/recover_log/archive_log/1_2761_893168897.dbf Archive Log 2812 28-NOV-15 /data2/orcl/recover_log/archive_log/1_2762_893168897.dbf Archive Log 2813 28-NOV-15 /data2/orcl/recover_log/archive_log/1_2763_893168897.dbf Archive Log 2814 28-NOV-15 /data2/orcl/recover_log/archive_log/1_2764_893168897.dbf Archive Log 2815 28-NOV-15 /data2/orcl/recover_log/archive_log/1_2765_893168897.dbf Archive Log 2816 29-NOV-15 /data2/orcl/recover_log/archive_log/1_2766_893168897.dbf Archive Log 2817 29-NOV-15 /data2/orcl/recover_log/archive_log/1_2767_893168897.dbf Archive Log 2818 29-NOV-15 /data2/orcl/recover_log/archive_log/1_2768_893168897.dbf Archive Log 2819 29-NOV-15 /data2/orcl/recover_log/archive_log/1_2769_893168897.dbf Archive Log 2820 29-NOV-15 /data2/orcl/recover_log/archive_log/1_2770_893168897.dbf Archive Log 2821 29-NOV-15 /data2/orcl/recover_log/archive_log/1_2771_893168897.dbf Archive Log 2822 29-NOV-15 /data2/orcl/recover_log/archive_log/1_2772_893168897.dbf Archive Log 2823 30-NOV-15 /data2/orcl/recover_log/archive_log/1_2773_893168897.dbf Archive Log 2824 30-NOV-15 /data2/orcl/recover_log/archive_log/1_2774_893168897.dbf Archive Log 2825 30-NOV-15 /data2/orcl/recover_log/archive_log/1_2775_893168897.dbf Backup Set 117 30-NOV-15 Backup Piece 128 30-NOV-15 /data2/backup/ORCL_137_1_897123382.db Archive Log 2827 30-NOV-15 /data2/orcl/recover_log/archive_log/1_2777_893168897.dbf Backup Set 118 30-NOV-15 Backup Piece 129 30-NOV-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_30/o1_mf_s_897123538_c5q7tn7w_.bkp Archive Log 2826 30-NOV-15 /data2/orcl/recover_log/archive_log/1_2776_893168897.dbf Backup Set 119 30-NOV-15 Backup Piece 130 30-NOV-15 /data2/backup/ORCL_139_1_897123549.arch Backup Set 120 30-NOV-15 Backup Piece 131 30-NOV-15 /data2/backup/ORCL_140_1_897123616.spfile Backup Set 121 30-NOV-15 Backup Piece 132 30-NOV-15 /data2/backup/ORCL_141_1_897123617.ctl Archive Log 2828 30-NOV-15 /data2/orcl/recover_log/archive_log/1_2778_893168897.dbf Backup Set 122 30-NOV-15 Backup Piece 133 30-NOV-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_30/o1_mf_s_897123622_c5q7x768_.bkp Archive Log 2829 30-NOV-15 /data2/orcl/recover_log/archive_log/1_2779_893168897.dbf Archive Log 2830 01-DEC-15 /data2/orcl/recover_log/archive_log/1_2780_893168897.dbf Archive Log 2831 01-DEC-15 /data2/orcl/recover_log/archive_log/1_2781_893168897.dbf Archive Log 2832 01-DEC-15 /data2/orcl/recover_log/archive_log/1_2782_893168897.dbf Archive Log 2833 01-DEC-15 /data2/orcl/recover_log/archive_log/1_2783_893168897.dbf Archive Log 2834 01-DEC-15 /data2/orcl/recover_log/archive_log/1_2784_893168897.dbf Archive Log 2835 01-DEC-15 /data2/orcl/recover_log/archive_log/1_2785_893168897.dbf Archive Log 2836 02-DEC-15 /data2/orcl/recover_log/archive_log/1_2786_893168897.dbf Archive Log 2837 02-DEC-15 /data2/orcl/recover_log/archive_log/1_2787_893168897.dbf Archive Log 2838 02-DEC-15 /data2/orcl/recover_log/archive_log/1_2788_893168897.dbf Archive Log 2839 02-DEC-15 /data2/orcl/recover_log/archive_log/1_2789_893168897.dbf Backup Set 124 02-DEC-15 Backup Piece 135 02-DEC-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_12_02/o1_mf_s_897409479_c5xbpd56_.bkp Backup Set 126 02-DEC-15 Backup Piece 137 02-DEC-15 /data2/backup/ORCL_146_1_897409589.spfile Backup Set 127 02-DEC-15 Backup Piece 138 02-DEC-15 /data2/backup/ORCL_147_1_897409591.ctl Backup Set 128 02-DEC-15 Backup Piece 139 02-DEC-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_12_02/o1_mf_s_897409595_c5xbswyr_.bkp Backup Set 130 02-DEC-15 Backup Piece 141 02-DEC-15 /u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_12_02/o1_mf_s_897410027_c5xc7g0h_.bkp Do you really want to delete the above objects (enter YES or NO)? YES deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2736_893168897.dbf RECID=2786 STAMP=896616157 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2737_893168897.dbf RECID=2787 STAMP=896616158 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2738_893168897.dbf RECID=2788 STAMP=896624391 deleted backup piece backup piece handle=/data2/backup/ORCL_118_1_896624153.db RECID=109 STAMP=896624154 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2739_893168897.dbf RECID=2789 STAMP=896624392 deleted backup piece backup piece handle=/data2/backup/ORCL_121_1_896624448.arch RECID=112 STAMP=896624449 deleted backup piece backup piece handle=/data2/backup/ORCL_122_1_896624526.spfile RECID=113 STAMP=896624526 deleted backup piece backup piece handle=/data2/backup/ORCL_123_1_896624527.ctl RECID=114 STAMP=896624530 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2740_893168897.dbf RECID=2790 STAMP=896652019 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_24/o1_mf_s_896624531_c580jntq_.bkp RECID=115 STAMP=896624532 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2741_893168897.dbf RECID=2791 STAMP=896652058 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2742_893168897.dbf RECID=2792 STAMP=896652868 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2743_893168897.dbf RECID=2793 STAMP=896680813 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2744_893168897.dbf RECID=2794 STAMP=896713234 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2745_893168897.dbf RECID=2795 STAMP=896738419 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2746_893168897.dbf RECID=2796 STAMP=896738458 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2747_893168897.dbf RECID=2797 STAMP=896739356 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2748_893168897.dbf RECID=2798 STAMP=896770817 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2749_893168897.dbf RECID=2799 STAMP=896803237 deleted backup piece backup piece handle=/data2/backup/ORCL_125_1_896807312.db RECID=116 STAMP=896807313 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2750_893168897.dbf RECID=2800 STAMP=896807514 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896807507_c5fm6orr_.bkp RECID=117 STAMP=896807509 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2751_893168897.dbf RECID=2801 STAMP=896807514 deleted backup piece backup piece handle=/data2/backup/ORCL_127_1_896807515.arch RECID=118 STAMP=896807515 deleted backup piece backup piece handle=/data2/backup/ORCL_128_1_896807543.spfile RECID=119 STAMP=896807543 deleted backup piece backup piece handle=/data2/backup/ORCL_129_1_896807544.ctl RECID=120 STAMP=896807547 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896807548_c5fm7yvv_.bkp RECID=121 STAMP=896807550 deleted backup piece backup piece handle=/data2/backup/ORCL_131_1_896807869.db RECID=122 STAMP=896807871 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2752_893168897.dbf RECID=2802 STAMP=896808077 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896808065_c5fmr484_.bkp RECID=123 STAMP=896808068 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2753_893168897.dbf RECID=2803 STAMP=896808078 deleted backup piece backup piece handle=/data2/backup/ORCL_133_1_896808078.arch RECID=124 STAMP=896808078 deleted backup piece backup piece handle=/data2/backup/ORCL_134_1_896808105.spfile RECID=125 STAMP=896808105 deleted backup piece backup piece handle=/data2/backup/ORCL_135_1_896808107.ctl RECID=126 STAMP=896808110 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2754_893168897.dbf RECID=2804 STAMP=896824824 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_26/o1_mf_s_896808111_c5fmsjt5_.bkp RECID=127 STAMP=896808112 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2755_893168897.dbf RECID=2805 STAMP=896825837 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2756_893168897.dbf RECID=2806 STAMP=896832063 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2757_893168897.dbf RECID=2807 STAMP=896864454 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2758_893168897.dbf RECID=2808 STAMP=896896956 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2759_893168897.dbf RECID=2809 STAMP=896911224 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2760_893168897.dbf RECID=2810 STAMP=896912321 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2761_893168897.dbf RECID=2811 STAMP=896925604 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2762_893168897.dbf RECID=2812 STAMP=896940026 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2763_893168897.dbf RECID=2813 STAMP=896947488 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2764_893168897.dbf RECID=2814 STAMP=896969265 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2765_893168897.dbf RECID=2815 STAMP=896990456 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2766_893168897.dbf RECID=2816 STAMP=897016714 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2767_893168897.dbf RECID=2817 STAMP=897026424 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2768_893168897.dbf RECID=2818 STAMP=897034854 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2769_893168897.dbf RECID=2819 STAMP=897034859 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2770_893168897.dbf RECID=2820 STAMP=897040852 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2771_893168897.dbf RECID=2821 STAMP=897048031 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2772_893168897.dbf RECID=2822 STAMP=897069712 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2773_893168897.dbf RECID=2823 STAMP=897094830 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2774_893168897.dbf RECID=2824 STAMP=897121338 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2775_893168897.dbf RECID=2825 STAMP=897121341 deleted backup piece backup piece handle=/data2/backup/ORCL_137_1_897123382.db RECID=128 STAMP=897123383 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2777_893168897.dbf RECID=2827 STAMP=897123548 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_30/o1_mf_s_897123538_c5q7tn7w_.bkp RECID=129 STAMP=897123540 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2776_893168897.dbf RECID=2826 STAMP=897123548 deleted backup piece backup piece handle=/data2/backup/ORCL_139_1_897123549.arch RECID=130 STAMP=897123549 deleted backup piece backup piece handle=/data2/backup/ORCL_140_1_897123616.spfile RECID=131 STAMP=897123616 deleted backup piece backup piece handle=/data2/backup/ORCL_141_1_897123617.ctl RECID=132 STAMP=897123620 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2778_893168897.dbf RECID=2828 STAMP=897154496 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_11_30/o1_mf_s_897123622_c5q7x768_.bkp RECID=133 STAMP=897123623 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2779_893168897.dbf RECID=2829 STAMP=897170421 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2780_893168897.dbf RECID=2830 STAMP=897264018 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2781_893168897.dbf RECID=2831 STAMP=897294226 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2782_893168897.dbf RECID=2832 STAMP=897294231 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2783_893168897.dbf RECID=2833 STAMP=897311134 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2784_893168897.dbf RECID=2834 STAMP=897343207 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2785_893168897.dbf RECID=2835 STAMP=897343231 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2786_893168897.dbf RECID=2836 STAMP=897357656 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2787_893168897.dbf RECID=2837 STAMP=897380715 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2788_893168897.dbf RECID=2838 STAMP=897380719 deleted archived log archived log file name=/data2/orcl/recover_log/archive_log/1_2789_893168897.dbf RECID=2839 STAMP=897393621 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_12_02/o1_mf_s_897409479_c5xbpd56_.bkp RECID=135 STAMP=897409484 deleted backup piece backup piece handle=/data2/backup/ORCL_146_1_897409589.spfile RECID=137 STAMP=897409589 deleted backup piece backup piece handle=/data2/backup/ORCL_147_1_897409591.ctl RECID=138 STAMP=897409594 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_12_02/o1_mf_s_897409595_c5xbswyr_.bkp RECID=139 STAMP=897409596 deleted backup piece backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2015_12_02/o1_mf_s_897410027_c5xc7g0h_.bkp RECID=141 STAMP=897410029 Deleted 82 objects