参考文档：
How to Change the CHECKPOINT_RETENTION_TIME in Classic Extract When Using LOGRETENTION Parameter (文档 ID 1618144.1)
GoldenGate LOGRETENTION (文档 ID 1465847.1)
本文环境：
Oracle Database RAC 11.2.0.3
Oracle GoldenGate 11.2.1.0.31
第一：
SQL> exec dbms_goldengate_auth.grant_admin_privilege('GOLDENGATE');
PL/SQL procedure successfully completed.
SQL>
第二：
[oracle@orcla ggs]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.31 20976570 22304105_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Jan 25 2016 12:35:44
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (orcla) 3> DBLOGIN userid goldengate, password XXXXXX
Successfully logged into database.
GGSCI (orcla) 4> REGISTER EXTRACT extfull LOGRETENTION
2016-03-16 15:47:14 ERROR OGG-01754 Cannot register or unregister EXTRACT EXTFULL because the Extract is currently running. Stop the Extract and retry the command.
GGSCI (orcla) 5> stop extfull
Sending STOP request to EXTRACT EXTFULL ...
Request processed.
GGSCI (orcla) 6> REGISTER EXTRACT extfull LOGRETENTION
2016-03-16 15:47:46 INFO OGG-01749 Successfully registered EXTRACT EXTFULL to start managing log retention at SCN 13512923.
GGSCI (orcla) 7>
此时，查询dba_capture视图，有如下的输出：
SQL> set lines 300
SQL> select capture_name, CAPTURE_TYPE, status, REQUIRED_CHECKPOINT_SCN, CHECKPOINT_RETENTION_TIME, FIRST_SCN,capture_type from dba_capture;
CAPTURE_NAME CAPTURE_TY STATUS REQUIRED_CHECKPOINT_SCN CHECKPOINT_RETENTION_TIME FIRST_SCN CAPTURE_TY
------------------------------ ---------- -------- ----------------------- ------------------------- ---------- ----------
OGG$_EXTFULLB059D530 LOCAL DISABLED 0 60 13512923 LOCAL
SQL>
第三：
为extfull进程添加参数
原参数：TRANLOGOPTIONS DBLOGREADER
新参数：TRANLOGOPTIONS DBLOGREADER LOGRETENTION ENABLED
保存，退出
第四：启动extfull进程。
启动之后,执行如下查询,发现CHECKPOINT_RETENTION_TIME变了：
SQL> set lines 300
SQL> select capture_name, CAPTURE_TYPE, status, REQUIRED_CHECKPOINT_SCN, CHECKPOINT_RETENTION_TIME, FIRST_SCN,capture_type from dba_capture;
CAPTURE_NAME CAPTURE_TY STATUS REQUIRED_CHECKPOINT_SCN CHECKPOINT_RETENTION_TIME FIRST_SCN CAPTURE_TY
------------------------------ ---------- -------- ----------------------- ------------------------- ---------- ----------
OGG2$_EXTFULLB059D530 LOCAL DISABLED 0 7 13512910 LOCAL
SQL> ---->>>注意，CHECKPOINT_RETENTION_TIME变为7天了。
--------->>>参考：How to Change the CHECKPOINT_RETENTION_TIME in Classic Extract When Using LOGRETENTION Parameter (文档 ID 1618144.1)
第五：测试delete archivelog 命令
[oracle@orcla dirdat]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Mar 16 16:11:27 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: orcl (DBID=4137854218)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name orcl are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;------------->>>>>默认的参数设置
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/snapcf_orcl.f';
RMAN> delete archivelog sequence 84 thread 1;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=138 instance=orcl1 device type=DISK
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=+FRA/orcl/archivelog/2016_03_16/thread_1_seq_84.341.906653055 thread=1 sequence=84
RMAN>
第六：测试report obsolete命令
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log 88 13-JAN-16 /home/oracle/archivelog/2_42_894471954.dbf
Archive Log 89 13-JAN-16 /home/oracle/archivelog/1_47_894471954.dbf
Archive Log 90 13-JAN-16 /home/oracle/archivelog/2_43_894471954.dbf
Archive Log 91 13-JAN-16 /home/oracle/archivelog/2_44_894471954.dbf
Archive Log 92 13-JAN-16 /home/oracle/archivelog/1_48_894471954.dbf
Archive Log 93 13-JAN-16 /home/oracle/archivelog/2_45_894471954.dbf
Archive Log 94 13-JAN-16 /home/oracle/archivelog/1_49_894471954.dbf
Archive Log 95 13-JAN-16 /home/oracle/archivelog/1_50_894471954.dbf
Archive Log 96 13-JAN-16 /home/oracle/archivelog/2_46_894471954.dbf
Archive Log 97 13-JAN-16 /home/oracle/archivelog/1_51_894471954.dbf
Archive Log 98 13-JAN-16 /home/oracle/archivelog/2_47_894471954.dbf
Archive Log 99 13-JAN-16 /home/oracle/archivelog/1_52_894471954.dbf
Archive Log 100 13-JAN-16 /home/oracle/archivelog/2_48_894471954.dbf
Archive Log 101 13-JAN-16 /home/oracle/archivelog/2_49_894471954.dbf
Archive Log 102 13-JAN-16 /home/oracle/archivelog/1_53_894471954.dbf
Archive Log 103 13-JAN-16 /home/oracle/archivelog/1_54_894471954.dbf
Archive Log 104 13-JAN-16 /home/oracle/archivelog/2_50_894471954.dbf
Backup Set 1 13-JAN-16
Backup Piece 1 13-JAN-16 /home/oracle/backup/db_01qr9hqm_1_1
Backup Set 2 13-JAN-16
Backup Piece 2 13-JAN-16 /home/oracle/backup/db_02qr9hqp_1_1
Backup Set 4 13-JAN-16
Backup Piece 4 13-JAN-16 /home/oracle/backup/db_03qr9hs7_1_1
Backup Set 3 13-JAN-16
Backup Piece 3 13-JAN-16 /home/oracle/backup/db_04qr9hs7_1_1
Backup Set 5 13-JAN-16
Backup Piece 5 13-JAN-16 /home/oracle/backup/db_05qr9hsb_1_1
Backup Set 6 13-JAN-16
Backup Piece 6 13-JAN-16 /home/oracle/backup/db_06qr9hsb_1_1
Backup Set 7 13-JAN-16
Backup Piece 7 13-JAN-16 /home/oracle/backup/db_07qr9hsc_1_1
Backup Set 8 13-JAN-16
Backup Piece 8 13-JAN-16 /home/oracle/backup/db_08qr9hsc_1_1
Backup Set 9 13-JAN-16
Backup Piece 9 13-JAN-16 /home/oracle/backup/db_09qr9hsd_1_1
Backup Set 10 13-JAN-16
Backup Piece 10 13-JAN-16 /home/oracle/backup/db_0aqr9hsd_1_1
Backup Set 11 13-JAN-16
Backup Piece 11 13-JAN-16 /home/oracle/backup/db_0bqr9hsd_1_1
Backup Set 12 13-JAN-16
Backup Piece 12 13-JAN-16 /home/oracle/backup/db_0cqr9hsd_1_1
Backup Set 13 13-JAN-16
Backup Piece 13 13-JAN-16 /home/oracle/backup/db_0dqr9hse_1_1
Backup Set 14 13-JAN-16
Backup Piece 14 13-JAN-16 /home/oracle/backup/db_0eqr9hse_1_1
Backup Set 15 13-JAN-16
Backup Piece 15 13-JAN-16 /home/oracle/backup/db_0fqr9hse_1_1
Backup Set 16 13-JAN-16
Backup Piece 16 13-JAN-16 /home/oracle/backup/db_0gqr9hse_1_1
Backup Set 17 13-JAN-16
Backup Piece 17 13-JAN-16 /home/oracle/backup/db_0hqr9hsf_1_1
Backup Set 18 13-JAN-16
Backup Piece 18 13-JAN-16 /home/oracle/backup/db_0iqr9hsg_1_1
Backup Set 19 13-JAN-16
Backup Piece 19 13-JAN-16 /home/oracle/backup/db_0jqr9hsh_1_1
Backup Set 20 13-JAN-16
Backup Piece 20 13-JAN-16 /home/oracle/backup/db_0kqr9hsi_1_1
Backup Set 21 13-JAN-16
Backup Piece 21 13-JAN-16 /home/oracle/backup/db_0lqr9hsi_1_1
Backup Set 22 13-JAN-16
Backup Piece 22 13-JAN-16 /home/oracle/backup/db_0mqr9hsi_1_1
Backup Set 23 13-JAN-16
Backup Piece 23 13-JAN-16 /home/oracle/backup/db_0nqr9hsi_1_1
Backup Set 24 13-JAN-16
Backup Piece 24 13-JAN-16 /home/oracle/backup/db_0oqr9hsj_1_1
Backup Set 25 13-JAN-16
Backup Piece 25 13-JAN-16 /home/oracle/backup/arch_1_0pqr9hsl_1_1
Backup Set 26 13-JAN-16
Backup Piece 26 13-JAN-16 /home/oracle/backup/arch_2_0qqr9hsl_1_1
Archive Log 105 13-JAN-16 /home/oracle/archivelog/2_51_894471954.dbf
Backup Set 27 13-JAN-16
Backup Piece 27 13-JAN-16 /home/oracle/backup/arch_2_0sqr9hvd_1_1
Archive Log 106 13-JAN-16 /home/oracle/archivelog/1_55_894471954.dbf
Archive Log 107 13-JAN-16 /home/oracle/archivelog/1_56_894471954.dbf
Archive Log 108 13-JAN-16 /home/oracle/archivelog/2_52_894471954.dbf
Archive Log 109 13-JAN-16 /home/oracle/archivelog/2_53_894471954.dbf
Archive Log 110 13-JAN-16 /home/oracle/archivelog/1_57_894471954.dbf
Archive Log 111 13-JAN-16 /home/oracle/archivelog/1_58_894471954.dbf
Archive Log 112 13-JAN-16 /home/oracle/archivelog/2_54_894471954.dbf
Archive Log 114 13-JAN-16 /home/oracle/archivelog/1_59_894471954.dbf
Archive Log 113 13-JAN-16 /home/oracle/archivelog/2_55_894471954.dbf
Backup Set 28 13-JAN-16
Backup Piece 28 13-JAN-16 /home/oracle/backup/arch_1_0tqr9jl2_1_1
Backup Set 29 13-JAN-16
Backup Piece 29 13-JAN-16 /home/oracle/backup/arch_2_0uqr9jl7_1_1
Backup Set 31 13-JAN-16
Backup Piece 31 13-JAN-16 /home/oracle/backup/arch_2_0vqr9jml_1_1
Backup Set 30 13-JAN-16
Backup Piece 30 13-JAN-16 /home/oracle/backup/arch_1_10qr9jml_1_1
Backup Set 32 13-JAN-16
Backup Piece 32 13-JAN-16 /home/oracle/backup/arch_2_11qr9jmm_1_1
Backup Set 33 13-JAN-16
Backup Piece 33 13-JAN-16 /home/oracle/backup/arch_1_12qr9jmn_1_1
Backup Set 34 13-JAN-16
Backup Piece 34 13-JAN-16 /home/oracle/backup/arch_2_13qr9jmn_1_1
Backup Set 35 13-JAN-16
Backup Piece 35 13-JAN-16 /home/oracle/backup/arch_1_14qr9jmn_1_1
Backup Set 36 13-JAN-16
Backup Piece 36 13-JAN-16 /home/oracle/backup/arch_2_15qr9jmo_1_1
Backup Set 37 13-JAN-16
Backup Piece 37 13-JAN-16 /home/oracle/backup/arch_1_16qr9jmq_1_1
Backup Set 38 13-JAN-16
Backup Piece 38 13-JAN-16 /home/oracle/backup/arch_2_17qr9jms_1_1
Backup Set 39 13-JAN-16
Backup Piece 39 13-JAN-16 /home/oracle/backup/arch_1_18qr9jms_1_1
Backup Set 40 13-JAN-16
Backup Piece 40 13-JAN-16 /home/oracle/backup/arch_2_19qr9jmt_1_1
Backup Set 41 13-JAN-16
Backup Piece 41 13-JAN-16 /home/oracle/backup/arch_1_1aqr9jmu_1_1
Backup Set 42 13-JAN-16
Backup Piece 42 13-JAN-16 /home/oracle/backup/arch_2_1bqr9jn0_1_1
Backup Set 43 13-JAN-16
Backup Piece 43 13-JAN-16 /home/oracle/backup/arch_1_1cqr9jn1_1_1
Backup Set 44 13-JAN-16
Backup Piece 44 13-JAN-16 /home/oracle/backup/arch_2_1dqr9jn1_1_1
Backup Set 45 13-JAN-16
Backup Piece 45 13-JAN-16 /home/oracle/backup/arch_1_1eqr9jn2_1_1
Backup Set 46 13-JAN-16
Backup Piece 46 13-JAN-16 /home/oracle/backup/arch_2_1fqr9jn3_1_1
Backup Set 47 13-JAN-16
Backup Piece 47 13-JAN-16 /home/oracle/backup/arch_1_1gqr9jn3_1_1
Backup Set 48 13-JAN-16
Backup Piece 48 13-JAN-16 /home/oracle/backup/arch_2_1hqr9jn3_1_1
Backup Set 49 13-JAN-16
Backup Piece 49 13-JAN-16 /home/oracle/backup/arch_1_1iqr9jn4_1_1
Backup Set 50 13-JAN-16
Backup Piece 50 13-JAN-16 /home/oracle/backup/arch_2_1jqr9jn4_1_1
Backup Set 51 13-JAN-16
Backup Piece 51 13-JAN-16 /home/oracle/backup/arch_1_1kqr9jn4_1_1
Backup Set 52 13-JAN-16
Backup Piece 52 13-JAN-16 /home/oracle/backup/arch_2_1lqr9jn5_1_1
Backup Set 53 13-JAN-16
Backup Piece 53 13-JAN-16 /home/oracle/backup/arch_1_1mqr9jn5_1_1
Backup Set 54 13-JAN-16
Backup Piece 54 13-JAN-16 /home/oracle/backup/arch_2_1nqr9jn5_1_1
Backup Set 55 13-JAN-16
Backup Piece 55 13-JAN-16 /home/oracle/backup/arch_1_1oqr9jn6_1_1
Archive Log 115 19-JAN-16 /home/oracle/archivelog/1_60_894471954.dbf
Backup Set 56 13-JAN-16
Backup Piece 56 13-JAN-16 /home/oracle/backup/arch_2_1pqr9jn6_1_1
Archive Log 116 20-JAN-16 /home/oracle/archivelog/2_56_894471954.dbf
Archive Log 117 24-JAN-16 /home/oracle/archivelog/2_57_894471954.dbf
Archive Log 118 24-JAN-16 /home/oracle/archivelog/1_61_894471954.dbf
Archive Log 119 27-JAN-16 /home/oracle/archivelog/2_58_894471954.dbf
Archive Log 120 30-JAN-16 /home/oracle/archivelog/2_59_894471954.dbf
Archive Log 121 30-JAN-16 /home/oracle/archivelog/1_62_894471954.dbf
Archive Log 122 01-FEB-16 /home/oracle/archivelog/2_60_894471954.dbf
Archive Log 123 02-FEB-16 +DATAFILE/orcl/archivelog/2016_02_02/thread_1_seq_63.270.902759171
Archive Log 124 02-FEB-16 +DATAFILE/orcl/archivelog/2016_02_02/thread_1_seq_64.271.902759259
Archive Log 125 02-FEB-16 +DATAFILE/orcl/archivelog/2016_02_02/thread_2_seq_61.272.902759261
Archive Log 126 02-FEB-16 +DATAFILE/orcl/archivelog/2016_02_02/thread_1_seq_65.274.902760169
Archive Log 127 02-FEB-16 +DATAFILE/orcl/archivelog/2016_02_02/thread_2_seq_62.275.902760169
Archive Log 128 04-FEB-16 +DATAFILE/orcl/archivelog/2016_02_04/thread_1_seq_66.276.902909021
Archive Log 129 05-FEB-16 +DATAFILE/orcl/archivelog/2016_02_05/thread_2_seq_63.277.903042015
Archive Log 130 06-FEB-16 +DATAFILE/orcl/archivelog/2016_02_06/thread_1_seq_67.278.903057517
Archive Log 131 07-FEB-16 +DATAFILE/orcl/archivelog/2016_02_07/thread_1_seq_68.279.903193267
Archive Log 132 09-FEB-16 +DATAFILE/orcl/archivelog/2016_02_09/thread_2_seq_64.280.903323695
Archive Log 133 09-FEB-16 +DATAFILE/orcl/archivelog/2016_02_09/thread_1_seq_69.281.903341501
Archive Log 134 11-FEB-16 +DATAFILE/orcl/archivelog/2016_02_11/thread_1_seq_70.282.903520865
Archive Log 135 11-FEB-16 +DATAFILE/orcl/archivelog/2016_02_11/thread_2_seq_65.283.903540795
Archive Log 136 11-FEB-16 +DATAFILE/orcl/archivelog/2016_02_11/thread_2_seq_66.284.903544671
Archive Log 137 11-FEB-16 +DATAFILE/orcl/archivelog/2016_02_11/thread_2_seq_67.286.903544681
Archive Log 138 11-FEB-16 +DATAFILE/orcl/archivelog/2016_02_11/thread_1_seq_71.285.903544681
Archive Log 139 11-FEB-16 +DATAFILE/orcl/archivelog/2016_02_11/thread_1_seq_72.287.903550011
Archive Log 140 13-FEB-16 /home/oracle/archivelog/1_73_894471954.dbf
Archive Log 141 15-FEB-16 /home/oracle/archivelog/2_68_894471954.dbf
Archive Log 142 15-FEB-16 /home/oracle/archivelog/1_74_894471954.dbf
Archive Log 143 17-FEB-16 /home/oracle/archivelog/1_75_894471954.dbf
Archive Log 144 18-FEB-16 /home/oracle/archivelog/2_69_894471954.dbf
Archive Log 145 18-FEB-16 /home/oracle/archivelog/1_76_894471954.dbf
Archive Log 146 20-FEB-16 /home/oracle/archivelog/1_77_894471954.dbf
Archive Log 147 21-FEB-16 /home/oracle/archivelog/2_70_894471954.dbf
Archive Log 148 22-FEB-16 /home/oracle/archivelog/1_78_894471954.dbf
Archive Log 149 14-MAR-16 /home/oracle/archivelog/2_72_894471954.dbf
Archive Log 150 14-MAR-16 /home/oracle/archivelog/2_71_894471954.dbf
Archive Log 151 14-MAR-16 /home/oracle/archivelog/1_79_894471954.dbf
Archive Log 152 14-MAR-16 /home/oracle/archivelog/1_80_894471954.dbf
Archive Log 153 14-MAR-16 /home/oracle/archivelog/1_81_894471954.dbf
Archive Log 154 14-MAR-16 /home/oracle/archivelog/2_73_894471954.dbf
Archive Log 155 14-MAR-16 /home/oracle/archivelog/1_82_894471954.dbf
Archive Log 156 14-MAR-16 /home/oracle/archivelog/2_74_894471954.dbf
Archive Log 157 15-MAR-16 /home/oracle/archivelog/2_75_894471954.dbf
Archive Log 158 16-MAR-16 +FRA/orcl/archivelog/2016_03_16/thread_1_seq_83.340.906647259
Backup Set 57 16-MAR-16
Backup Piece 57 16-MAR-16 /home/oracle/db-full-1qr0krsu_1_1
Backup Set 58 16-MAR-16
Backup Piece 58 16-MAR-16 /home/oracle/db-full-1rr0ks2l_1_1
-------->>>值得注意的是，并不显示thread 1的sequence 84号归档
第七：测试delete obsolete命令
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log 88 13-JAN-16 /home/oracle/archivelog/2_42_894471954.dbf
Archive Log 89 13-JAN-16 /home/oracle/archivelog/1_47_894471954.dbf
Archive Log 90 13-JAN-16 /home/oracle/archivelog/2_43_894471954.dbf
Archive Log 91 13-JAN-16 /home/oracle/archivelog/2_44_894471954.dbf
Archive Log 92 13-JAN-16 /home/oracle/archivelog/1_48_894471954.dbf
Archive Log 93 13-JAN-16 /home/oracle/archivelog/2_45_894471954.dbf
Archive Log 94 13-JAN-16 /home/oracle/archivelog/1_49_894471954.dbf
Archive Log 95 13-JAN-16 /home/oracle/archivelog/1_50_894471954.dbf
Archive Log 96 13-JAN-16 /home/oracle/archivelog/2_46_894471954.dbf
Archive Log 97 13-JAN-16 /home/oracle/archivelog/1_51_894471954.dbf
Archive Log 98 13-JAN-16 /home/oracle/archivelog/2_47_894471954.dbf
Archive Log 99 13-JAN-16 /home/oracle/archivelog/1_52_894471954.dbf
Archive Log 100 13-JAN-16 /home/oracle/archivelog/2_48_894471954.dbf
Archive Log 101 13-JAN-16 /home/oracle/archivelog/2_49_894471954.dbf
Archive Log 102 13-JAN-16 /home/oracle/archivelog/1_53_894471954.dbf
Archive Log 103 13-JAN-16 /home/oracle/archivelog/1_54_894471954.dbf
Archive Log 104 13-JAN-16 /home/oracle/archivelog/2_50_894471954.dbf
Backup Set 1 13-JAN-16
Backup Piece 1 13-JAN-16 /home/oracle/backup/db_01qr9hqm_1_1
Backup Set 2 13-JAN-16
Backup Piece 2 13-JAN-16 /home/oracle/backup/db_02qr9hqp_1_1
Backup Set 4 13-JAN-16
Backup Piece 4 13-JAN-16 /home/oracle/backup/db_03qr9hs7_1_1
Backup Set 3 13-JAN-16
Backup Piece 3 13-JAN-16 /home/oracle/backup/db_04qr9hs7_1_1
Backup Set 5 13-JAN-16
Backup Piece 5 13-JAN-16 /home/oracle/backup/db_05qr9hsb_1_1
Backup Set 6 13-JAN-16
Backup Piece 6 13-JAN-16 /home/oracle/backup/db_06qr9hsb_1_1
Backup Set 7 13-JAN-16
Backup Piece 7 13-JAN-16 /home/oracle/backup/db_07qr9hsc_1_1
Backup Set 8 13-JAN-16
Backup Piece 8 13-JAN-16 /home/oracle/backup/db_08qr9hsc_1_1
Backup Set 9 13-JAN-16
Backup Piece 9 13-JAN-16 /home/oracle/backup/db_09qr9hsd_1_1
Backup Set 10 13-JAN-16
Backup Piece 10 13-JAN-16 /home/oracle/backup/db_0aqr9hsd_1_1
Backup Set 11 13-JAN-16
Backup Piece 11 13-JAN-16 /home/oracle/backup/db_0bqr9hsd_1_1
Backup Set 12 13-JAN-16
Backup Piece 12 13-JAN-16 /home/oracle/backup/db_0cqr9hsd_1_1
Backup Set 13 13-JAN-16
Backup Piece 13 13-JAN-16 /home/oracle/backup/db_0dqr9hse_1_1
Backup Set 14 13-JAN-16
Backup Piece 14 13-JAN-16 /home/oracle/backup/db_0eqr9hse_1_1
Backup Set 15 13-JAN-16
Backup Piece 15 13-JAN-16 /home/oracle/backup/db_0fqr9hse_1_1
Backup Set 16 13-JAN-16
Backup Piece 16 13-JAN-16 /home/oracle/backup/db_0gqr9hse_1_1
Backup Set 17 13-JAN-16
Backup Piece 17 13-JAN-16 /home/oracle/backup/db_0hqr9hsf_1_1
Backup Set 18 13-JAN-16
Backup Piece 18 13-JAN-16 /home/oracle/backup/db_0iqr9hsg_1_1
Backup Set 19 13-JAN-16
Backup Piece 19 13-JAN-16 /home/oracle/backup/db_0jqr9hsh_1_1
Backup Set 20 13-JAN-16
Backup Piece 20 13-JAN-16 /home/oracle/backup/db_0kqr9hsi_1_1
Backup Set 21 13-JAN-16
Backup Piece 21 13-JAN-16 /home/oracle/backup/db_0lqr9hsi_1_1
Backup Set 22 13-JAN-16
Backup Piece 22 13-JAN-16 /home/oracle/backup/db_0mqr9hsi_1_1
Backup Set 23 13-JAN-16
Backup Piece 23 13-JAN-16 /home/oracle/backup/db_0nqr9hsi_1_1
Backup Set 24 13-JAN-16
Backup Piece 24 13-JAN-16 /home/oracle/backup/db_0oqr9hsj_1_1
Backup Set 25 13-JAN-16
Backup Piece 25 13-JAN-16 /home/oracle/backup/arch_1_0pqr9hsl_1_1
Backup Set 26 13-JAN-16
Backup Piece 26 13-JAN-16 /home/oracle/backup/arch_2_0qqr9hsl_1_1
Archive Log 105 13-JAN-16 /home/oracle/archivelog/2_51_894471954.dbf
Backup Set 27 13-JAN-16
Backup Piece 27 13-JAN-16 /home/oracle/backup/arch_2_0sqr9hvd_1_1
Archive Log 106 13-JAN-16 /home/oracle/archivelog/1_55_894471954.dbf
Archive Log 107 13-JAN-16 /home/oracle/archivelog/1_56_894471954.dbf
Archive Log 108 13-JAN-16 /home/oracle/archivelog/2_52_894471954.dbf
Archive Log 109 13-JAN-16 /home/oracle/archivelog/2_53_894471954.dbf
Archive Log 110 13-JAN-16 /home/oracle/archivelog/1_57_894471954.dbf
Archive Log 111 13-JAN-16 /home/oracle/archivelog/1_58_894471954.dbf
Archive Log 112 13-JAN-16 /home/oracle/archivelog/2_54_894471954.dbf
Archive Log 114 13-JAN-16 /home/oracle/archivelog/1_59_894471954.dbf
Archive Log 113 13-JAN-16 /home/oracle/archivelog/2_55_894471954.dbf
Backup Set 28 13-JAN-16
Backup Piece 28 13-JAN-16 /home/oracle/backup/arch_1_0tqr9jl2_1_1
Backup Set 29 13-JAN-16
Backup Piece 29 13-JAN-16 /home/oracle/backup/arch_2_0uqr9jl7_1_1
Backup Set 31 13-JAN-16
Backup Piece 31 13-JAN-16 /home/oracle/backup/arch_2_0vqr9jml_1_1
Backup Set 30 13-JAN-16
Backup Piece 30 13-JAN-16 /home/oracle/backup/arch_1_10qr9jml_1_1
Backup Set 32 13-JAN-16
Backup Piece 32 13-JAN-16 /home/oracle/backup/arch_2_11qr9jmm_1_1
Backup Set 33 13-JAN-16
Backup Piece 33 13-JAN-16 /home/oracle/backup/arch_1_12qr9jmn_1_1
Backup Set 34 13-JAN-16
Backup Piece 34 13-JAN-16 /home/oracle/backup/arch_2_13qr9jmn_1_1
Backup Set 35 13-JAN-16
Backup Piece 35 13-JAN-16 /home/oracle/backup/arch_1_14qr9jmn_1_1
Backup Set 36 13-JAN-16
Backup Piece 36 13-JAN-16 /home/oracle/backup/arch_2_15qr9jmo_1_1
Backup Set 37 13-JAN-16
Backup Piece 37 13-JAN-16 /home/oracle/backup/arch_1_16qr9jmq_1_1
Backup Set 38 13-JAN-16
Backup Piece 38 13-JAN-16 /home/oracle/backup/arch_2_17qr9jms_1_1
Backup Set 39 13-JAN-16
Backup Piece 39 13-JAN-16 /home/oracle/backup/arch_1_18qr9jms_1_1
Backup Set 40 13-JAN-16
Backup Piece 40 13-JAN-16 /home/oracle/backup/arch_2_19qr9jmt_1_1
Backup Set 41 13-JAN-16
Backup Piece 41 13-JAN-16 /home/oracle/backup/arch_1_1aqr9jmu_1_1
Backup Set 42 13-JAN-16
Backup Piece 42 13-JAN-16 /home/oracle/backup/arch_2_1bqr9jn0_1_1
Backup Set 43 13-JAN-16
Backup Piece 43 13-JAN-16 /home/oracle/backup/arch_1_1cqr9jn1_1_1
Backup Set 44 13-JAN-16
Backup Piece 44 13-JAN-16 /home/oracle/backup/arch_2_1dqr9jn1_1_1
Backup Set 45 13-JAN-16
Backup Piece 45 13-JAN-16 /home/oracle/backup/arch_1_1eqr9jn2_1_1
Backup Set 46 13-JAN-16
Backup Piece 46 13-JAN-16 /home/oracle/backup/arch_2_1fqr9jn3_1_1
Backup Set 47 13-JAN-16
Backup Piece 47 13-JAN-16 /home/oracle/backup/arch_1_1gqr9jn3_1_1
Backup Set 48 13-JAN-16
Backup Piece 48 13-JAN-16 /home/oracle/backup/arch_2_1hqr9jn3_1_1
Backup Set 49 13-JAN-16
Backup Piece 49 13-JAN-16 /home/oracle/backup/arch_1_1iqr9jn4_1_1
Backup Set 50 13-JAN-16
Backup Piece 50 13-JAN-16 /home/oracle/backup/arch_2_1jqr9jn4_1_1
Backup Set 51 13-JAN-16
Backup Piece 51 13-JAN-16 /home/oracle/backup/arch_1_1kqr9jn4_1_1
Backup Set 52 13-JAN-16
Backup Piece 52 13-JAN-16 /home/oracle/backup/arch_2_1lqr9jn5_1_1
Backup Set 53 13-JAN-16
Backup Piece 53 13-JAN-16 /home/oracle/backup/arch_1_1mqr9jn5_1_1
Backup Set 54 13-JAN-16
Backup Piece 54 13-JAN-16 /home/oracle/backup/arch_2_1nqr9jn5_1_1
Backup Set 55 13-JAN-16
Backup Piece 55 13-JAN-16 /home/oracle/backup/arch_1_1oqr9jn6_1_1
Archive Log 115 19-JAN-16 /home/oracle/archivelog/1_60_894471954.dbf
Backup Set 56 13-JAN-16
Backup Piece 56 13-JAN-16 /home/oracle/backup/arch_2_1pqr9jn6_1_1
Archive Log 116 20-JAN-16 /home/oracle/archivelog/2_56_894471954.dbf
Archive Log 117 24-JAN-16 /home/oracle/archivelog/2_57_894471954.dbf
Archive Log 118 24-JAN-16 /home/oracle/archivelog/1_61_894471954.dbf
Archive Log 119 27-JAN-16 /home/oracle/archivelog/2_58_894471954.dbf
Archive Log 120 30-JAN-16 /home/oracle/archivelog/2_59_894471954.dbf
Archive Log 121 30-JAN-16 /home/oracle/archivelog/1_62_894471954.dbf
Archive Log 122 01-FEB-16 /home/oracle/archivelog/2_60_894471954.dbf
Archive Log 123 02-FEB-16 +DATAFILE/orcl/archivelog/2016_02_02/thread_1_seq_63.270.902759171
Archive Log 124 02-FEB-16 +DATAFILE/orcl/archivelog/2016_02_02/thread_1_seq_64.271.902759259
Archive Log 125 02-FEB-16 +DATAFILE/orcl/archivelog/2016_02_02/thread_2_seq_61.272.902759261
Archive Log 126 02-FEB-16 +DATAFILE/orcl/archivelog/2016_02_02/thread_1_seq_65.274.902760169
Archive Log 127 02-FEB-16 +DATAFILE/orcl/archivelog/2016_02_02/thread_2_seq_62.275.902760169
Archive Log 128 04-FEB-16 +DATAFILE/orcl/archivelog/2016_02_04/thread_1_seq_66.276.902909021
Archive Log 129 05-FEB-16 +DATAFILE/orcl/archivelog/2016_02_05/thread_2_seq_63.277.903042015
Archive Log 130 06-FEB-16 +DATAFILE/orcl/archivelog/2016_02_06/thread_1_seq_67.278.903057517
Archive Log 131 07-FEB-16 +DATAFILE/orcl/archivelog/2016_02_07/thread_1_seq_68.279.903193267
Archive Log 132 09-FEB-16 +DATAFILE/orcl/archivelog/2016_02_09/thread_2_seq_64.280.903323695
Archive Log 133 09-FEB-16 +DATAFILE/orcl/archivelog/2016_02_09/thread_1_seq_69.281.903341501
Archive Log 134 11-FEB-16 +DATAFILE/orcl/archivelog/2016_02_11/thread_1_seq_70.282.903520865
Archive Log 135 11-FEB-16 +DATAFILE/orcl/archivelog/2016_02_11/thread_2_seq_65.283.903540795
Archive Log 136 11-FEB-16 +DATAFILE/orcl/archivelog/2016_02_11/thread_2_seq_66.284.903544671
Archive Log 137 11-FEB-16 +DATAFILE/orcl/archivelog/2016_02_11/thread_2_seq_67.286.903544681
Archive Log 138 11-FEB-16 +DATAFILE/orcl/archivelog/2016_02_11/thread_1_seq_71.285.903544681
Archive Log 139 11-FEB-16 +DATAFILE/orcl/archivelog/2016_02_11/thread_1_seq_72.287.903550011
Archive Log 140 13-FEB-16 /home/oracle/archivelog/1_73_894471954.dbf
Archive Log 141 15-FEB-16 /home/oracle/archivelog/2_68_894471954.dbf
Archive Log 142 15-FEB-16 /home/oracle/archivelog/1_74_894471954.dbf
Archive Log 143 17-FEB-16 /home/oracle/archivelog/1_75_894471954.dbf
Archive Log 144 18-FEB-16 /home/oracle/archivelog/2_69_894471954.dbf
Archive Log 145 18-FEB-16 /home/oracle/archivelog/1_76_894471954.dbf
Archive Log 146 20-FEB-16 /home/oracle/archivelog/1_77_894471954.dbf
Archive Log 147 21-FEB-16 /home/oracle/archivelog/2_70_894471954.dbf
Archive Log 148 22-FEB-16 /home/oracle/archivelog/1_78_894471954.dbf
Archive Log 149 14-MAR-16 /home/oracle/archivelog/2_72_894471954.dbf
Archive Log 150 14-MAR-16 /home/oracle/archivelog/2_71_894471954.dbf
Archive Log 151 14-MAR-16 /home/oracle/archivelog/1_79_894471954.dbf
Archive Log 152 14-MAR-16 /home/oracle/archivelog/1_80_894471954.dbf
Archive Log 153 14-MAR-16 /home/oracle/archivelog/1_81_894471954.dbf
Archive Log 154 14-MAR-16 /home/oracle/archivelog/2_73_894471954.dbf
Archive Log 155 14-MAR-16 /home/oracle/archivelog/1_82_894471954.dbf
Archive Log 156 14-MAR-16 /home/oracle/archivelog/2_74_894471954.dbf
Archive Log 157 15-MAR-16 /home/oracle/archivelog/2_75_894471954.dbf
Archive Log 158 16-MAR-16 +FRA/orcl/archivelog/2016_03_16/thread_1_seq_83.340.906647259
Backup Set 57 16-MAR-16
Backup Piece 57 16-MAR-16 /home/oracle/db-full-1qr0krsu_1_1
Backup Set 58 16-MAR-16
Backup Piece 58 16-MAR-16 /home/oracle/db-full-1rr0ks2l_1_1
Do you really want to delete the above objects (enter YES or NO)?
-------->>>值得注意的是，并不显示thread 1的sequence 84号归档
