Re: Rman purging issue
Posted by Sumair on Jun 29, 2016; 9:31am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Rman-purging-issue-tp1089p1127.html
RMAN> list backupset tag 'TAG20160606T164202'
2> ;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
49785 Incr 0 294.41G SBT_TAPE 00:21:53 06-JUN-16
BP Key: 49785 Status: AVAILABLE Compressed: NO Tag: TAG20160606T1642 02
Handle: D_ORA_DB_FULL<SCC1_50205:913826523:1>.dbf Media: 3902010a:51c7 f847:02b8:0003
List of Datafiles in backup set 49785
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/system.339.822412947
5 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/system.342.822412963
7 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/system.348.822413019
8 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/system.334.822412881
15 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_undots1.316.8224123 21
20 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_archive.325.8224 12731
23 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_media.265.822410 033
26 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_media.323.822412 665
32 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_seed.331.8224128 57
33 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_seed.336.8224129 07
37 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.270.8224 10197
39 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.259.8224 09843
41 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.273.8224 10317
44 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.276.8224 10413
47 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.279.8224 10605
50 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.282.8224 10699
53 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.285.8224 10891
56 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.288.8224 10985
59 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.291.8224 11177
62 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.294.8224 11271
65 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.297.8224 11463
68 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.300.8224 11557
71 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.319.8224 12495
72 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.303.8224 11749
75 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.304.82241 1749
78 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.307.82241 1939
81 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.310.82241 2035
84 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.313.82241 2225
87 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.330.82241 2821
88 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/ctxd.353.822413065
89 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/odm.355.822413067
90 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/olap.356.822413067
94 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/xxscc.338.822412933
97 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/xxscc_ts.345.822413005
98 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.256.82240 9673
101 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.262.8224 09981
104 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/undotbs2.369.822414027
107 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/system_15.dbf
112 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data01.dbf
115 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data03.dbf
118 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data05.dbf
123 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data1.301.dbf
126 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data2.301.dbf
129 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/undots3.dbf
131 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data3.302.dbf
132 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx3.313.dbf
137 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data610.301.d bf
140 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/xxscc.338.822412610.dbf
142 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_seed.336.8224126 10.dbf
148 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data70115.301 5.dbf
150 0 Incr 21470529486 06-JUN-16 +DATA/scc/datafile/system0402.2016.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
49786 Incr 0 286.77G SBT_TAPE 00:18:24 06-JUN-16
BP Key: 49786 Status: AVAILABLE Compressed: NO Tag: TAG20160606T1642 02
Handle: D_ORA_DB_FULL<SCC1_50206:913827840:1>.dbf Media: 3902010a:51c7 f847:02b8:0003
List of Datafiles in backup set 49786
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/system.340.822412949
10 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/system.346.822413005
11 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/system.343.822412989
12 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/system.335.822412907
13 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/system.257.822409673
14 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/system.258.822409717
16 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_undots1.317.8224124 05
19 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/sysaux.332.822412857
21 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_interface.328.82 2412785
24 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_media.266.822410 089
28 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_queues.268.82241 0115
29 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_queues.314.82241 2225
30 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_queues.329.82241 2821
35 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tools.351.822413 051
38 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.271.8224 10223
42 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.274.8224 10319
45 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.277.8224 10509
48 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.280.8224 10605
51 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.283.8224 10795
54 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.286.8224 10891
57 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.289.8224 11081
60 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.292.8224 11177
63 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.295.8224 11367
66 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.298.8224 11463
69 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.301.8224 11653
73 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.326.8224 12731
76 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.305.82241 1843
79 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.308.82241 1939
82 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.311.82241 2129
85 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.320.82241 2495
86 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.321.82241 2579
92 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/portal.354.822413065
93 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/scc_readonly.337.8224129 33
96 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/xxscc_ts.322.822412579
99 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.260.82240 9959
102 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.263.8224 10007
105 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/undotbs2.370.822414041
109 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_summary02.dbf
113 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data02.dbf
116 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx01.dbf
119 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_archive.325.dbf
121 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.313.dbf
124 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_undots1.dbf
127 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx2.313.dbf
130 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data2.302.dbf
134 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/undots4.dbf
135 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_media_224.dbf
138 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data611.301.d bf
141 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/xxscc.338.822412611.dbf
143 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data7915.301. dbf
145 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data41115.301 2.dbf
151 0 Incr 21470648716 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data040216.30 16.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
49787 Incr 0 281.94G SBT_TAPE 00:18:16 06-JUN-16
BP Key: 49787 Status: AVAILABLE Compressed: NO Tag: TAG20160606T1642 02
Handle: D_ORA_DB_FULL<SCC1_50207:913828946:1>.dbf Media: 3902010a:51c7 f847:02b8:0003
List of Datafiles in backup set 49787
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/system.344.822412989
4 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/system.341.822412963
6 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/system.347.822413019
9 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/system.350.822413035
17 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_undots1.318.8224124 09
18 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_undots1.324.8224126 65
22 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_media.264.822410 007
25 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_media.267.822410 115
27 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_nologging.349.82 2413035
31 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_seed.333.8224128 81
34 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_summary.327.8224 12785
36 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.269.8224 10141
40 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.272.8224 10223
43 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.275.8224 10413
46 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.278.8224 10509
49 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.281.8224 10699
52 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.284.8224 10795
55 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.287.8224 10985
58 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.290.8224 11081
61 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.293.8224 11271
64 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.296.8224 11367
67 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.299.8224 11557
70 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.302.8224 11653
74 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.352.8224 13051
77 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.306.82241 1843
80 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.309.82241 2035
83 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.312.82241 2129
91 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/owapub.357.822413069
95 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/xxscc_ts.315.822412321
100 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx.261.82240 9973
103 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/undotbs2.368.822414013
106 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/undotbs2.371.822414055
108 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/sysaux01.dbf
110 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_media_01.dbf
111 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_queues_01.dbf
114 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_media_02.dbf
117 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data04.dbf
120 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_queues.314.dbf
122 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data.301.dbf
125 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/undots2.dbf
128 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/xxscc_ts1.315.822412321. .dbf
133 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data4.302.dbf
136 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data224.301.d bf
139 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_idx610.301.db f
144 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data61015.301 .dbf
146 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data61215.301 3.dbf
147 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_media61215.3014. dbf
149 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_nologging0302.20 16.dbf
152 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data050416.30 17.dbf
153 0 Incr 21470685541 06-JUN-16 +DATA/scc/datafile/apps_ts_tx_data230516.30 17.dbf
RMAN>
RMAN> list backuppiece '/backup/scc/rmanbackups/62r8ftc6_1_1';
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
51998 51998 1 1 AVAILABLE DISK /backup/scc/rmanbackups/62r8ftc6_1_1
RMAN> list backuppiece '/backup/scc/rmanbackups/63r8ftcv_1_1';
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
51999 51999 1 1 AVAILABLE DISK /backup/scc/rmanbackups/63r8ftcv_1_1
RMAN> list backuppiece '/backup/scc/rmanbackups/hdr98052_1_1';
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
54403 54403 1 1 AVAILABLE DISK /backup/scc/rmanbackups/hdr98052_1_1