课程第33次（2016-06-12星期五）：配置可恢复性，了解rman retention policy指导的三件事情（report obsolete；repo

botang

【上完1Z0-053的第2章】：配置可恢复性，了解rman retention policy指导的三件事情（report obsolete；report need backup和备份优化策略失效）
【1Z0-051】：共10章（0 1 2 3 4 5 6 7 8 9）
【1Z0-052】：共12章（0 1 2 3 4 5 6 9 10 14 15 16）
【1Z0-053】：共6章（0 1 2 10 11 12）

1. select  * from v_$session s where s.PROGRAM  like '%rman%';
   
2. 
   
3. select log_mode from v$database;
   
4. 
   
5. select  * from v$archived_log   order by first_change#  desc;

复制代码

1. 
   
2. Recovery Manager complete.
   
3. [oracle@station90 ~]$ rman target  /  
   
4. 
   
5. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 14 11:46:37 2016
   
6. 
   
7. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
8. 
   
9. connected to target database: ORCL (DBID=1343950367)
   
10. 
    
11. RMAN> list backup;
    
12. 
    
13. using target database control file instead of recovery catalog
    
14. 
    
15. List of Backup Sets
    
16. ===================
    
17. 
    
18. 
    
19. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
20. ------- ---- -- ---------- ----------- ------------ ---------------
    
21. 75      Full    9.61M      DISK        00:00:00     06-JUN-16      
    
22.         BP Key: 75   Status: AVAILABLE  Compressed: NO  Tag: TAG20160606T213606
    
23.         Piece Name: +FRA/orcl/autobackup/2016_06_06/s_913844166.270.913844167
    
24.   SPFILE Included: Modification time: 02-JUN-16
    
25.   SPFILE db_unique_name: ORCL
    
26.   Control File Included: Ckp SCN: 1544220      Ckp time: 06-JUN-16
    
27. 
    
28. BS Key  Size       Device Type Elapsed Time Completion Time
    
29. ------- ---------- ----------- ------------ ---------------
    
30. 76      4.63M      SBT_TAPE    00:00:15     06-JUN-16      
    
31.         BP Key: 76   Status: AVAILABLE  Compressed: NO  Tag: TAG20160606T213612
    
32.         Handle: 2nr7g9uc_1_1   Media: station90-000013
    
33. 
    
34.   List of Archived Logs in backup set 76
    
35.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
    
36.   ---- ------- ---------- --------- ---------- ---------
    
37.   1    27      1541455    06-JUN-16 1544415    06-JUN-16
    
38. 
    
39. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
40. ------- ---- -- ---------- ----------- ------------ ---------------
    
41. 77      Full    9.63M      SBT_TAPE    00:00:21     06-JUN-16      
    
42.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: TAG20160606T213637
    
43.         Handle: c-1343950367-20160606-03   Media: station90-000013
    
44.   SPFILE Included: Modification time: 02-JUN-16
    
45.   SPFILE db_unique_name: ORCL
    
46.   Control File Included: Ckp SCN: 1544448      Ckp time: 06-JUN-16
    
47. 
    
48. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
49. ------- ---- -- ---------- ----------- ------------ ---------------
    
50. 78      Incr 1  13.34M     DISK        00:00:04     07-JUN-16      
    
51.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
    
52.         Piece Name: +FRA/orcl/backupset/2016_06_07/nnndn1_ora_oem_level_0_0.272.913930533
    
53.   List of Datafiles in backup set 78
    
54.   File LV Type Ckp SCN    Ckp Time  Name
    
55.   ---- -- ---- ---------- --------- ----
    
56.   1    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/system.256.914102913
    
57.   2    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553
    
58.   3    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553
    
59.   5    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/example.265.816169651
    
60. 
    
61. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
62. ------- ---- -- ---------- ----------- ------------ ---------------
    
63. 79      Full    9.61M      DISK        00:00:01     07-JUN-16      
    
64.         BP Key: 79   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213536
    
65.         Piece Name: +FRA/orcl/autobackup/2016_06_07/s_913930536.277.913930537
    
66.   SPFILE Included: Modification time: 07-JUN-16
    
67.   SPFILE db_unique_name: ORCL
    
68.   Control File Included: Ckp SCN: 1547197      Ckp time: 07-JUN-16
    
69. 
    
70. BS Key  Size       Device Type Elapsed Time Completion Time
    
71. ------- ---------- ----------- ------------ ---------------
    
72. 80      16.63M     SBT_TAPE    00:00:24     07-JUN-16      
    
73.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213543
    
74.         Handle: 2rr7iu9g_1_1   Media: station90-000013
    
75. 
    
76.   List of Archived Logs in backup set 80
    
77.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
    
78.   ---- ------- ---------- --------- ---------- ---------
    
79.   1    28      1544415    06-JUN-16 1547833    07-JUN-16
    
80. 
    
81. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
82. ------- ---- -- ---------- ----------- ------------ ---------------
    
83. 81      Full    9.63M      SBT_TAPE    00:00:15     07-JUN-16      
    
84.         BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213609
    
85.         Handle: c-1343950367-20160607-01   Media: station90-000013
    
86.   SPFILE Included: Modification time: 07-JUN-16
    
87.   SPFILE db_unique_name: ORCL
    
88.   Control File Included: Ckp SCN: 1548030      Ckp time: 07-JUN-16
    
89. 
    
90. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
91. ------- ---- -- ---------- ----------- ------------ ---------------
    
92. 82      Incr 1  16.52M     DISK        00:00:03     08-JUN-16      
    
93.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
    
94.         Piece Name: +FRA/orcl/backupset/2016_06_08/nnndn1_ora_oem_level_0_0.279.914016939
    
95.   List of Datafiles in backup set 82
    
96.   File LV Type Ckp SCN    Ckp Time  Name
    
97.   ---- -- ---- ---------- --------- ----
    
98.   1    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/system.256.914102913
    
99.   2    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553
    
100.   3    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553
     
101.   5    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/example.265.816169651
     
102. 
     
103. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
104. ------- ---- -- ---------- ----------- ------------ ---------------
     
105. 83      Full    9.61M      DISK        00:00:01     08-JUN-16      
     
106.         BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213539
     
107.         Piece Name: +FRA/orcl/autobackup/2016_06_08/s_914016939.280.914016941
     
108.   SPFILE Included: Modification time: 08-JUN-16
     
109.   SPFILE db_unique_name: ORCL
     
110.   Control File Included: Ckp SCN: 1550834      Ckp time: 08-JUN-16
     
111. 
     
112. BS Key  Size       Device Type Elapsed Time Completion Time
     
113. ------- ---------- ----------- ------------ ---------------
     
114. 84      9.69M      SBT_TAPE    00:00:23     08-JUN-16      
     
115.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213546
     
116.         Handle: 2vr7lilj_1_1   Media: station90-000013
     
117. 
     
118.   List of Archived Logs in backup set 84
     
119.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
120.   ---- ------- ---------- --------- ---------- ---------
     
121.   1    29      1547833    07-JUN-16 1551061    08-JUN-16
     
122. 
     
123. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
124. ------- ---- -- ---------- ----------- ------------ ---------------
     
125. 85      Full    9.63M      SBT_TAPE    00:00:16     08-JUN-16      
     
126.         BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213612
     
127.         Handle: c-1343950367-20160608-01   Media: station90-000013
     
128.   SPFILE Included: Modification time: 08-JUN-16
     
129.   SPFILE db_unique_name: ORCL
     
130.   Control File Included: Ckp SCN: 1551112      Ckp time: 08-JUN-16
     
131. 
     
132. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
133. ------- ---- -- ---------- ----------- ------------ ---------------
     
134. 86      Full    600.75M    SBT_TAPE    00:02:09     09-JUN-16      
     
135.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T201727
     
136.         Handle: 31r7o2en_1_1   Media: station90-000013
     
137.   List of Datafiles in backup set 86
     
138.   File LV Type Ckp SCN    Ckp Time  Name
     
139.   ---- -- ---- ---------- --------- ----
     
140.   1       Full 1577433    09-JUN-16 +DATA/orcl/datafile/system.256.914102913
     
141. 
     
142. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
143. ------- ---- -- ---------- ----------- ------------ ---------------
     
144. 87      Full    9.63M      SBT_TAPE    00:00:55     09-JUN-16      
     
145.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T201943
     
146.         Handle: c-1343950367-20160609-00   Media: station90-000013
     
147.   SPFILE Included: Modification time: 09-JUN-16
     
148.   SPFILE db_unique_name: ORCL
     
149.   Control File Included: Ckp SCN: 1577543      Ckp time: 09-JUN-16
     
150. 
     
151. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
152. ------- ---- -- ---------- ----------- ------------ ---------------
     
153. 88      Full    1.06M      SBT_TAPE    00:00:15     09-JUN-16      
     
154.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202130
     
155.         Handle: 33r7o2ma_1_1   Media: station90-000013
     
156.   List of Datafiles in backup set 88
     
157.   File LV Type Ckp SCN    Ckp Time  Name
     
158.   ---- -- ---- ---------- --------- ----
     
159.   4       Full 1577931    09-JUN-16 +DATA/orcl/datafile/users.259.914101365
     
160. 
     
161. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
162. ------- ---- -- ---------- ----------- ------------ ---------------
     
163. 89      Full    9.63M      SBT_TAPE    00:00:16     09-JUN-16      
     
164.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202155
     
165.         Handle: c-1343950367-20160609-01   Media: station90-000013
     
166.   SPFILE Included: Modification time: 09-JUN-16
     
167.   SPFILE db_unique_name: ORCL
     
168.   Control File Included: Ckp SCN: 1577971      Ckp time: 09-JUN-16
     
169. 
     
170. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
171. ------- ---- -- ---------- ----------- ------------ ---------------
     
172. 90      Full    9.61M      DISK        00:00:01     09-JUN-16      
     
173.         BP Key: 90   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T205016
     
174.         Piece Name: +FRA/orcl/autobackup/2016_06_09/s_914100616.313.914100617
     
175.   SPFILE Included: Modification time: 09-JUN-16
     
176.   SPFILE db_unique_name: ORCL
     
177.   Control File Included: Ckp SCN: 1579657      Ckp time: 09-JUN-16
     
178. 
     
179. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
180. ------- ---- -- ---------- ----------- ------------ ---------------
     
181. 91      Full    9.61M      DISK        00:00:00     09-JUN-16      
     
182.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T211017
     
183.         Piece Name: +FRA/orcl/autobackup/2016_06_09/s_914101817.298.914101817
     
184.   SPFILE Included: Modification time: 09-JUN-16
     
185.   SPFILE db_unique_name: ORCL
     
186.   Control File Included: Ckp SCN: 1581203      Ckp time: 09-JUN-16
     
187. 
     
188. RMAN> list backup summary ;
     
189. 
     
190. 
     
191. List of Backups
     
192. ===============
     
193. Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
     
194. ------- -- -- - ----------- --------------- ------- ------- ---------- ---
     
195. 75      B  F  A DISK        06-JUN-16       1       1       NO         TAG20160606T213606
     
196. 76      B  A  A SBT_TAPE    06-JUN-16       1       1       NO         TAG20160606T213612
     
197. 77      B  F  A SBT_TAPE    06-JUN-16       1       1       NO         TAG20160606T213637
     
198. 78      B  1  A DISK        07-JUN-16       1       1       NO         ORA_OEM_LEVEL_0
     
199. 79      B  F  A DISK        07-JUN-16       1       1       NO         TAG20160607T213536
     
200. 80      B  A  A SBT_TAPE    07-JUN-16       1       1       NO         TAG20160607T213543
     
201. 81      B  F  A SBT_TAPE    07-JUN-16       1       1       NO         TAG20160607T213609
     
202. 82      B  1  A DISK        08-JUN-16       1       1       NO         ORA_OEM_LEVEL_0
     
203. 83      B  F  A DISK        08-JUN-16       1       1       NO         TAG20160608T213539
     
204. 84      B  A  A SBT_TAPE    08-JUN-16       1       1       NO         TAG20160608T213546
     
205. 85      B  F  A SBT_TAPE    08-JUN-16       1       1       NO         TAG20160608T213612
     
206. 86      B  F  A SBT_TAPE    09-JUN-16       1       1       NO         TAG20160609T201727
     
207. 87      B  F  A SBT_TAPE    09-JUN-16       1       1       NO         TAG20160609T201943
     
208. 88      B  F  A SBT_TAPE    09-JUN-16       1       1       NO         TAG20160609T202130
     
209. 89      B  F  A SBT_TAPE    09-JUN-16       1       1       NO         TAG20160609T202155
     
210. 90      B  F  A DISK        09-JUN-16       1       1       NO         TAG20160609T205016
     
211. 91      B  F  A DISK        09-JUN-16       1       1       NO         TAG20160609T211017
     
212. 
     
213. RMAN> list backupset 77;
     
214. 
     
215. 
     
216. List of Backup Sets
     
217. ===================
     
218. 
     
219. 
     
220. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
221. ------- ---- -- ---------- ----------- ------------ ---------------
     
222. 77      Full    9.63M      SBT_TAPE    00:00:21     06-JUN-16      
     
223.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: TAG20160606T213637
     
224.         Handle: c-1343950367-20160606-03   Media: station90-000013
     
225.   Control File Included: Ckp SCN: 1544448      Ckp time: 06-JUN-16
     
226.   SPFILE Included: Modification time: 02-JUN-16
     
227.   SPFILE db_unique_name: ORCL
     
228. 
     
229. RMAN> list backup;
     
230. 
     
231. 
     
232. List of Backup Sets
     
233. ===================
     
234. 
     
235. 
     
236. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
237. ------- ---- -- ---------- ----------- ------------ ---------------
     
238. 75      Full    9.61M      DISK        00:00:00     06-JUN-16      
     
239.         BP Key: 75   Status: AVAILABLE  Compressed: NO  Tag: TAG20160606T213606
     
240.         Piece Name: +FRA/orcl/autobackup/2016_06_06/s_913844166.270.913844167
     
241.   SPFILE Included: Modification time: 02-JUN-16
     
242.   SPFILE db_unique_name: ORCL
     
243.   Control File Included: Ckp SCN: 1544220      Ckp time: 06-JUN-16
     
244. 
     
245. BS Key  Size       Device Type Elapsed Time Completion Time
     
246. ------- ---------- ----------- ------------ ---------------
     
247. 76      4.63M      SBT_TAPE    00:00:15     06-JUN-16      
     
248.         BP Key: 76   Status: AVAILABLE  Compressed: NO  Tag: TAG20160606T213612
     
249.         Handle: 2nr7g9uc_1_1   Media: station90-000013
     
250. 
     
251.   List of Archived Logs in backup set 76
     
252.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
253.   ---- ------- ---------- --------- ---------- ---------
     
254.   1    27      1541455    06-JUN-16 1544415    06-JUN-16
     
255. 
     
256. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
257. ------- ---- -- ---------- ----------- ------------ ---------------
     
258. 77      Full    9.63M      SBT_TAPE    00:00:21     06-JUN-16      
     
259.         BP Key: 77   Status: AVAILABLE  Compressed: NO  Tag: TAG20160606T213637
     
260.         Handle: c-1343950367-20160606-03   Media: station90-000013
     
261.   SPFILE Included: Modification time: 02-JUN-16
     
262.   SPFILE db_unique_name: ORCL
     
263.   Control File Included: Ckp SCN: 1544448      Ckp time: 06-JUN-16
     
264. 
     
265. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
266. ------- ---- -- ---------- ----------- ------------ ---------------
     
267. 78      Incr 1  13.34M     DISK        00:00:04     07-JUN-16      
     
268.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
     
269.         Piece Name: +FRA/orcl/backupset/2016_06_07/nnndn1_ora_oem_level_0_0.272.913930533
     
270.   List of Datafiles in backup set 78
     
271.   File LV Type Ckp SCN    Ckp Time  Name
     
272.   ---- -- ---- ---------- --------- ----
     
273.   1    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/system.256.914102913
     
274.   2    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553
     
275.   3    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553
     
276.   5    1  Incr 1547159    07-JUN-16 +DATA/orcl/datafile/example.265.816169651
     
277. 
     
278. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
279. ------- ---- -- ---------- ----------- ------------ ---------------
     
280. 79      Full    9.61M      DISK        00:00:01     07-JUN-16      
     
281.         BP Key: 79   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213536
     
282.         Piece Name: +FRA/orcl/autobackup/2016_06_07/s_913930536.277.913930537
     
283.   SPFILE Included: Modification time: 07-JUN-16
     
284.   SPFILE db_unique_name: ORCL
     
285.   Control File Included: Ckp SCN: 1547197      Ckp time: 07-JUN-16
     
286. 
     
287. BS Key  Size       Device Type Elapsed Time Completion Time
     
288. ------- ---------- ----------- ------------ ---------------
     
289. 80      16.63M     SBT_TAPE    00:00:24     07-JUN-16      
     
290.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213543
     
291.         Handle: 2rr7iu9g_1_1   Media: station90-000013
     
292. 
     
293.   List of Archived Logs in backup set 80
     
294.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
295.   ---- ------- ---------- --------- ---------- ---------
     
296.   1    28      1544415    06-JUN-16 1547833    07-JUN-16
     
297. 
     
298. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
299. ------- ---- -- ---------- ----------- ------------ ---------------
     
300. 81      Full    9.63M      SBT_TAPE    00:00:15     07-JUN-16      
     
301.         BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213609
     
302.         Handle: c-1343950367-20160607-01   Media: station90-000013
     
303.   SPFILE Included: Modification time: 07-JUN-16
     
304.   SPFILE db_unique_name: ORCL
     
305.   Control File Included: Ckp SCN: 1548030      Ckp time: 07-JUN-16
     
306. 
     
307. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
308. ------- ---- -- ---------- ----------- ------------ ---------------
     
309. 82      Incr 1  16.52M     DISK        00:00:03     08-JUN-16      
     
310.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
     
311.         Piece Name: +FRA/orcl/backupset/2016_06_08/nnndn1_ora_oem_level_0_0.279.914016939
     
312.   List of Datafiles in backup set 82
     
313.   File LV Type Ckp SCN    Ckp Time  Name
     
314.   ---- -- ---- ---------- --------- ----
     
315.   1    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/system.256.914102913
     
316.   2    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553
     
317.   3    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553
     
318.   5    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/example.265.816169651
     
319. 
     
320. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
321. ------- ---- -- ---------- ----------- ------------ ---------------
     
322. 83      Full    9.61M      DISK        00:00:01     08-JUN-16      
     
323.         BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213539
     
324.         Piece Name: +FRA/orcl/autobackup/2016_06_08/s_914016939.280.914016941
     
325.   SPFILE Included: Modification time: 08-JUN-16
     
326.   SPFILE db_unique_name: ORCL
     
327.   Control File Included: Ckp SCN: 1550834      Ckp time: 08-JUN-16
     
328. 
     
329. BS Key  Size       Device Type Elapsed Time Completion Time
     
330. ------- ---------- ----------- ------------ ---------------
     
331. 84      9.69M      SBT_TAPE    00:00:23     08-JUN-16      
     
332.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213546
     
333.         Handle: 2vr7lilj_1_1   Media: station90-000013
     
334. 
     
335.   List of Archived Logs in backup set 84
     
336.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
337.   ---- ------- ---------- --------- ---------- ---------
     
338.   1    29      1547833    07-JUN-16 1551061    08-JUN-16
     
339. 
     
340. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
341. ------- ---- -- ---------- ----------- ------------ ---------------
     
342. 85      Full    9.63M      SBT_TAPE    00:00:16     08-JUN-16      
     
343.         BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213612
     
344.         Handle: c-1343950367-20160608-01   Media: station90-000013
     
345.   SPFILE Included: Modification time: 08-JUN-16
     
346.   SPFILE db_unique_name: ORCL
     
347.   Control File Included: Ckp SCN: 1551112      Ckp time: 08-JUN-16
     
348. 
     
349. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
350. ------- ---- -- ---------- ----------- ------------ ---------------
     
351. 86      Full    600.75M    SBT_TAPE    00:02:09     09-JUN-16      
     
352.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T201727
     
353.         Handle: 31r7o2en_1_1   Media: station90-000013
     
354.   List of Datafiles in backup set 86
     
355.   File LV Type Ckp SCN    Ckp Time  Name
     
356.   ---- -- ---- ---------- --------- ----
     
357.   1       Full 1577433    09-JUN-16 +DATA/orcl/datafile/system.256.914102913
     
358. 
     
359. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
360. ------- ---- -- ---------- ----------- ------------ ---------------
     
361. 87      Full    9.63M      SBT_TAPE    00:00:55     09-JUN-16      
     
362.         BP Key: 87   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T201943
     
363.         Handle: c-1343950367-20160609-00   Media: station90-000013
     
364.   SPFILE Included: Modification time: 09-JUN-16
     
365.   SPFILE db_unique_name: ORCL
     
366.   Control File Included: Ckp SCN: 1577543      Ckp time: 09-JUN-16
     
367. 
     
368. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
369. ------- ---- -- ---------- ----------- ------------ ---------------
     
370. 88      Full    1.06M      SBT_TAPE    00:00:15     09-JUN-16      
     
371.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202130
     
372.         Handle: 33r7o2ma_1_1   Media: station90-000013
     
373.   List of Datafiles in backup set 88
     
374.   File LV Type Ckp SCN    Ckp Time  Name
     
375.   ---- -- ---- ---------- --------- ----
     
376.   4       Full 1577931    09-JUN-16 +DATA/orcl/datafile/users.259.914101365
     
377. 
     
378. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
379. ------- ---- -- ---------- ----------- ------------ ---------------
     
380. 89      Full    9.63M      SBT_TAPE    00:00:16     09-JUN-16      
     
381.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202155
     
382.         Handle: c-1343950367-20160609-01   Media: station90-000013
     
383.   SPFILE Included: Modification time: 09-JUN-16
     
384.   SPFILE db_unique_name: ORCL
     
385.   Control File Included: Ckp SCN: 1577971      Ckp time: 09-JUN-16
     
386. 
     
387. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
388. ------- ---- -- ---------- ----------- ------------ ---------------
     
389. 90      Full    9.61M      DISK        00:00:01     09-JUN-16      
     
390.         BP Key: 90   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T205016
     
391.         Piece Name: +FRA/orcl/autobackup/2016_06_09/s_914100616.313.914100617
     
392.   SPFILE Included: Modification time: 09-JUN-16
     
393.   SPFILE db_unique_name: ORCL
     
394.   Control File Included: Ckp SCN: 1579657      Ckp time: 09-JUN-16
     
395. 
     
396. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
397. ------- ---- -- ---------- ----------- ------------ ---------------
     
398. 91      Full    9.61M      DISK        00:00:00     09-JUN-16      
     
399.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T211017
     
400.         Piece Name: +FRA/orcl/autobackup/2016_06_09/s_914101817.298.914101817
     
401.   SPFILE Included: Modification time: 09-JUN-16
     
402.   SPFILE db_unique_name: ORCL
     
403.   Control File Included: Ckp SCN: 1581203      Ckp time: 09-JUN-16
     
404. 
     
405. RMAN>
     
406. 
     

复制代码

botang

botang 发表于 2016-6-13 10:56

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     14-JUN-16      
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 14-JUN-16
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     14-JUN-16      
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1858946    14-JUN-16 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     14-JUN-16      
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4    0  Incr 1858958    14-JUN-16 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     14-JUN-16      
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 1858949    14-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     14-JUN-16      
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 14-JUN-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     14-JUN-16      
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 1858955    14-JUN-16 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     14-JUN-16      
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    0  Incr 1858952    14-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553

RMAN> exit


Recovery Manager complete.
[oracle@station90 archivelog]$ export NLS_DATE_FORMAT='YYYY-MM-DD:HH24:MI:SS'
[oracle@station90 archivelog]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 14 13:00:20 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1343950367)

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     2016-06-14:12:54:16
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     2016-06-14:12:55:00
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1858946    2016-06-14:12:53:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     2016-06-14:12:55:18
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1858958    2016-06-14:12:53:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     2016-06-14:12:55:44
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1858949    2016-06-14:12:53:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     2016-06-14:12:55:59
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 2016-06-14:12:53:51

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     2016-06-14:12:56:02
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1858955    2016-06-14:12:53:51 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     2016-06-14:12:56:18
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1858952    2016-06-14:12:53:50 +DATA/orcl/datafile/undotbs1.258.816169553

RMAN> exit


Recovery Manager complete.
[oracle@station90 archivelog]$ exit
logout
[root@station90 ~]# date
2016年 06月 14日 星期二 13:01:00 CST
[root@station90 ~]# export LANG=en_US
[root@station90 ~]# date
Tue Jun 14 13:01:09 CST 2016
[root@station90 ~]# date -s "Tue Jun 15 13:01:09 CST 2016"
Wed Jun 15 13:01:09 CST 2016
[root@station90 ~]# date
Wed Jun 15 13:01:14 CST 2016
[root@station90 ~]# su - oracle
[oracle@station90 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 15 13:01:25 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1343950367)

RMAN> backup tag '2T_WHOLE_INCR0'   incremental level 0 database ;

Starting backup at 15-JUN-16

using target database control file instead of recovery catalog
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=80 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=140 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: SID=202 device type=SBT_TAPE
channel ORA_SBT_TAPE_3: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: SID=203 device type=SBT_TAPE
channel ORA_SBT_TAPE_4: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_5
channel ORA_SBT_TAPE_5: SID=78 device type=SBT_TAPE
channel ORA_SBT_TAPE_5: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_6
channel ORA_SBT_TAPE_6: SID=15 device type=SBT_TAPE
channel ORA_SBT_TAPE_6: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_7
channel ORA_SBT_TAPE_7: SID=75 device type=SBT_TAPE
channel ORA_SBT_TAPE_7: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_8
channel ORA_SBT_TAPE_8: SID=141 device type=SBT_TAPE
channel ORA_SBT_TAPE_8: Oracle Secure Backup
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
channel ORA_SBT_TAPE_1: starting piece 1 at 15-JUN-16
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
channel ORA_SBT_TAPE_2: starting piece 1 at 15-JUN-16
channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
channel ORA_SBT_TAPE_3: starting piece 1 at 15-JUN-16
channel ORA_SBT_TAPE_4: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
channel ORA_SBT_TAPE_4: starting piece 1 at 15-JUN-16
channel ORA_SBT_TAPE_5: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_5: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
channel ORA_SBT_TAPE_5: starting piece 1 at 15-JUN-16
channel ORA_SBT_TAPE_6: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_6: specifying datafile(s) in backup set
channel ORA_SBT_TAPE_7: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_7: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_SBT_TAPE_7: starting piece 1 at 15-JUN-16
including current control file in backup set
channel ORA_SBT_TAPE_6: starting piece 1 at 15-JUN-16
channel ORA_SBT_TAPE_7: finished piece 1 at 15-JUN-16
piece handle=4fr8735o_1_1 tag=2T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_7: backup set complete, elapsed time: 00:00:26
channel ORA_SBT_TAPE_1: finished piece 1 at 15-JUN-16
piece handle=49r8735n_1_1 tag=2T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:07
channel ORA_SBT_TAPE_4: finished piece 1 at 15-JUN-16
piece handle=4cr8735n_1_1 tag=2T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:01:27
channel ORA_SBT_TAPE_5: finished piece 1 at 15-JUN-16
piece handle=4dr8735n_1_1 tag=2T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:01:26
channel ORA_SBT_TAPE_6: finished piece 1 at 15-JUN-16
piece handle=4er8735o_1_1 tag=2T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:01:45
channel ORA_SBT_TAPE_2: finished piece 1 at 15-JUN-16
piece handle=4ar8735n_1_1 tag=2T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:02:17
channel ORA_SBT_TAPE_3: finished piece 1 at 15-JUN-16
piece handle=4br8735n_1_1 tag=2T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:02:27
Finished backup at 15-JUN-16

RMAN>
RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     14-JUN-16      
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 14-JUN-16
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     14-JUN-16      
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1858946    14-JUN-16 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     14-JUN-16      
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4    0  Incr 1858958    14-JUN-16 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     14-JUN-16      
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 1858949    14-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     14-JUN-16      
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 14-JUN-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     14-JUN-16      
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 1858955    14-JUN-16 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     14-JUN-16      
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    0  Incr 1858952    14-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
126     Incr 0  128.00K    SBT_TAPE    00:00:24     15-JUN-16      
        BP Key: 126   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4fr8735o_1_1   Media: station90-000016
  SPFILE Included: Modification time: 14-JUN-16
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
127     Incr 0  602.69M    SBT_TAPE    00:01:06     15-JUN-16      
        BP Key: 127   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 49r8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 127
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1860003    15-JUN-16 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
128     Incr 0  1.13M      SBT_TAPE    00:01:21     15-JUN-16      
        BP Key: 128   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4dr8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 128
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4    0  Incr 1860015    15-JUN-16 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
129     Incr 0  14.94M     SBT_TAPE    00:01:26     15-JUN-16      
        BP Key: 129   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4cr8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 129
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 1860012    15-JUN-16 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
130     Incr 0  9.63M      SBT_TAPE    00:01:40     15-JUN-16      
        BP Key: 130   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4er8735o_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1860013      Ckp time: 15-JUN-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
131     Incr 0  510.00M    SBT_TAPE    00:02:09     15-JUN-16      
        BP Key: 131   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4ar8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 131
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 1860006    15-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
132     Incr 0  3.38M      SBT_TAPE    00:02:22     15-JUN-16      
        BP Key: 132   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4br8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 132
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    0  Incr 1860009    15-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553

RMAN> exit


Recovery Manager complete.
[oracle@station90 ~]$ exit
logout
[root@station90 ~]# date
Wed Jun 15 13:06:55 CST 2016
[root@station90 ~]# date -s "Wed Jun 16 13:06:55 CST 2016"
Thu Jun 16 13:06:55 CST 2016
[root@station90 ~]# date
Thu Jun 16 13:06:58 CST 2016
[root@station90 ~]# su - oracle
[oracle@station90 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 16 13:07:04 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1343950367)

RMAN> report obsolete;

using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           120    14-JUN-16         
  Backup Piece       120    14-JUN-16          42r84eau_1_1
Backup Set           122    14-JUN-16         
  Backup Piece       122    14-JUN-16          43r84eau_1_1
Backup Set           125    14-JUN-16         
  Backup Piece       125    14-JUN-16          44r84eau_1_1
Backup Set           124    14-JUN-16         
  Backup Piece       124    14-JUN-16          45r84eau_1_1
Backup Set           121    14-JUN-16         
  Backup Piece       121    14-JUN-16          46r84eau_1_1
Backup Set           123    14-JUN-16         
  Backup Piece       123    14-JUN-16          47r84eav_1_1
Backup Set           119    14-JUN-16         
  Backup Piece       119    14-JUN-16          48r84eav_1_1

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
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; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

RMAN> exit


Recovery Manager complete.
[oracle@station90 ~]$ exit
logout
[root@station90 ~]# date
Thu Jun 16 13:09:24 CST 2016
[root@station90 ~]# date -s "Thu Jun 15 23:59:00 CST 2016"
Wed Jun 15 23:59:00 CST 2016
[root@station90 ~]# su - oracle
[oracle@station90 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 15 23:59:05 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1343950367)

RMAN> report obsolete;

using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> list backupset 126;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
126     Incr 0  128.00K    SBT_TAPE    00:00:24     15-JUN-16      
        BP Key: 126   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4fr8735o_1_1   Media: station90-000016
  SPFILE Included: Modification time: 14-JUN-16
  SPFILE db_unique_name: ORCL

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    15-JUN-16         
  Backup Piece       126    15-JUN-16          4fr8735o_1_1

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     14-JUN-16      
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 14-JUN-16
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     14-JUN-16      
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1858946    14-JUN-16 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     14-JUN-16      
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4    0  Incr 1858958    14-JUN-16 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     14-JUN-16      
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 1858949    14-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     14-JUN-16      
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 14-JUN-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     14-JUN-16      
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 1858955    14-JUN-16 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     14-JUN-16      
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    0  Incr 1858952    14-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
126     Incr 0  128.00K    SBT_TAPE    00:00:24     15-JUN-16      
        BP Key: 126   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4fr8735o_1_1   Media: station90-000016
  SPFILE Included: Modification time: 14-JUN-16
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
127     Incr 0  602.69M    SBT_TAPE    00:01:06     15-JUN-16      
        BP Key: 127   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 49r8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 127
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1860003    15-JUN-16 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
128     Incr 0  1.13M      SBT_TAPE    00:01:21     15-JUN-16      
        BP Key: 128   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4dr8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 128
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4    0  Incr 1860015    15-JUN-16 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
129     Incr 0  14.94M     SBT_TAPE    00:01:26     15-JUN-16      
        BP Key: 129   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4cr8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 129
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 1860012    15-JUN-16 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
130     Incr 0  9.63M      SBT_TAPE    00:01:40     15-JUN-16      
        BP Key: 130   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4er8735o_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1860013      Ckp time: 15-JUN-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
131     Incr 0  510.00M    SBT_TAPE    00:02:09     15-JUN-16      
        BP Key: 131   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4ar8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 131
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 1860006    15-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
132     Incr 0  3.38M      SBT_TAPE    00:02:22     15-JUN-16      
        BP Key: 132   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4br8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 132
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    0  Incr 1860009    15-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553

RMAN> exit


Recovery Manager complete.
[oracle@station90 ~]$ vim .bash_profile
[oracle@station90 ~]$ . .bash_profile
[oracle@station90 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 16 00:01:28 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1343950367)

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     2016-06-14:12:54:16
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     2016-06-14:12:55:00
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1858946    2016-06-14:12:53:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     2016-06-14:12:55:18
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1858958    2016-06-14:12:53:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     2016-06-14:12:55:44
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1858949    2016-06-14:12:53:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     2016-06-14:12:55:59
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 2016-06-14:12:53:51

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     2016-06-14:12:56:02
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1858955    2016-06-14:12:53:51 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     2016-06-14:12:56:18
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1858952    2016-06-14:12:53:50 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
126     Incr 0  128.00K    SBT_TAPE    00:00:24     2016-06-15:13:02:08
        BP Key: 126   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4fr8735o_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
127     Incr 0  602.69M    SBT_TAPE    00:01:06     2016-06-15:13:02:49
        BP Key: 127   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 49r8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 127
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1860003    2016-06-15:13:01:43 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
128     Incr 0  1.13M      SBT_TAPE    00:01:21     2016-06-15:13:03:04
        BP Key: 128   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4dr8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 128
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1860015    2016-06-15:13:01:44 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
129     Incr 0  14.94M     SBT_TAPE    00:01:26     2016-06-15:13:03:09
        BP Key: 129   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4cr8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 129
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1860012    2016-06-15:13:01:44 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
130     Incr 0  9.63M      SBT_TAPE    00:01:40     2016-06-15:13:03:24
        BP Key: 130   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4er8735o_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1860013      Ckp time: 2016-06-15:13:01:44

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
131     Incr 0  510.00M    SBT_TAPE    00:02:09     2016-06-15:13:03:52
        BP Key: 131   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4ar8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 131
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1860006    2016-06-15:13:01:43 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
132     Incr 0  3.38M      SBT_TAPE    00:02:22     2016-06-15:13:04:05
        BP Key: 132   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4br8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 132
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1860009    2016-06-15:13:01:44 +DATA/orcl/datafile/undotbs1.258.816169553

RMAN> exit


Recovery Manager complete.
[oracle@station90 ~]$ exit
logout
[root@station90 ~]# date
Thu Jun 16 00:01:50 CST 2016
[root@station90 ~]# date -s "Thu Jun 16 13:01:08 CST 2016"
Thu Jun 16 13:01:08 CST 2016
[root@station90 ~]# date
Thu Jun 16 13:01:09 CST 2016
[root@station90 ~]# su - orace
su: user orace does not exist
[root@station90 ~]# su - oracle
[oracle@station90 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 16 13:01:18 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1343950367)

RMAN> report obsolete;

using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           126    2016-06-15:13:02:08
  Backup Piece       126    2016-06-15:13:02:08 4fr8735o_1_1

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
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; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           120    2016-06-14:12:55:00
  Backup Piece       120    2016-06-14:12:55:00 42r84eau_1_1
Backup Set           122    2016-06-14:12:55:44
  Backup Piece       122    2016-06-14:12:55:44 43r84eau_1_1
Backup Set           125    2016-06-14:12:56:18
  Backup Piece       125    2016-06-14:12:56:18 44r84eau_1_1
Backup Set           124    2016-06-14:12:56:02
  Backup Piece       124    2016-06-14:12:56:02 45r84eau_1_1
Backup Set           121    2016-06-14:12:55:18
  Backup Piece       121    2016-06-14:12:55:18 46r84eau_1_1
Backup Set           123    2016-06-14:12:55:59
  Backup Piece       123    2016-06-14:12:55:59 47r84eav_1_1
Backup Set           119    2016-06-14:12:54:16
  Backup Piece       119    2016-06-14:12:54:16 48r84eav_1_1

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> exit


Recovery Manager complete.
[oracle@station90 ~]$ exit
logout
[root@station90 ~]# date
Thu Jun 16 13:03:29 CST 2016
[root@station90 ~]# date -s "Thu Jun 16 23:59:00 CST 2016"
Thu Jun 16 23:59:00 CST 2016
[root@station90 ~]# su - oracle
[oracle@station90 ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 16 23:59:06 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1343950367)

RMAN> report need backup;

using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------

RMAN> report need backup;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 1 days
Report of files that must be backed up to satisfy 1 days recovery window
File Days  Name
---- ----- -----------------------------------------------------
1    2     +DATA/orcl/datafile/system.256.914102913
2    2     +DATA/orcl/datafile/sysaux.257.816169553
3    2     +DATA/orcl/datafile/undotbs1.258.816169553
4    2     +DATA/orcl/datafile/users.259.914101365
5    2     +DATA/orcl/datafile/example.265.816169651

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
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; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

RMAN> backup tag '3T_WHOLE_INCR0' incremental level 0  database ;

Starting backup at 2016-06-17:00:04:46
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=78 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=202 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: SID=79 device type=SBT_TAPE
channel ORA_SBT_TAPE_3: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: SID=141 device type=SBT_TAPE
channel ORA_SBT_TAPE_4: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_5
channel ORA_SBT_TAPE_5: SID=201 device type=SBT_TAPE
channel ORA_SBT_TAPE_5: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_6
channel ORA_SBT_TAPE_6: SID=203 device type=SBT_TAPE
channel ORA_SBT_TAPE_6: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_7
channel ORA_SBT_TAPE_7: SID=18 device type=SBT_TAPE
channel ORA_SBT_TAPE_7: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_8
channel ORA_SBT_TAPE_8: SID=75 device type=SBT_TAPE
channel ORA_SBT_TAPE_8: Oracle Secure Backup
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-17:00:04:50
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-17:00:04:50
channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-17:00:04:50
channel ORA_SBT_TAPE_4: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
channel ORA_SBT_TAPE_4: starting piece 1 at 2016-06-17:00:04:50
channel ORA_SBT_TAPE_5: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_5: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
channel ORA_SBT_TAPE_5: starting piece 1 at 2016-06-17:00:04:50
channel ORA_SBT_TAPE_6: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_6: specifying datafile(s) in backup set
channel ORA_SBT_TAPE_7: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_7: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_SBT_TAPE_7: starting piece 1 at 2016-06-17:00:04:51
including current control file in backup set
channel ORA_SBT_TAPE_6: starting piece 1 at 2016-06-17:00:04:52
channel ORA_SBT_TAPE_7: finished piece 1 at 2016-06-17:00:05:17
piece handle=4mr8aud3_1_1 tag=3T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_7: backup set complete, elapsed time: 00:00:26
channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-17:00:05:47
piece handle=4gr8aud2_1_1 tag=3T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:57
channel ORA_SBT_TAPE_4: finished piece 1 at 2016-06-17:00:06:07
piece handle=4jr8aud2_1_1 tag=3T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:01:17
channel ORA_SBT_TAPE_6: finished piece 1 at 2016-06-17:00:06:07
piece handle=4lr8aud3_1_1 tag=3T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:01:15
channel ORA_SBT_TAPE_5: finished piece 1 at 2016-06-17:00:06:27
piece handle=4kr8aud2_1_1 tag=3T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:01:37
channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-17:00:06:57
piece handle=4hr8aud2_1_1 tag=3T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:02:07
channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-17:00:07:17
piece handle=4ir8aud2_1_1 tag=3T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:02:27
Finished backup at 2016-06-17:00:07:17

RMAN> list backup ;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     2016-06-14:12:54:16
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     2016-06-14:12:55:00
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1858946    2016-06-14:12:53:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     2016-06-14:12:55:18
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1858958    2016-06-14:12:53:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     2016-06-14:12:55:44
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1858949    2016-06-14:12:53:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     2016-06-14:12:55:59
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 2016-06-14:12:53:51

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     2016-06-14:12:56:02
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1858955    2016-06-14:12:53:51 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     2016-06-14:12:56:18
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1858952    2016-06-14:12:53:50 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
126     Incr 0  128.00K    SBT_TAPE    00:00:24     2016-06-15:13:02:08
        BP Key: 126   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4fr8735o_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
127     Incr 0  602.69M    SBT_TAPE    00:01:06     2016-06-15:13:02:49
        BP Key: 127   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 49r8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 127
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1860003    2016-06-15:13:01:43 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
128     Incr 0  1.13M      SBT_TAPE    00:01:21     2016-06-15:13:03:04
        BP Key: 128   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4dr8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 128
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1860015    2016-06-15:13:01:44 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
129     Incr 0  14.94M     SBT_TAPE    00:01:26     2016-06-15:13:03:09
        BP Key: 129   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4cr8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 129
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1860012    2016-06-15:13:01:44 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
130     Incr 0  9.63M      SBT_TAPE    00:01:40     2016-06-15:13:03:24
        BP Key: 130   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4er8735o_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1860013      Ckp time: 2016-06-15:13:01:44

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
131     Incr 0  510.00M    SBT_TAPE    00:02:09     2016-06-15:13:03:52
        BP Key: 131   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4ar8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 131
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1860006    2016-06-15:13:01:43 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
132     Incr 0  3.38M      SBT_TAPE    00:02:22     2016-06-15:13:04:05
        BP Key: 132   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4br8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 132
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1860009    2016-06-15:13:01:44 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
133     Incr 0  128.00K    SBT_TAPE    00:00:24     2016-06-17:00:05:15
        BP Key: 133   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4mr8aud3_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
134     Incr 0  603.19M    SBT_TAPE    00:00:54     2016-06-17:00:05:44
        BP Key: 134   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4gr8aud2_1_1   Media: station90-000015
  List of Datafiles in backup set 134
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1900632    2016-06-17:00:04:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
135     Incr 0  14.94M     SBT_TAPE    00:01:09     2016-06-17:00:05:59
        BP Key: 135   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4jr8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 135
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1900584    2016-06-17:00:04:06 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
136     Incr 0  9.63M      SBT_TAPE    00:01:12     2016-06-17:00:06:03
        BP Key: 136   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4lr8aud3_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1900639      Ckp time: 2016-06-17:00:04:50

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
137     Incr 0  1.13M      SBT_TAPE    00:01:27     2016-06-17:00:06:17
        BP Key: 137   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4kr8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 137
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1900641    2016-06-17:00:04:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
138     Incr 0  512.94M    SBT_TAPE    00:02:01     2016-06-17:00:06:51
        BP Key: 138   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4hr8aud2_1_1   Media: station90-000015
  List of Datafiles in backup set 138
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1900635    2016-06-17:00:04:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
139     Incr 0  53.00M     SBT_TAPE    00:02:18     2016-06-17:00:07:08
        BP Key: 139   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4ir8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 139
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1900638    2016-06-17:00:04:50 +DATA/orcl/datafile/undotbs1.258.816169553

RMAN> backup tag '4T_WHOLE_INCR0' incremental level 0  database ;

Starting backup at 2016-06-17:00:08:42
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_SBT_TAPE_3
using channel ORA_SBT_TAPE_4
using channel ORA_SBT_TAPE_5
using channel ORA_SBT_TAPE_6
using channel ORA_SBT_TAPE_7
using channel ORA_SBT_TAPE_8
skipping datafile 5; already backed up 1 time(s)
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-17:00:08:42
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-17:00:08:42
channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-17:00:08:42
channel ORA_SBT_TAPE_4: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
channel ORA_SBT_TAPE_4: starting piece 1 at 2016-06-17:00:08:43
channel ORA_SBT_TAPE_5: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_5: specifying datafile(s) in backup set
channel ORA_SBT_TAPE_6: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_6: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_SBT_TAPE_6: starting piece 1 at 2016-06-17:00:08:43
including current control file in backup set
channel ORA_SBT_TAPE_5: starting piece 1 at 2016-06-17:00:08:44
channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-17:00:09:29
piece handle=4or8auka_1_1 tag=4T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:47
channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-17:00:09:39
piece handle=4nr8auka_1_1 tag=4T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:57
channel ORA_SBT_TAPE_4: finished piece 1 at 2016-06-17:00:09:59
piece handle=4qr8auka_1_1 tag=4T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:01:16
channel ORA_SBT_TAPE_6: finished piece 1 at 2016-06-17:00:10:09
piece handle=4sr8aukb_1_1 tag=4T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:01:26
channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-17:00:10:29
piece handle=4pr8auka_1_1 tag=4T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:01:47
channel ORA_SBT_TAPE_5: finished piece 1 at 2016-06-17:00:10:29
piece handle=4rr8aukb_1_1 tag=4T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:01:45
Finished backup at 2016-06-17:00:10:29

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     2016-06-14:12:54:16
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     2016-06-14:12:55:00
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1858946    2016-06-14:12:53:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     2016-06-14:12:55:18
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1858958    2016-06-14:12:53:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     2016-06-14:12:55:44
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1858949    2016-06-14:12:53:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     2016-06-14:12:55:59
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 2016-06-14:12:53:51

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     2016-06-14:12:56:02
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1858955    2016-06-14:12:53:51 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     2016-06-14:12:56:18
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1858952    2016-06-14:12:53:50 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
126     Incr 0  128.00K    SBT_TAPE    00:00:24     2016-06-15:13:02:08
        BP Key: 126   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4fr8735o_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
127     Incr 0  602.69M    SBT_TAPE    00:01:06     2016-06-15:13:02:49
        BP Key: 127   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 49r8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 127
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1860003    2016-06-15:13:01:43 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
128     Incr 0  1.13M      SBT_TAPE    00:01:21     2016-06-15:13:03:04
        BP Key: 128   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4dr8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 128
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1860015    2016-06-15:13:01:44 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
129     Incr 0  14.94M     SBT_TAPE    00:01:26     2016-06-15:13:03:09
        BP Key: 129   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4cr8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 129
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1860012    2016-06-15:13:01:44 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
130     Incr 0  9.63M      SBT_TAPE    00:01:40     2016-06-15:13:03:24
        BP Key: 130   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4er8735o_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1860013      Ckp time: 2016-06-15:13:01:44

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
131     Incr 0  510.00M    SBT_TAPE    00:02:09     2016-06-15:13:03:52
        BP Key: 131   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4ar8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 131
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1860006    2016-06-15:13:01:43 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
132     Incr 0  3.38M      SBT_TAPE    00:02:22     2016-06-15:13:04:05
        BP Key: 132   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4br8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 132
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1860009    2016-06-15:13:01:44 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
133     Incr 0  128.00K    SBT_TAPE    00:00:24     2016-06-17:00:05:15
        BP Key: 133   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4mr8aud3_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
134     Incr 0  603.19M    SBT_TAPE    00:00:54     2016-06-17:00:05:44
        BP Key: 134   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4gr8aud2_1_1   Media: station90-000015
  List of Datafiles in backup set 134
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1900632    2016-06-17:00:04:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
135     Incr 0  14.94M     SBT_TAPE    00:01:09     2016-06-17:00:05:59
        BP Key: 135   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4jr8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 135
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1900584    2016-06-17:00:04:06 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
136     Incr 0  9.63M      SBT_TAPE    00:01:12     2016-06-17:00:06:03
        BP Key: 136   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4lr8aud3_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1900639      Ckp time: 2016-06-17:00:04:50

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
137     Incr 0  1.13M      SBT_TAPE    00:01:27     2016-06-17:00:06:17
        BP Key: 137   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4kr8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 137
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1900641    2016-06-17:00:04:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
138     Incr 0  512.94M    SBT_TAPE    00:02:01     2016-06-17:00:06:51
        BP Key: 138   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4hr8aud2_1_1   Media: station90-000015
  List of Datafiles in backup set 138
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1900635    2016-06-17:00:04:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
139     Incr 0  53.00M     SBT_TAPE    00:02:18     2016-06-17:00:07:08
        BP Key: 139   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4ir8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 139
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1900638    2016-06-17:00:04:50 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
140     Incr 0  512.94M    SBT_TAPE    00:00:45     2016-06-17:00:09:27
        BP Key: 140   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4or8auka_1_1   Media: station90-000016
  List of Datafiles in backup set 140
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1900779    2016-06-17:00:08:42 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
141     Incr 0  603.19M    SBT_TAPE    00:00:56     2016-06-17:00:09:38
        BP Key: 141   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4nr8auka_1_1   Media: station90-000015
  List of Datafiles in backup set 141
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1900776    2016-06-17:00:08:42 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
142     Incr 0  1.13M      SBT_TAPE    00:01:13     2016-06-17:00:09:55
        BP Key: 142   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4qr8auka_1_1   Media: station90-000015
  List of Datafiles in backup set 142
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1900785    2016-06-17:00:08:43 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
143     Incr 0  128.00K    SBT_TAPE    00:01:20     2016-06-17:00:10:03
        BP Key: 143   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4sr8aukb_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
144     Incr 0  53.00M     SBT_TAPE    00:01:39     2016-06-17:00:10:21
        BP Key: 144   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4pr8auka_1_1   Media: station90-000015
  List of Datafiles in backup set 144
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1900782    2016-06-17:00:08:43 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
145     Incr 0  9.63M      SBT_TAPE    00:01:40     2016-06-17:00:10:23
        BP Key: 145   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4rr8aukb_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1900784      Ckp time: 2016-06-17:00:08:43

RMAN> exit


Recovery Manager complete.
[oracle@station90 ~]$ exit
logout
[root@station90 ~]# date
Fri Jun 17 00:15:33 CST 2016
[root@station90 ~]# date -s "Fri Jun 17 23:59:00 CST 2016"
Fri Jun 17 23:59:00 CST 2016
[root@station90 ~]# date
Fri Jun 17 23:59:02 CST 2016
[root@station90 ~]# su - oracle
[oracle@station90 ~]$ rman target /  

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Jun 17 23:59:07 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1343950367)

RMAN> backup tag '5T_WHOLE_INCR0' incremental level 0  database ;

Starting backup at 2016-06-17:23:59:14
using target database control file instead of recovery catalog
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=201 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=18 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: SID=82 device type=SBT_TAPE
channel ORA_SBT_TAPE_3: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: SID=142 device type=SBT_TAPE
channel ORA_SBT_TAPE_4: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_5
channel ORA_SBT_TAPE_5: SID=202 device type=SBT_TAPE
channel ORA_SBT_TAPE_5: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_6
channel ORA_SBT_TAPE_6: SID=8 device type=SBT_TAPE
channel ORA_SBT_TAPE_6: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_7
channel ORA_SBT_TAPE_7: SID=80 device type=SBT_TAPE
channel ORA_SBT_TAPE_7: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_8
channel ORA_SBT_TAPE_8: SID=144 device type=SBT_TAPE
channel ORA_SBT_TAPE_8: Oracle Secure Backup
skipping datafile 5; already backed up 1 time(s)
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-17:23:59:18
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-17:23:59:18
channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-17:23:59:18
channel ORA_SBT_TAPE_4: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
channel ORA_SBT_TAPE_4: starting piece 1 at 2016-06-17:23:59:18
channel ORA_SBT_TAPE_5: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_5: specifying datafile(s) in backup set
channel ORA_SBT_TAPE_6: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_6: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_SBT_TAPE_6: starting piece 1 at 2016-06-17:23:59:19
including current control file in backup set
channel ORA_SBT_TAPE_5: starting piece 1 at 2016-06-17:23:59:20
channel ORA_SBT_TAPE_5: finished piece 1 at 2016-06-17:23:59:45
piece handle=51r8diem_1_1 tag=5T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_6: finished piece 1 at 2016-06-17:23:59:45
piece handle=52r8dien_1_1 tag=5T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:00:26
channel ORA_SBT_TAPE_4: finished piece 1 at 2016-06-18:00:00:05
piece handle=50r8diem_1_1 tag=5T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:00:47
channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-18:00:00:25
piece handle=4ur8diem_1_1 tag=5T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:07
channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-18:00:00:55
piece handle=4vr8diem_1_1 tag=5T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:01:37
channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-18:00:01:25
piece handle=4tr8diem_1_1 tag=5T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:02:07
Finished backup at 2016-06-18:00:01:25

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
119     Incr 0  128.00K    SBT_TAPE    00:00:25     2016-06-14:12:54:16
        BP Key: 119   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 48r84eav_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
120     Incr 0  602.75M    SBT_TAPE    00:01:10     2016-06-14:12:55:00
        BP Key: 120   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 42r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 120
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1858946    2016-06-14:12:53:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
121     Incr 0  1.13M      SBT_TAPE    00:01:28     2016-06-14:12:55:18
        BP Key: 121   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 46r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 121
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1858958    2016-06-14:12:53:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
122     Incr 0  510.00M    SBT_TAPE    00:01:54     2016-06-14:12:55:44
        BP Key: 122   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 43r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 122
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1858949    2016-06-14:12:53:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
123     Incr 0  9.63M      SBT_TAPE    00:02:08     2016-06-14:12:55:59
        BP Key: 123   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 47r84eav_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1858959      Ckp time: 2016-06-14:12:53:51

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
124     Incr 0  14.94M     SBT_TAPE    00:02:12     2016-06-14:12:56:02
        BP Key: 124   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 45r84eau_1_1   Media: station90-000016
  List of Datafiles in backup set 124
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1858955    2016-06-14:12:53:51 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
125     Incr 0  4.75M      SBT_TAPE    00:02:28     2016-06-14:12:56:18
        BP Key: 125   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
        Handle: 44r84eau_1_1   Media: station90-000015
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1858952    2016-06-14:12:53:50 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
126     Incr 0  128.00K    SBT_TAPE    00:00:24     2016-06-15:13:02:08
        BP Key: 126   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4fr8735o_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
127     Incr 0  602.69M    SBT_TAPE    00:01:06     2016-06-15:13:02:49
        BP Key: 127   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 49r8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 127
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1860003    2016-06-15:13:01:43 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
128     Incr 0  1.13M      SBT_TAPE    00:01:21     2016-06-15:13:03:04
        BP Key: 128   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4dr8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 128
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1860015    2016-06-15:13:01:44 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
129     Incr 0  14.94M     SBT_TAPE    00:01:26     2016-06-15:13:03:09
        BP Key: 129   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4cr8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 129
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1860012    2016-06-15:13:01:44 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
130     Incr 0  9.63M      SBT_TAPE    00:01:40     2016-06-15:13:03:24
        BP Key: 130   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4er8735o_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1860013      Ckp time: 2016-06-15:13:01:44

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
131     Incr 0  510.00M    SBT_TAPE    00:02:09     2016-06-15:13:03:52
        BP Key: 131   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4ar8735n_1_1   Media: station90-000015
  List of Datafiles in backup set 131
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1860006    2016-06-15:13:01:43 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
132     Incr 0  3.38M      SBT_TAPE    00:02:22     2016-06-15:13:04:05
        BP Key: 132   Status: AVAILABLE  Compressed: NO  Tag: 2T_WHOLE_INCR0
        Handle: 4br8735n_1_1   Media: station90-000016
  List of Datafiles in backup set 132
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1860009    2016-06-15:13:01:44 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
133     Incr 0  128.00K    SBT_TAPE    00:00:24     2016-06-17:00:05:15
        BP Key: 133   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4mr8aud3_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
134     Incr 0  603.19M    SBT_TAPE    00:00:54     2016-06-17:00:05:44
        BP Key: 134   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4gr8aud2_1_1   Media: station90-000015
  List of Datafiles in backup set 134
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1900632    2016-06-17:00:04:50 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
135     Incr 0  14.94M     SBT_TAPE    00:01:09     2016-06-17:00:05:59
        BP Key: 135   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4jr8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 135
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  5    0  Incr 1900584    2016-06-17:00:04:06 +DATA/orcl/datafile/example.265.816169651

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
136     Incr 0  9.63M      SBT_TAPE    00:01:12     2016-06-17:00:06:03
        BP Key: 136   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4lr8aud3_1_1   Media: station90-000015
  Control File Included: Ckp SCN: 1900639      Ckp time: 2016-06-17:00:04:50

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
137     Incr 0  1.13M      SBT_TAPE    00:01:27     2016-06-17:00:06:17
        BP Key: 137   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4kr8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 137
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1900641    2016-06-17:00:04:51 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
138     Incr 0  512.94M    SBT_TAPE    00:02:01     2016-06-17:00:06:51
        BP Key: 138   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4hr8aud2_1_1   Media: station90-000015
  List of Datafiles in backup set 138
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1900635    2016-06-17:00:04:50 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
139     Incr 0  53.00M     SBT_TAPE    00:02:18     2016-06-17:00:07:08
        BP Key: 139   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_INCR0
        Handle: 4ir8aud2_1_1   Media: station90-000016
  List of Datafiles in backup set 139
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1900638    2016-06-17:00:04:50 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
140     Incr 0  512.94M    SBT_TAPE    00:00:45     2016-06-17:00:09:27
        BP Key: 140   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4or8auka_1_1   Media: station90-000016
  List of Datafiles in backup set 140
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1900779    2016-06-17:00:08:42 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
141     Incr 0  603.19M    SBT_TAPE    00:00:56     2016-06-17:00:09:38
        BP Key: 141   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4nr8auka_1_1   Media: station90-000015
  List of Datafiles in backup set 141
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1900776    2016-06-17:00:08:42 +DATA/orcl/datafile/system.256.914102913

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
142     Incr 0  1.13M      SBT_TAPE    00:01:13     2016-06-17:00:09:55
        BP Key: 142   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4qr8auka_1_1   Media: station90-000015
  List of Datafiles in backup set 142
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1900785    2016-06-17:00:08:43 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
143     Incr 0  128.00K    SBT_TAPE    00:01:20     2016-06-17:00:10:03
        BP Key: 143   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4sr8aukb_1_1   Media: station90-000016
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
144     Incr 0  53.00M     SBT_TAPE    00:01:39     2016-06-17:00:10:21
        BP Key: 144   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4pr8auka_1_1   Media: station90-000015
  List of Datafiles in backup set 144
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1900782    2016-06-17:00:08:43 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
145     Incr 0  9.63M      SBT_TAPE    00:01:40     2016-06-17:00:10:23
        BP Key: 145   Status: AVAILABLE  Compressed: NO  Tag: 4T_WHOLE_INCR0
        Handle: 4rr8aukb_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1900784      Ckp time: 2016-06-17:00:08:43

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
146     Incr 0  128.00K    SBT_TAPE    00:00:23     2016-06-17:23:59:42
        BP Key: 146   Status: AVAILABLE  Compressed: NO  Tag: 5T_WHOLE_INCR0
        Handle: 52r8dien_1_1   Media: station90-000015
  SPFILE Included: Modification time: 2016-06-14:12:28:36
  SPFILE db_unique_name: ORCL

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
147     Incr 0  9.63M      SBT_TAPE    00:00:26     2016-06-17:23:59:44
        BP Key: 147   Status: AVAILABLE  Compressed: NO  Tag: 5T_WHOLE_INCR0
        Handle: 51r8diem_1_1   Media: station90-000016
  Control File Included: Ckp SCN: 1904473      Ckp time: 2016-06-17:23:59:19

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
148     Incr 0  1.13M      SBT_TAPE    00:00:43     2016-06-18:00:00:01
        BP Key: 148   Status: AVAILABLE  Compressed: NO  Tag: 5T_WHOLE_INCR0
        Handle: 50r8diem_1_1   Media: station90-000015
  List of Datafiles in backup set 148
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  4    0  Incr 1904474    2016-06-17:23:59:19 +DATA/orcl/datafile/users.259.914101365

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
149     Incr 0  513.88M    SBT_TAPE    00:01:05     2016-06-18:00:00:23
        BP Key: 149   Status: AVAILABLE  Compressed: NO  Tag: 5T_WHOLE_INCR0
        Handle: 4ur8diem_1_1   Media: station90-000016
  List of Datafiles in backup set 149
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2    0  Incr 1904431    2016-06-17:23:59:18 +DATA/orcl/datafile/sysaux.257.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
150     Incr 0  56.06M     SBT_TAPE    00:01:27     2016-06-18:00:00:45
        BP Key: 150   Status: AVAILABLE  Compressed: NO  Tag: 5T_WHOLE_INCR0
        Handle: 4vr8diem_1_1   Media: station90-000016
  List of Datafiles in backup set 150
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  3    0  Incr 1904461    2016-06-17:23:59:19 +DATA/orcl/datafile/undotbs1.258.816169553

BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
151     Incr 0  603.19M    SBT_TAPE    00:02:05     2016-06-18:00:01:23
        BP Key: 151   Status: AVAILABLE  Compressed: NO  Tag: 5T_WHOLE_INCR0
        Handle: 4tr8diem_1_1   Media: station90-000015
  List of Datafiles in backup set 151
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1    0  Incr 1904425    2016-06-17:23:59:18 +DATA/orcl/datafile/system.256.914102913

RMAN> backup tag '6T_WHOLE_INCR0' incremental level 0  database ;

Starting backup at 2016-06-18:00:07:28
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_SBT_TAPE_3
using channel ORA_SBT_TAPE_4
using channel ORA_SBT_TAPE_5
using channel ORA_SBT_TAPE_6
using channel ORA_SBT_TAPE_7
using channel ORA_SBT_TAPE_8
channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-18:00:07:29
channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
channel ORA_SBT_TAPE_2: starting piece 1 at 2016-06-18:00:07:29
channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
channel ORA_SBT_TAPE_3: starting piece 1 at 2016-06-18:00:07:29
channel ORA_SBT_TAPE_4: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
channel ORA_SBT_TAPE_4: starting piece 1 at 2016-06-18:00:07:29
channel ORA_SBT_TAPE_5: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_5: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
channel ORA_SBT_TAPE_5: starting piece 1 at 2016-06-18:00:07:30
channel ORA_SBT_TAPE_6: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_6: specifying datafile(s) in backup set
channel ORA_SBT_TAPE_7: starting incremental level 0 datafile backup set
channel ORA_SBT_TAPE_7: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_SBT_TAPE_7: starting piece 1 at 2016-06-18:00:07:30
including current control file in backup set
channel ORA_SBT_TAPE_6: starting piece 1 at 2016-06-18:00:07:31
channel ORA_SBT_TAPE_2: finished piece 1 at 2016-06-18:00:08:16
piece handle=54r8diu1_1_1 tag=6T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:47
channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-18:00:08:26
piece handle=53r8diu1_1_1 tag=6T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:57
channel ORA_SBT_TAPE_3: finished piece 1 at 2016-06-18:00:08:46
piece handle=55r8diu1_1_1 tag=6T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:01:17
channel ORA_SBT_TAPE_4: finished piece 1 at 2016-06-18:00:08:46
piece handle=56r8diu1_1_1 tag=6T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:01:17
channel ORA_SBT_TAPE_5: finished piece 1 at 2016-06-18:00:09:06
piece handle=57r8diu2_1_1 tag=6T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:01:36
channel ORA_SBT_TAPE_6: finished piece 1 at 2016-06-18:00:09:06
piece handle=58r8diu2_1_1 tag=6T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:01:35
channel ORA_SBT_TAPE_7: finished piece 1 at 2016-06-18:00:09:27
piece handle=59r8diu2_1_1 tag=6T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
channel ORA_SBT_TAPE_7: backup set complete, elapsed time: 00:01:57
Finished backup at 2016-06-18:00:09:27

RMAN>

botang

1. RMAN> report obsolete;
   
2. 
   
3. RMAN retention policy will be applied to the command
   
4. RMAN retention policy is set to recovery window of 1 days
   
5. Report of obsolete backups and copies
   
6. Type                 Key    Completion Time    Filename/Handle
   
7. -------------------- ------ ------------------ --------------------
   
8. Archive Log          194    06-JUN-16          +FRA/orcl/archivelog/2016_06_06/thread_1_seq_27.271.913844171
   
9. Backup Set           75     06-JUN-16         
   
10.   Backup Piece       75     06-JUN-16          +FRA/orcl/autobackup/2016_06_06/s_913844166.270.913844167
    
11. Backup Set           76     06-JUN-16         
    
12.   Backup Piece       76     06-JUN-16          2nr7g9uc_1_1
    
13. Backup Set           77     06-JUN-16         
    
14.   Backup Piece       77     06-JUN-16          c-1343950367-20160606-03
    
15. Backup Set           78     07-JUN-16         
    
16.   Backup Piece       78     07-JUN-16          +FRA/orcl/backupset/2016_06_07/nnndn1_ora_oem_level_0_0.272.913930533
    
17. Backup Set           79     07-JUN-16         
    
18.   Backup Piece       79     07-JUN-16          +FRA/orcl/autobackup/2016_06_07/s_913930536.277.913930537
    
19. Backup Set           81     07-JUN-16         
    
20.   Backup Piece       81     07-JUN-16          c-1343950367-20160607-01
    
21. Datafile Copy        27     08-JUN-16          +FRA/orcl/datafile/system.268.913844129
    
22. Backup Set           83     08-JUN-16         
    
23.   Backup Piece       83     08-JUN-16          +FRA/orcl/autobackup/2016_06_08/s_914016939.280.914016941
    
24. Backup Set           85     08-JUN-16         
    
25.   Backup Piece       85     08-JUN-16          c-1343950367-20160608-01
    
26. Backup Set           87     09-JUN-16         
    
27.   Backup Piece       87     09-JUN-16          c-1343950367-20160609-00
    
28. Backup Set           89     09-JUN-16         
    
29.   Backup Piece       89     09-JUN-16          c-1343950367-20160609-01
    
30. Backup Set           90     09-JUN-16         
    
31.   Backup Piece       90     09-JUN-16          +FRA/orcl/autobackup/2016_06_09/s_914100616.313.914100617
    
32. 
    
33. RMAN> delete obsolete ;
    
34. 
    
35. RMAN retention policy will be applied to the command
    
36. RMAN retention policy is set to recovery window of 1 days
    
37. allocated channel: ORA_DISK_1
    
38. channel ORA_DISK_1: SID=130 device type=DISK
    
39. allocated channel: ORA_DISK_2
    
40. channel ORA_DISK_2: SID=198 device type=DISK
    
41. allocated channel: ORA_DISK_3
    
42. channel ORA_DISK_3: SID=199 device type=DISK
    
43. allocated channel: ORA_DISK_4
    
44. channel ORA_DISK_4: SID=13 device type=DISK
    
45. allocated channel: ORA_DISK_5
    
46. channel ORA_DISK_5: SID=192 device type=DISK
    
47. allocated channel: ORA_DISK_6
    
48. channel ORA_DISK_6: SID=10 device type=DISK
    
49. allocated channel: ORA_DISK_7
    
50. channel ORA_DISK_7: SID=75 device type=DISK
    
51. allocated channel: ORA_DISK_8
    
52. channel ORA_DISK_8: SID=140 device type=DISK
    
53. allocated channel: ORA_SBT_TAPE_1
    
54. channel ORA_SBT_TAPE_1: SID=193 device type=SBT_TAPE
    
55. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
56. allocated channel: ORA_SBT_TAPE_2
    
57. channel ORA_SBT_TAPE_2: SID=11 device type=SBT_TAPE
    
58. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
59. allocated channel: ORA_SBT_TAPE_3
    
60. channel ORA_SBT_TAPE_3: SID=74 device type=SBT_TAPE
    
61. channel ORA_SBT_TAPE_3: Oracle Secure Backup
    
62. allocated channel: ORA_SBT_TAPE_4
    
63. channel ORA_SBT_TAPE_4: SID=141 device type=SBT_TAPE
    
64. channel ORA_SBT_TAPE_4: Oracle Secure Backup
    
65. allocated channel: ORA_SBT_TAPE_5
    
66. channel ORA_SBT_TAPE_5: SID=191 device type=SBT_TAPE
    
67. channel ORA_SBT_TAPE_5: Oracle Secure Backup
    
68. allocated channel: ORA_SBT_TAPE_6
    
69. channel ORA_SBT_TAPE_6: SID=9 device type=SBT_TAPE
    
70. channel ORA_SBT_TAPE_6: Oracle Secure Backup
    
71. allocated channel: ORA_SBT_TAPE_7
    
72. channel ORA_SBT_TAPE_7: SID=71 device type=SBT_TAPE
    
73. channel ORA_SBT_TAPE_7: Oracle Secure Backup
    
74. allocated channel: ORA_SBT_TAPE_8
    
75. channel ORA_SBT_TAPE_8: SID=136 device type=SBT_TAPE
    
76. channel ORA_SBT_TAPE_8: Oracle Secure Backup
    
77. Deleting the following obsolete backups and copies:
    
78. Type                 Key    Completion Time    Filename/Handle
    
79. -------------------- ------ ------------------ --------------------
    
80. Archive Log          194    06-JUN-16          +FRA/orcl/archivelog/2016_06_06/thread_1_seq_27.271.913844171
    
81. Backup Set           75     06-JUN-16         
    
82.   Backup Piece       75     06-JUN-16          +FRA/orcl/autobackup/2016_06_06/s_913844166.270.913844167
    
83. Backup Set           76     06-JUN-16         
    
84.   Backup Piece       76     06-JUN-16          2nr7g9uc_1_1
    
85. Backup Set           77     06-JUN-16         
    
86.   Backup Piece       77     06-JUN-16          c-1343950367-20160606-03
    
87. Backup Set           78     07-JUN-16         
    
88.   Backup Piece       78     07-JUN-16          +FRA/orcl/backupset/2016_06_07/nnndn1_ora_oem_level_0_0.272.913930533
    
89. Backup Set           79     07-JUN-16         
    
90.   Backup Piece       79     07-JUN-16          +FRA/orcl/autobackup/2016_06_07/s_913930536.277.913930537
    
91. Backup Set           81     07-JUN-16         
    
92.   Backup Piece       81     07-JUN-16          c-1343950367-20160607-01
    
93. Datafile Copy        27     08-JUN-16          +FRA/orcl/datafile/system.268.913844129
    
94. Backup Set           83     08-JUN-16         
    
95.   Backup Piece       83     08-JUN-16          +FRA/orcl/autobackup/2016_06_08/s_914016939.280.914016941
    
96. Backup Set           85     08-JUN-16         
    
97.   Backup Piece       85     08-JUN-16          c-1343950367-20160608-01
    
98. Backup Set           87     09-JUN-16         
    
99.   Backup Piece       87     09-JUN-16          c-1343950367-20160609-00
    
100. Backup Set           89     09-JUN-16         
     
101.   Backup Piece       89     09-JUN-16          c-1343950367-20160609-01
     
102. Backup Set           90     09-JUN-16         
     
103.   Backup Piece       90     09-JUN-16          +FRA/orcl/autobackup/2016_06_09/s_914100616.313.914100617
     
104. 
     
105. Do you really want to delete the above objects (enter YES or NO)? YES
     
106. deleted archived log
     
107. archived log file name=+FRA/orcl/archivelog/2016_06_06/thread_1_seq_27.271.913844171 RECID=194 STAMP=913844171
     
108. deleted backup piece
     
109. backup piece handle=+FRA/orcl/autobackup/2016_06_06/s_913844166.270.913844167 RECID=75 STAMP=913844166
     
110. deleted backup piece
     
111. backup piece handle=+FRA/orcl/backupset/2016_06_07/nnndn1_ora_oem_level_0_0.272.913930533 RECID=78 STAMP=913930533
     
112. deleted backup piece
     
113. backup piece handle=+FRA/orcl/autobackup/2016_06_07/s_913930536.277.913930537 RECID=79 STAMP=913930537
     
114. deleted backup piece
     
115. backup piece handle=+FRA/orcl/autobackup/2016_06_08/s_914016939.280.914016941 RECID=83 STAMP=914016939
     
116. deleted backup piece
     
117. backup piece handle=+FRA/orcl/autobackup/2016_06_09/s_914100616.313.914100617 RECID=90 STAMP=914100616
     
118. Deleted 6 objects
     
119. 
     
120. 
     
121. RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
     
122. RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
     
123. RMAN-06210: List of Mismatched objects
     
124. RMAN-06211: ==========================
     
125. RMAN-06212:   Object Type   Filename/Handle
     
126. RMAN-06213: --------------- ---------------------------------------------------
     
127. RMAN-06214: Datafile Copy   +FRA/orcl/datafile/system.268.913844129
     
128. 
     
129. deleted backup piece
     
130. backup piece handle=2nr7g9uc_1_1 RECID=76 STAMP=913844172
     
131. deleted backup piece
     
132. backup piece handle=c-1343950367-20160606-03 RECID=77 STAMP=913844197
     
133. deleted backup piece
     
134. backup piece handle=c-1343950367-20160607-01 RECID=81 STAMP=913930569
     
135. deleted backup piece
     
136. backup piece handle=c-1343950367-20160608-01 RECID=85 STAMP=914016972
     
137. deleted backup piece
     
138. backup piece handle=c-1343950367-20160609-00 RECID=87 STAMP=914098783
     
139. deleted backup piece
     
140. backup piece handle=c-1343950367-20160609-01 RECID=89 STAMP=914098916
     
141. Deleted 6 objects
     
142. 
     
143. 
     
144. RMAN> run {
     
145. 2> backup tag '1T_USERS_INCR0'  incremental level 0  tablespace users ;
     
146. 3> }
     
147. 
     
148. Starting backup at 14-JUN-16
     
149. released channel: ORA_DISK_1
     
150. released channel: ORA_DISK_2
     
151. released channel: ORA_DISK_3
     
152. released channel: ORA_DISK_4
     
153. released channel: ORA_DISK_5
     
154. released channel: ORA_DISK_6
     
155. released channel: ORA_DISK_7
     
156. released channel: ORA_DISK_8
     
157. using channel ORA_SBT_TAPE_1
     
158. using channel ORA_SBT_TAPE_2
     
159. using channel ORA_SBT_TAPE_3
     
160. using channel ORA_SBT_TAPE_4
     
161. using channel ORA_SBT_TAPE_5
     
162. using channel ORA_SBT_TAPE_6
     
163. using channel ORA_SBT_TAPE_7
     
164. using channel ORA_SBT_TAPE_8
     
165. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
     
166. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
167. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
     
168. channel ORA_SBT_TAPE_1: starting piece 1 at 14-JUN-16
     
169. channel ORA_SBT_TAPE_1: finished piece 1 at 14-JUN-16
     
170. piece handle=37r84aog_1_1 tag=1T_USERS_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
     
171. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:50
     
172. Finished backup at 14-JUN-16
     
173. 
     
174. Starting Control File and SPFILE Autobackup at 14-JUN-16
     
175. piece handle=c-1343950367-20160614-00 comment=API Version 2.0,MMS Version 10.3.0.2
     
176. Finished Control File and SPFILE Autobackup at 14-JUN-16
     
177. 
     
178. RMAN> list backup;
     
179. 
     
180. 
     
181. List of Backup Sets
     
182. ===================
     
183. 
     
184. 
     
185. BS Key  Size       Device Type Elapsed Time Completion Time
     
186. ------- ---------- ----------- ------------ ---------------
     
187. 80      16.63M     SBT_TAPE    00:00:24     07-JUN-16      
     
188.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213543
     
189.         Handle: 2rr7iu9g_1_1   Media: station90-000013
     
190. 
     
191.   List of Archived Logs in backup set 80
     
192.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
193.   ---- ------- ---------- --------- ---------- ---------
     
194.   1    28      1544415    06-JUN-16 1547833    07-JUN-16
     
195. 
     
196. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
197. ------- ---- -- ---------- ----------- ------------ ---------------
     
198. 82      Incr 1  16.52M     DISK        00:00:03     08-JUN-16      
     
199.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
     
200.         Piece Name: +FRA/orcl/backupset/2016_06_08/nnndn1_ora_oem_level_0_0.279.914016939
     
201.   List of Datafiles in backup set 82
     
202.   File LV Type Ckp SCN    Ckp Time  Name
     
203.   ---- -- ---- ---------- --------- ----
     
204.   1    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/system.256.914102913
     
205.   2    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553
     
206.   3    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553
     
207.   5    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/example.265.816169651
     
208. 
     
209. BS Key  Size       Device Type Elapsed Time Completion Time
     
210. ------- ---------- ----------- ------------ ---------------
     
211. 84      9.69M      SBT_TAPE    00:00:23     08-JUN-16      
     
212.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213546
     
213.         Handle: 2vr7lilj_1_1   Media: station90-000013
     
214. 
     
215.   List of Archived Logs in backup set 84
     
216.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
217.   ---- ------- ---------- --------- ---------- ---------
     
218.   1    29      1547833    07-JUN-16 1551061    08-JUN-16
     
219. 
     
220. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
221. ------- ---- -- ---------- ----------- ------------ ---------------
     
222. 86      Full    600.75M    SBT_TAPE    00:02:09     09-JUN-16      
     
223.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T201727
     
224.         Handle: 31r7o2en_1_1   Media: station90-000013
     
225.   List of Datafiles in backup set 86
     
226.   File LV Type Ckp SCN    Ckp Time  Name
     
227.   ---- -- ---- ---------- --------- ----
     
228.   1       Full 1577433    09-JUN-16 +DATA/orcl/datafile/system.256.914102913
     
229. 
     
230. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
231. ------- ---- -- ---------- ----------- ------------ ---------------
     
232. 88      Full    1.06M      SBT_TAPE    00:00:15     09-JUN-16      
     
233.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202130
     
234.         Handle: 33r7o2ma_1_1   Media: station90-000013
     
235.   List of Datafiles in backup set 88
     
236.   File LV Type Ckp SCN    Ckp Time  Name
     
237.   ---- -- ---- ---------- --------- ----
     
238.   4       Full 1577931    09-JUN-16 +DATA/orcl/datafile/users.259.914101365
     
239. 
     
240. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
241. ------- ---- -- ---------- ----------- ------------ ---------------
     
242. 91      Full    9.61M      DISK        00:00:00     09-JUN-16      
     
243.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T211017
     
244.         Piece Name: +FRA/orcl/autobackup/2016_06_09/s_914101817.298.914101817
     
245.   SPFILE Included: Modification time: 09-JUN-16
     
246.   SPFILE db_unique_name: ORCL
     
247.   Control File Included: Ckp SCN: 1581203      Ckp time: 09-JUN-16
     
248. 
     
249. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
250. ------- ---- -- ---------- ----------- ------------ ---------------
     
251. 92      Incr 0  1.13M      SBT_TAPE    00:00:43     14-JUN-16      
     
252.         BP Key: 92   Status: AVAILABLE  Compressed: NO  Tag: 1T_USERS_INCR0
     
253.         Handle: 37r84aog_1_1   Media: station90-000013
     
254.   List of Datafiles in backup set 92
     
255.   File LV Type Ckp SCN    Ckp Time  Name
     
256.   ---- -- ---- ---------- --------- ----
     
257.   4    0  Incr 1835474    14-JUN-16 +DATA/orcl/datafile/users.259.914101365
     
258. 
     
259. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
260. ------- ---- -- ---------- ----------- ------------ ---------------
     
261. 93      Full    9.63M      SBT_TAPE    00:00:16     14-JUN-16      
     
262.         BP Key: 93   Status: AVAILABLE  Compressed: NO  Tag: TAG20160614T115338
     
263.         Handle: c-1343950367-20160614-00   Media: station90-000013
     
264.   SPFILE Included: Modification time: 14-JUN-16
     
265.   SPFILE db_unique_name: ORCL
     
266.   Control File Included: Ckp SCN: 1835515      Ckp time: 14-JUN-16
     
267. 
     
268. RMAN> show all;
     
269. 
     
270. RMAN configuration parameters for database with db_unique_name ORCL are:
     
271. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
     
272. CONFIGURE BACKUP OPTIMIZATION ON;
     
273. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
     
274. CONFIGURE CONTROLFILE AUTOBACKUP ON;
     
275. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
     
276. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
     
277. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
     
278. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
     
279. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
280. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
281. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
282. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
283. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
284. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
285. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
286. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
287. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
288. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
289. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
290. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
291. CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
292. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
     
293. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
     
294. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
     
295. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
     
296. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
     
297. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
     
298. 
     
299. RMAN> CONFIGURE CONTROLFILE AUTOBACKUP
     
300. 2>  off;
     
301. 
     
302. old RMAN configuration parameters:
     
303. CONFIGURE CONTROLFILE AUTOBACKUP ON;
     
304. new RMAN configuration parameters:
     
305. CONFIGURE CONTROLFILE AUTOBACKUP OFF;
     
306. new RMAN configuration parameters are successfully stored
     
307. 
     
308. RMAN> list incarnation of database;
     
309. 
     
310. 
     
311. List of Database Incarnations
     
312. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
     
313. ------- ------- -------- ---------------- --- ---------- ----------
     
314. 1       1       ORCL     1343950367       PARENT  1          15-AUG-09
     
315. 2       2       ORCL     1343950367       PARENT  945184     23-MAY-13
     
316. 3       3       ORCL     1343950367       PARENT  1068604    27-MAY-16
     
317. 4       4       ORCL     1343950367       PARENT  1072117    27-MAY-16
     
318. 5       5       ORCL     1343950367       PARENT  1122915    30-MAY-16
     
319. 6       6       ORCL     1343950367       PARENT  1123573    30-MAY-16
     
320. 7       7       ORCL     1343950367       PARENT  1125477    30-MAY-16
     
321. 8       8       ORCL     1343950367       PARENT  1131819    30-MAY-16
     
322. 9       9       ORCL     1343950367       PARENT  1218534    01-JUN-16
     
323. 10      10      ORCL     1343950367       ORPHAN  1219114    01-JUN-16
     
324. 11      11      ORCL     1343950367       PARENT  1219352    01-JUN-16
     
325. 12      12      ORCL     1343950367       PARENT  1223810    01-JUN-16
     
326. 13      13      ORCL     1343950367       ORPHAN  1265510    01-JUN-16
     
327. 14      14      ORCL     1343950367       PARENT  1265510    01-JUN-16
     
328. 15      15      ORCL     1343950367       CURRENT 1266539    01-JUN-16
     
329. 
     
330. RMAN> run {
     
331. 2> reset database to incarnation 14;
     
332. 
     
333. RMAN-00571: ===========================================================
     
334. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
335. RMAN-00571: ===========================================================
     
336. RMAN-00558: error encountered while parsing input commands
     
337. RMAN-01009: syntax error: found "reset": expecting one of: "advise, allocate, alter, backup, @, catalog, change, configure, convert, copy, crosscheck, delete, duplicate, execute, flashback, host, mount, open, recover, release, repair, report, restore, resync, send, set, show, shutdown, sql, startup, switch, transport, validate, "
     
338. RMAN-01007: at line 2 column 1 file: standard input
     
339. 
     
340. RMAN> reset database to incarnation 14;
     
341. 
     
342. RMAN-00571: ===========================================================
     
343. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
344. RMAN-00571: ===========================================================
     
345. RMAN-03009: failure of reset database command on default channel at 06/14/2016 11:56:57
     
346. ORA-19910: can not change recovery target incarnation in control file
     
347. 
     
348. RMAN> exit
     
349. 
     
350. 
     
351. Recovery Manager complete.
     
352. [oracle@station90 ~]$ sqlplus /nolog
     
353. 
     
354. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 14 11:58:44 2016
     
355. 
     
356. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
357. 
     
358. SQL> conn / as sysdba
     
359. Connected.
     
360. SQL> startup force
     
361. ORACLE instance started.
     
362. 
     
363. Total System Global Area 6680915968 bytes
     
364. Fixed Size                    2213936 bytes
     
365. Variable Size                 3556771792 bytes
     
366. Database Buffers         3087007744 bytes
     
367. Redo Buffers                   34922496 bytes
     
368. Database mounted.
     
369. Database opened.
     
370. SQL> exit
     
371. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
372. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
373. and Real Application Testing options
     
374. [oracle@station90 ~]$ rman target /
     
375. 
     
376. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 14 11:59:55 2016
     
377. 
     
378. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
379. 
     
380. connected to target database: ORCL (DBID=1343950367)
     
381. 
     
382. RMAN> backup tag '1T_SYSTEM_INCR0' incremental level 0 tablespace system ;
     
383. 
     
384. Starting backup at 14-JUN-16
     
385. using target database control file instead of recovery catalog
     
386. allocated channel: ORA_SBT_TAPE_1
     
387. channel ORA_SBT_TAPE_1: SID=137 device type=SBT_TAPE
     
388. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
389. allocated channel: ORA_SBT_TAPE_2
     
390. channel ORA_SBT_TAPE_2: SID=197 device type=SBT_TAPE
     
391. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
392. allocated channel: ORA_SBT_TAPE_3
     
393. channel ORA_SBT_TAPE_3: SID=8 device type=SBT_TAPE
     
394. channel ORA_SBT_TAPE_3: Oracle Secure Backup
     
395. allocated channel: ORA_SBT_TAPE_4
     
396. channel ORA_SBT_TAPE_4: SID=76 device type=SBT_TAPE
     
397. channel ORA_SBT_TAPE_4: Oracle Secure Backup
     
398. allocated channel: ORA_SBT_TAPE_5
     
399. channel ORA_SBT_TAPE_5: SID=135 device type=SBT_TAPE
     
400. channel ORA_SBT_TAPE_5: Oracle Secure Backup
     
401. allocated channel: ORA_SBT_TAPE_6
     
402. channel ORA_SBT_TAPE_6: SID=198 device type=SBT_TAPE
     
403. channel ORA_SBT_TAPE_6: Oracle Secure Backup
     
404. allocated channel: ORA_SBT_TAPE_7
     
405. channel ORA_SBT_TAPE_7: SID=11 device type=SBT_TAPE
     
406. channel ORA_SBT_TAPE_7: Oracle Secure Backup
     
407. allocated channel: ORA_SBT_TAPE_8
     
408. channel ORA_SBT_TAPE_8: SID=77 device type=SBT_TAPE
     
409. channel ORA_SBT_TAPE_8: Oracle Secure Backup
     
410. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
     
411. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
412. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
     
413. channel ORA_SBT_TAPE_1: starting piece 1 at 14-JUN-16
     
414. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
     
415. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
416. channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
     
417. channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
     
418. including current SPFILE in backup set
     
419. channel ORA_SBT_TAPE_3: starting piece 1 at 14-JUN-16
     
420. including current control file in backup set
     
421. channel ORA_SBT_TAPE_2: starting piece 1 at 14-JUN-16
     
422. channel ORA_SBT_TAPE_3: finished piece 1 at 14-JUN-16
     
423. piece handle=3br84b92_1_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
     
424. channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:00:26
     
425. channel ORA_SBT_TAPE_1: finished piece 1 at 14-JUN-16
     
426. piece handle=39r84b92_1_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
     
427. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:06
     
428. channel ORA_SBT_TAPE_2: finished piece 1 at 14-JUN-16
     
429. piece handle=3ar84b92_1_1 tag=1T_SYSTEM_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
     
430. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:15
     
431. Finished backup at 14-JUN-16
     
432. 
     
433. RMAN> list backup ;
     
434. 
     
435. 
     
436. List of Backup Sets
     
437. ===================
     
438. 
     
439. 
     
440. BS Key  Size       Device Type Elapsed Time Completion Time
     
441. ------- ---------- ----------- ------------ ---------------
     
442. 80      16.63M     SBT_TAPE    00:00:24     07-JUN-16      
     
443.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213543
     
444.         Handle: 2rr7iu9g_1_1   Media: station90-000013
     
445. 
     
446.   List of Archived Logs in backup set 80
     
447.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
448.   ---- ------- ---------- --------- ---------- ---------
     
449.   1    28      1544415    06-JUN-16 1547833    07-JUN-16
     
450. 
     
451. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
452. ------- ---- -- ---------- ----------- ------------ ---------------
     
453. 82      Incr 1  16.52M     DISK        00:00:03     08-JUN-16      
     
454.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
     
455.         Piece Name: +FRA/orcl/backupset/2016_06_08/nnndn1_ora_oem_level_0_0.279.914016939
     
456.   List of Datafiles in backup set 82
     
457.   File LV Type Ckp SCN    Ckp Time  Name
     
458.   ---- -- ---- ---------- --------- ----
     
459.   1    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/system.256.914102913
     
460.   2    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553
     
461.   3    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553
     
462.   5    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/example.265.816169651
     
463. 
     
464. BS Key  Size       Device Type Elapsed Time Completion Time
     
465. ------- ---------- ----------- ------------ ---------------
     
466. 84      9.69M      SBT_TAPE    00:00:23     08-JUN-16      
     
467.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213546
     
468.         Handle: 2vr7lilj_1_1   Media: station90-000013
     
469. 
     
470.   List of Archived Logs in backup set 84
     
471.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
472.   ---- ------- ---------- --------- ---------- ---------
     
473.   1    29      1547833    07-JUN-16 1551061    08-JUN-16
     
474. 
     
475. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
476. ------- ---- -- ---------- ----------- ------------ ---------------
     
477. 86      Full    600.75M    SBT_TAPE    00:02:09     09-JUN-16      
     
478.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T201727
     
479.         Handle: 31r7o2en_1_1   Media: station90-000013
     
480.   List of Datafiles in backup set 86
     
481.   File LV Type Ckp SCN    Ckp Time  Name
     
482.   ---- -- ---- ---------- --------- ----
     
483.   1       Full 1577433    09-JUN-16 +DATA/orcl/datafile/system.256.914102913
     
484. 
     
485. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
486. ------- ---- -- ---------- ----------- ------------ ---------------
     
487. 88      Full    1.06M      SBT_TAPE    00:00:15     09-JUN-16      
     
488.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202130
     
489.         Handle: 33r7o2ma_1_1   Media: station90-000013
     
490.   List of Datafiles in backup set 88
     
491.   File LV Type Ckp SCN    Ckp Time  Name
     
492.   ---- -- ---- ---------- --------- ----
     
493.   4       Full 1577931    09-JUN-16 +DATA/orcl/datafile/users.259.914101365
     
494. 
     
495. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
496. ------- ---- -- ---------- ----------- ------------ ---------------
     
497. 91      Full    9.61M      DISK        00:00:00     09-JUN-16      
     
498.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T211017
     
499.         Piece Name: +FRA/orcl/autobackup/2016_06_09/s_914101817.298.914101817
     
500.   SPFILE Included: Modification time: 09-JUN-16
     
501.   SPFILE db_unique_name: ORCL
     
502.   Control File Included: Ckp SCN: 1581203      Ckp time: 09-JUN-16
     
503. 
     
504. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
505. ------- ---- -- ---------- ----------- ------------ ---------------
     
506. 92      Incr 0  1.13M      SBT_TAPE    00:00:43     14-JUN-16      
     
507.         BP Key: 92   Status: AVAILABLE  Compressed: NO  Tag: 1T_USERS_INCR0
     
508.         Handle: 37r84aog_1_1   Media: station90-000013
     
509.   List of Datafiles in backup set 92
     
510.   File LV Type Ckp SCN    Ckp Time  Name
     
511.   ---- -- ---- ---------- --------- ----
     
512.   4    0  Incr 1835474    14-JUN-16 +DATA/orcl/datafile/users.259.914101365
     
513. 
     
514. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
515. ------- ---- -- ---------- ----------- ------------ ---------------
     
516. 93      Full    9.63M      SBT_TAPE    00:00:16     14-JUN-16      
     
517.         BP Key: 93   Status: AVAILABLE  Compressed: NO  Tag: TAG20160614T115338
     
518.         Handle: c-1343950367-20160614-00   Media: station90-000013
     
519.   SPFILE Included: Modification time: 14-JUN-16
     
520.   SPFILE db_unique_name: ORCL
     
521.   Control File Included: Ckp SCN: 1835515      Ckp time: 14-JUN-16
     
522. 
     
523. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
524. ------- ---- -- ---------- ----------- ------------ ---------------
     
525. 94      Incr 0  128.00K    SBT_TAPE    00:00:24     14-JUN-16      
     
526.         BP Key: 94   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
     
527.         Handle: 3br84b92_1_1   Media: station90-000013
     
528.   SPFILE Included: Modification time: 14-JUN-16
     
529.   SPFILE db_unique_name: ORCL
     
530. 
     
531. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
532. ------- ---- -- ---------- ----------- ------------ ---------------
     
533. 95      Incr 0  602.75M    SBT_TAPE    00:00:58     14-JUN-16      
     
534.         BP Key: 95   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
     
535.         Handle: 39r84b92_1_1   Media: station90-000014
     
536.   List of Datafiles in backup set 95
     
537.   File LV Type Ckp SCN    Ckp Time  Name
     
538.   ---- -- ---- ---------- --------- ----
     
539.   1    0  Incr 1856051    14-JUN-16 +DATA/orcl/datafile/system.256.914102913
     
540. 
     
541. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
542. ------- ---- -- ---------- ----------- ------------ ---------------
     
543. 96      Incr 0  9.63M      SBT_TAPE    00:01:10     14-JUN-16      
     
544.         BP Key: 96   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
     
545.         Handle: 3ar84b92_1_1   Media: station90-000013
     
546.   Control File Included: Ckp SCN: 1856049      Ckp time: 14-JUN-16
     
547. 
     
548. 
     

复制代码

botang

botang 发表于 2016-6-13 10:51

1. RMAN> run {
   
2. 2> allocate channel c1 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
   
3. 3> allocate channel c2 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
   
4. 4> allocate channel c3 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
   
5. 5> allocate channel c4 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
   
6. 6> allocate channel c5 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
   
7. 7> allocate channel c6 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
   
8. 8> allocate channel c7 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
   
9. 9> allocate channel c8 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
   
10. 10> backup tag '1T_WHOLE_INCR0' database  plus archivelog delete all input;
    
11. 11> release c1;
    
12. 
    
13. RMAN-00571: ===========================================================
    
14. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
15. RMAN-00571: ===========================================================
    
16. RMAN-00558: error encountered while parsing input commands
    
17. RMAN-01009: syntax error: found "identifier": expecting one of: "channel"
    
18. RMAN-01008: the bad identifier was: c1
    
19. RMAN-01007: at line 11 column 9 file: standard input
    
20. 
    
21. RMAN> run {
    
22. 2> allocate channel c1 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
    
23. 3> allocate channel c2 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
    
24. 4> allocate channel c3 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
    
25. 5> allocate channel c4 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
    
26. 6> allocate channel c5 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
    
27. 7> allocate channel c6 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
    
28. 8> allocate channel c7 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
    
29. 9> allocate channel c8 device type disk format '/home/oracle/manual_backup/db_%U.bkp';
    
30. 10> backup tag '1T_WHOLE_INCR0' database  plus archivelog delete all input;
    
31. 11> release channel c1;
    
32. 12> release channel c2;
    
33. 13> release channel c3;
    
34. 14> release channel c4;
    
35. 15> release channel c5;
    
36. 16> release channel c6;
    
37. 17> release channel c7;
    
38. 18> release channel c8;
    
39. 19> }
    
40. 
    
41. released channel: ORA_SBT_TAPE_1
    
42. released channel: ORA_SBT_TAPE_2
    
43. released channel: ORA_SBT_TAPE_3
    
44. released channel: ORA_SBT_TAPE_4
    
45. released channel: ORA_SBT_TAPE_5
    
46. released channel: ORA_SBT_TAPE_6
    
47. released channel: ORA_SBT_TAPE_7
    
48. released channel: ORA_SBT_TAPE_8
    
49. allocated channel: c1
    
50. channel c1: SID=137 device type=DISK
    
51. 
    
52. allocated channel: c2
    
53. channel c2: SID=197 device type=DISK
    
54. 
    
55. allocated channel: c3
    
56. channel c3: SID=8 device type=DISK
    
57. 
    
58. allocated channel: c4
    
59. channel c4: SID=76 device type=DISK
    
60. 
    
61. allocated channel: c5
    
62. channel c5: SID=135 device type=DISK
    
63. 
    
64. allocated channel: c6
    
65. channel c6: SID=198 device type=DISK
    
66. 
    
67. allocated channel: c7
    
68. channel c7: SID=11 device type=DISK
    
69. 
    
70. allocated channel: c8
    
71. channel c8: SID=77 device type=DISK
    
72. 
    
73. 
    
74. Starting backup at 14-JUN-16
    
75. current log archived
    
76. channel c1: starting archived log backup set
    
77. channel c1: specifying archived log(s) in backup set
    
78. input archived log thread=1 sequence=28 RECID=195 STAMP=913930543
    
79. input archived log thread=1 sequence=29 RECID=196 STAMP=914016946
    
80. input archived log thread=1 sequence=30 RECID=197 STAMP=914058005
    
81. input archived log thread=1 sequence=31 RECID=198 STAMP=914058288
    
82. input archived log thread=1 sequence=32 RECID=199 STAMP=914065255
    
83. channel c1: starting piece 1 at 14-JUN-16
    
84. channel c2: starting archived log backup set
    
85. channel c2: specifying archived log(s) in backup set
    
86. input archived log thread=1 sequence=33 RECID=200 STAMP=914094157
    
87. input archived log thread=1 sequence=34 RECID=201 STAMP=914097709
    
88. input archived log thread=1 sequence=35 RECID=202 STAMP=914098167
    
89. input archived log thread=1 sequence=36 RECID=203 STAMP=914100303
    
90. input archived log thread=1 sequence=37 RECID=204 STAMP=914100303
    
91. input archived log thread=1 sequence=38 RECID=205 STAMP=914100304
    
92. channel c2: starting piece 1 at 14-JUN-16
    
93. channel c3: starting archived log backup set
    
94. channel c3: specifying archived log(s) in backup set
    
95. input archived log thread=1 sequence=39 RECID=206 STAMP=914100305
    
96. input archived log thread=1 sequence=40 RECID=207 STAMP=914100308
    
97. input archived log thread=1 sequence=41 RECID=208 STAMP=914100311
    
98. input archived log thread=1 sequence=42 RECID=209 STAMP=914102244
    
99. input archived log thread=1 sequence=43 RECID=210 STAMP=914102244
    
100. input archived log thread=1 sequence=44 RECID=211 STAMP=914102246
     
101. channel c3: starting piece 1 at 14-JUN-16
     
102. channel c4: starting archived log backup set
     
103. channel c4: specifying archived log(s) in backup set
     
104. input archived log thread=1 sequence=45 RECID=212 STAMP=914102248
     
105. input archived log thread=1 sequence=46 RECID=213 STAMP=914102249
     
106. input archived log thread=1 sequence=47 RECID=214 STAMP=914102252
     
107. input archived log thread=1 sequence=48 RECID=215 STAMP=914148051
     
108. input archived log thread=1 sequence=49 RECID=216 STAMP=914155256
     
109. input archived log thread=1 sequence=50 RECID=217 STAMP=914164282
     
110. channel c4: starting piece 1 at 14-JUN-16
     
111. channel c5: starting archived log backup set
     
112. channel c5: specifying archived log(s) in backup set
     
113. input archived log thread=1 sequence=51 RECID=218 STAMP=914173019
     
114. input archived log thread=1 sequence=52 RECID=219 STAMP=914180536
     
115. input archived log thread=1 sequence=53 RECID=220 STAMP=914188041
     
116. input archived log thread=1 sequence=54 RECID=221 STAMP=914191220
     
117. channel c5: starting piece 1 at 14-JUN-16
     
118. channel c6: starting archived log backup set
     
119. channel c6: specifying archived log(s) in backup set
     
120. input archived log thread=1 sequence=55 RECID=222 STAMP=914191248
     
121. input archived log thread=1 sequence=56 RECID=223 STAMP=914191282
     
122. input archived log thread=1 sequence=57 RECID=224 STAMP=914194805
     
123. input archived log thread=1 sequence=58 RECID=225 STAMP=914230471
     
124. channel c6: starting piece 1 at 14-JUN-16
     
125. channel c7: starting archived log backup set
     
126. channel c7: specifying archived log(s) in backup set
     
127. input archived log thread=1 sequence=59 RECID=226 STAMP=914203593
     
128. input archived log thread=1 sequence=60 RECID=227 STAMP=914249580
     
129. input archived log thread=1 sequence=61 RECID=228 STAMP=914311234
     
130. input archived log thread=1 sequence=62 RECID=229 STAMP=914311363
     
131. channel c7: starting piece 1 at 14-JUN-16
     
132. channel c8: starting archived log backup set
     
133. channel c8: specifying archived log(s) in backup set
     
134. input archived log thread=1 sequence=63 RECID=230 STAMP=914326016
     
135. input archived log thread=1 sequence=64 RECID=231 STAMP=914335222
     
136. input archived log thread=1 sequence=65 RECID=232 STAMP=914374433
     
137. input archived log thread=1 sequence=66 RECID=233 STAMP=914403622
     
138. input archived log thread=1 sequence=67 RECID=234 STAMP=914462073
     
139. channel c8: starting piece 1 at 14-JUN-16
     
140. channel c1: finished piece 1 at 14-JUN-16
     
141. piece handle=/home/oracle/manual_backup/db_3cr84bpg_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
142. channel c1: backup set complete, elapsed time: 00:00:05
     
143. channel c1: deleting archived log(s)
     
144. archived log file name=+FRA/orcl/archivelog/2016_06_07/thread_1_seq_28.278.913930543 RECID=195 STAMP=913930543
     
145. archived log file name=+FRA/orcl/archivelog/2016_06_08/thread_1_seq_29.281.914016947 RECID=196 STAMP=914016946
     
146. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_30.282.914058005 RECID=197 STAMP=914058005
     
147. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_31.283.914058287 RECID=198 STAMP=914058288
     
148. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_32.284.914065255 RECID=199 STAMP=914065255
     
149. channel c1: starting archived log backup set
     
150. channel c1: specifying archived log(s) in backup set
     
151. input archived log thread=1 sequence=68 RECID=235 STAMP=914462103
     
152. input archived log thread=1 sequence=69 RECID=236 STAMP=914463848
     
153. input archived log thread=1 sequence=70 RECID=237 STAMP=914480468
     
154. input archived log thread=1 sequence=71 RECID=238 STAMP=914500742
     
155. input archived log thread=1 sequence=72 RECID=239 STAMP=914501423
     
156. channel c1: starting piece 1 at 14-JUN-16
     
157. channel c2: finished piece 1 at 14-JUN-16
     
158. piece handle=/home/oracle/manual_backup/db_3dr84bpg_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
159. channel c2: backup set complete, elapsed time: 00:00:06
     
160. channel c2: deleting archived log(s)
     
161. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_33.285.914094157 RECID=200 STAMP=914094157
     
162. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_34.286.914097709 RECID=201 STAMP=914097709
     
163. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_35.288.914098167 RECID=202 STAMP=914098167
     
164. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_36.292.914100303 RECID=203 STAMP=914100303
     
165. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_37.289.914100303 RECID=204 STAMP=914100303
     
166. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_38.293.914100305 RECID=205 STAMP=914100304
     
167. channel c3: finished piece 1 at 14-JUN-16
     
168. piece handle=/home/oracle/manual_backup/db_3er84bph_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
169. channel c3: backup set complete, elapsed time: 00:00:07
     
170. channel c3: deleting archived log(s)
     
171. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_39.290.914100305 RECID=206 STAMP=914100305
     
172. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_40.291.914100309 RECID=207 STAMP=914100308
     
173. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_41.295.914100311 RECID=208 STAMP=914100311
     
174. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_42.301.914102245 RECID=209 STAMP=914102244
     
175. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_43.300.914102245 RECID=210 STAMP=914102244
     
176. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_44.303.914102245 RECID=211 STAMP=914102246
     
177. channel c4: finished piece 1 at 14-JUN-16
     
178. piece handle=/home/oracle/manual_backup/db_3fr84bpi_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
179. channel c4: backup set complete, elapsed time: 00:00:06
     
180. channel c4: deleting archived log(s)
     
181. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_45.305.914102249 RECID=212 STAMP=914102248
     
182. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_46.306.914102249 RECID=213 STAMP=914102249
     
183. archived log file name=+FRA/orcl/archivelog/2016_06_09/thread_1_seq_47.316.914102253 RECID=214 STAMP=914102252
     
184. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_48.268.914148051 RECID=215 STAMP=914148051
     
185. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_49.310.914155255 RECID=216 STAMP=914155256
     
186. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_50.309.914164281 RECID=217 STAMP=914164282
     
187. channel c5: finished piece 1 at 14-JUN-16
     
188. piece handle=/home/oracle/manual_backup/db_3gr84bpi_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
189. channel c5: backup set complete, elapsed time: 00:00:07
     
190. channel c5: deleting archived log(s)
     
191. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_51.311.914173019 RECID=218 STAMP=914173019
     
192. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_52.314.914180537 RECID=219 STAMP=914180536
     
193. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_53.308.914188041 RECID=220 STAMP=914188041
     
194. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_54.341.914191219 RECID=221 STAMP=914191220
     
195. channel c6: finished piece 1 at 14-JUN-16
     
196. piece handle=/home/oracle/manual_backup/db_3hr84bpj_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
197. channel c6: backup set complete, elapsed time: 00:00:06
     
198. channel c6: deleting archived log(s)
     
199. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_55.334.914191249 RECID=222 STAMP=914191248
     
200. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_56.328.914191283 RECID=223 STAMP=914191282
     
201. archived log file name=+FRA/orcl/archivelog/2016_06_10/thread_1_seq_57.318.914194805 RECID=224 STAMP=914194805
     
202. archived log file name=+FRA/orcl/archivelog/2016_06_11/thread_1_seq_58.331.914230471 RECID=225 STAMP=914230471
     
203. channel c1: finished piece 1 at 14-JUN-16
     
204. piece handle=/home/oracle/manual_backup/db_3kr84bpn_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
205. channel c1: backup set complete, elapsed time: 00:00:03
     
206. channel c1: deleting archived log(s)
     
207. archived log file name=+FRA/orcl/archivelog/2016_06_14/thread_1_seq_68.326.914462103 RECID=235 STAMP=914462103
     
208. archived log file name=+FRA/orcl/archivelog/2016_06_14/thread_1_seq_69.332.914463847 RECID=236 STAMP=914463848
     
209. archived log file name=+FRA/orcl/archivelog/2016_06_14/thread_1_seq_70.333.914480469 RECID=237 STAMP=914480468
     
210. archived log file name=+FRA/orcl/archivelog/2016_06_14/thread_1_seq_71.313.914500743 RECID=238 STAMP=914500742
     
211. archived log file name=+FRA/orcl/archivelog/2016_06_14/thread_1_seq_72.280.914501423 RECID=239 STAMP=914501423
     
212. channel c7: finished piece 1 at 14-JUN-16
     
213. piece handle=/home/oracle/manual_backup/db_3ir84bpk_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
214. channel c7: backup set complete, elapsed time: 00:00:06
     
215. channel c7: deleting archived log(s)
     
216. archived log file name=+FRA/orcl/archivelog/2016_06_11/thread_1_seq_59.319.914203593 RECID=226 STAMP=914203593
     
217. archived log file name=+FRA/orcl/archivelog/2016_06_11/thread_1_seq_60.317.914249581 RECID=227 STAMP=914249580
     
218. archived log file name=+FRA/orcl/archivelog/2016_06_12/thread_1_seq_61.320.914311233 RECID=228 STAMP=914311234
     
219. archived log file name=+FRA/orcl/archivelog/2016_06_12/thread_1_seq_62.321.914311363 RECID=229 STAMP=914311363
     
220. channel c8: finished piece 1 at 14-JUN-16
     
221. piece handle=/home/oracle/manual_backup/db_3jr84bpk_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
222. channel c8: backup set complete, elapsed time: 00:00:05
     
223. channel c8: deleting archived log(s)
     
224. archived log file name=+FRA/orcl/archivelog/2016_06_12/thread_1_seq_63.322.914326017 RECID=230 STAMP=914326016
     
225. archived log file name=+FRA/orcl/archivelog/2016_06_12/thread_1_seq_64.323.914335223 RECID=231 STAMP=914335222
     
226. archived log file name=+FRA/orcl/archivelog/2016_06_13/thread_1_seq_65.324.914374433 RECID=232 STAMP=914374433
     
227. archived log file name=+FRA/orcl/archivelog/2016_06_13/thread_1_seq_66.327.914403623 RECID=233 STAMP=914403622
     
228. archived log file name=+FRA/orcl/archivelog/2016_06_14/thread_1_seq_67.325.914462073 RECID=234 STAMP=914462073
     
229. Finished backup at 14-JUN-16
     
230. 
     
231. Starting backup at 14-JUN-16
     
232. channel c1: starting full datafile backup set
     
233. channel c1: specifying datafile(s) in backup set
     
234. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
     
235. channel c1: starting piece 1 at 14-JUN-16
     
236. channel c2: starting full datafile backup set
     
237. channel c2: specifying datafile(s) in backup set
     
238. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
     
239. channel c2: starting piece 1 at 14-JUN-16
     
240. channel c3: starting full datafile backup set
     
241. channel c3: specifying datafile(s) in backup set
     
242. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
     
243. channel c3: starting piece 1 at 14-JUN-16
     
244. channel c4: starting full datafile backup set
     
245. channel c4: specifying datafile(s) in backup set
     
246. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
     
247. channel c4: starting piece 1 at 14-JUN-16
     
248. channel c5: starting full datafile backup set
     
249. channel c5: specifying datafile(s) in backup set
     
250. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
     
251. channel c5: starting piece 1 at 14-JUN-16
     
252. channel c6: starting full datafile backup set
     
253. channel c6: specifying datafile(s) in backup set
     
254. channel c7: starting full datafile backup set
     
255. channel c7: specifying datafile(s) in backup set
     
256. including current SPFILE in backup set
     
257. channel c7: starting piece 1 at 14-JUN-16
     
258. channel c1: finished piece 1 at 14-JUN-16
     
259. piece handle=/home/oracle/manual_backup/db_3lr84bps_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
260. channel c1: backup set complete, elapsed time: 00:00:10
     
261. including current control file in backup set
     
262. channel c6: starting piece 1 at 14-JUN-16
     
263. channel c7: finished piece 1 at 14-JUN-16
     
264. piece handle=/home/oracle/manual_backup/db_3rr84bpv_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
265. channel c7: backup set complete, elapsed time: 00:00:08
     
266. channel c3: finished piece 1 at 14-JUN-16
     
267. piece handle=/home/oracle/manual_backup/db_3nr84bps_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
268. channel c3: backup set complete, elapsed time: 00:00:11
     
269. channel c2: finished piece 1 at 14-JUN-16
     
270. piece handle=/home/oracle/manual_backup/db_3mr84bps_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
271. channel c2: backup set complete, elapsed time: 00:00:14
     
272. channel c4: finished piece 1 at 14-JUN-16
     
273. piece handle=/home/oracle/manual_backup/db_3or84bps_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
274. channel c4: backup set complete, elapsed time: 00:00:13
     
275. channel c5: finished piece 1 at 14-JUN-16
     
276. piece handle=/home/oracle/manual_backup/db_3pr84bpu_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
277. channel c5: backup set complete, elapsed time: 00:00:12
     
278. channel c6: finished piece 1 at 14-JUN-16
     
279. piece handle=/home/oracle/manual_backup/db_3qr84bpu_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
280. channel c6: backup set complete, elapsed time: 00:00:04
     
281. Finished backup at 14-JUN-16
     
282. 
     
283. Starting backup at 14-JUN-16
     
284. current log archived
     
285. channel c1: starting archived log backup set
     
286. channel c1: specifying archived log(s) in backup set
     
287. input archived log thread=1 sequence=73 RECID=240 STAMP=914501450
     
288. channel c1: starting piece 1 at 14-JUN-16
     
289. channel c1: finished piece 1 at 14-JUN-16
     
290. piece handle=/home/oracle/manual_backup/db_3sr84bqb_1_1.bkp tag=1T_WHOLE_INCR0 comment=NONE
     
291. channel c1: backup set complete, elapsed time: 00:00:01
     
292. channel c1: deleting archived log(s)
     
293. archived log file name=+FRA/orcl/archivelog/2016_06_14/thread_1_seq_73.325.914501451 RECID=240 STAMP=914501450
     
294. Finished backup at 14-JUN-16
     
295. 
     
296. released channel: c1
     
297. 
     
298. released channel: c2
     
299. 
     
300. released channel: c3
     
301. 
     
302. released channel: c4
     
303. 
     
304. released channel: c5
     
305. 
     
306. released channel: c6
     
307. 
     
308. released channel: c7
     
309. 
     
310. released channel: c8
     
311. 
     
312. RMAN> list backup;
     
313. 
     
314. 
     
315. List of Backup Sets
     
316. ===================
     
317. 
     
318. 
     
319. BS Key  Size       Device Type Elapsed Time Completion Time
     
320. ------- ---------- ----------- ------------ ---------------
     
321. 80      16.63M     SBT_TAPE    00:00:24     07-JUN-16      
     
322.         BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: TAG20160607T213543
     
323.         Handle: 2rr7iu9g_1_1   Media: station90-000013
     
324. 
     
325.   List of Archived Logs in backup set 80
     
326.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
327.   ---- ------- ---------- --------- ---------- ---------
     
328.   1    28      1544415    06-JUN-16 1547833    07-JUN-16
     
329. 
     
330. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
331. ------- ---- -- ---------- ----------- ------------ ---------------
     
332. 82      Incr 1  16.52M     DISK        00:00:03     08-JUN-16      
     
333.         BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: ORA_OEM_LEVEL_0
     
334.         Piece Name: +FRA/orcl/backupset/2016_06_08/nnndn1_ora_oem_level_0_0.279.914016939
     
335.   List of Datafiles in backup set 82
     
336.   File LV Type Ckp SCN    Ckp Time  Name
     
337.   ---- -- ---- ---------- --------- ----
     
338.   1    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/system.256.914102913
     
339.   2    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553
     
340.   3    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553
     
341.   5    1  Incr 1550813    08-JUN-16 +DATA/orcl/datafile/example.265.816169651
     
342. 
     
343. BS Key  Size       Device Type Elapsed Time Completion Time
     
344. ------- ---------- ----------- ------------ ---------------
     
345. 84      9.69M      SBT_TAPE    00:00:23     08-JUN-16      
     
346.         BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: TAG20160608T213546
     
347.         Handle: 2vr7lilj_1_1   Media: station90-000013
     
348. 
     
349.   List of Archived Logs in backup set 84
     
350.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
351.   ---- ------- ---------- --------- ---------- ---------
     
352.   1    29      1547833    07-JUN-16 1551061    08-JUN-16
     
353. 
     
354. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
355. ------- ---- -- ---------- ----------- ------------ ---------------
     
356. 86      Full    600.75M    SBT_TAPE    00:02:09     09-JUN-16      
     
357.         BP Key: 86   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T201727
     
358.         Handle: 31r7o2en_1_1   Media: station90-000013
     
359.   List of Datafiles in backup set 86
     
360.   File LV Type Ckp SCN    Ckp Time  Name
     
361.   ---- -- ---- ---------- --------- ----
     
362.   1       Full 1577433    09-JUN-16 +DATA/orcl/datafile/system.256.914102913
     
363. 
     
364. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
365. ------- ---- -- ---------- ----------- ------------ ---------------
     
366. 88      Full    1.06M      SBT_TAPE    00:00:15     09-JUN-16      
     
367.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T202130
     
368.         Handle: 33r7o2ma_1_1   Media: station90-000013
     
369.   List of Datafiles in backup set 88
     
370.   File LV Type Ckp SCN    Ckp Time  Name
     
371.   ---- -- ---- ---------- --------- ----
     
372.   4       Full 1577931    09-JUN-16 +DATA/orcl/datafile/users.259.914101365
     
373. 
     
374. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
375. ------- ---- -- ---------- ----------- ------------ ---------------
     
376. 91      Full    9.61M      DISK        00:00:00     09-JUN-16      
     
377.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: TAG20160609T211017
     
378.         Piece Name: +FRA/orcl/autobackup/2016_06_09/s_914101817.298.914101817
     
379.   SPFILE Included: Modification time: 09-JUN-16
     
380.   SPFILE db_unique_name: ORCL
     
381.   Control File Included: Ckp SCN: 1581203      Ckp time: 09-JUN-16
     
382. 
     
383. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
384. ------- ---- -- ---------- ----------- ------------ ---------------
     
385. 92      Incr 0  1.13M      SBT_TAPE    00:00:43     14-JUN-16      
     
386.         BP Key: 92   Status: AVAILABLE  Compressed: NO  Tag: 1T_USERS_INCR0
     
387.         Handle: 37r84aog_1_1   Media: station90-000013
     
388.   List of Datafiles in backup set 92
     
389.   File LV Type Ckp SCN    Ckp Time  Name
     
390.   ---- -- ---- ---------- --------- ----
     
391.   4    0  Incr 1835474    14-JUN-16 +DATA/orcl/datafile/users.259.914101365
     
392. 
     
393. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
394. ------- ---- -- ---------- ----------- ------------ ---------------
     
395. 93      Full    9.63M      SBT_TAPE    00:00:16     14-JUN-16      
     
396.         BP Key: 93   Status: AVAILABLE  Compressed: NO  Tag: TAG20160614T115338
     
397.         Handle: c-1343950367-20160614-00   Media: station90-000013
     
398.   SPFILE Included: Modification time: 14-JUN-16
     
399.   SPFILE db_unique_name: ORCL
     
400.   Control File Included: Ckp SCN: 1835515      Ckp time: 14-JUN-16
     
401. 
     
402. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
403. ------- ---- -- ---------- ----------- ------------ ---------------
     
404. 94      Incr 0  128.00K    SBT_TAPE    00:00:24     14-JUN-16      
     
405.         BP Key: 94   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
     
406.         Handle: 3br84b92_1_1   Media: station90-000013
     
407.   SPFILE Included: Modification time: 14-JUN-16
     
408.   SPFILE db_unique_name: ORCL
     
409. 
     
410. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
411. ------- ---- -- ---------- ----------- ------------ ---------------
     
412. 95      Incr 0  602.75M    SBT_TAPE    00:00:58     14-JUN-16      
     
413.         BP Key: 95   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
     
414.         Handle: 39r84b92_1_1   Media: station90-000014
     
415.   List of Datafiles in backup set 95
     
416.   File LV Type Ckp SCN    Ckp Time  Name
     
417.   ---- -- ---- ---------- --------- ----
     
418.   1    0  Incr 1856051    14-JUN-16 +DATA/orcl/datafile/system.256.914102913
     
419. 
     
420. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
421. ------- ---- -- ---------- ----------- ------------ ---------------
     
422. 96      Incr 0  9.63M      SBT_TAPE    00:01:10     14-JUN-16      
     
423.         BP Key: 96   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSTEM_INCR0
     
424.         Handle: 3ar84b92_1_1   Media: station90-000013
     
425.   Control File Included: Ckp SCN: 1856049      Ckp time: 14-JUN-16
     
426. 
     
427. BS Key  Size       Device Type Elapsed Time Completion Time
     
428. ------- ---------- ----------- ------------ ---------------
     
429. 97      83.06M     DISK        00:00:01     14-JUN-16      
     
430.         BP Key: 97   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
431.         Piece Name: /home/oracle/manual_backup/db_3cr84bpg_1_1.bkp
     
432. 
     
433.   List of Archived Logs in backup set 97
     
434.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
435.   ---- ------- ---------- --------- ---------- ---------
     
436.   1    28      1544415    06-JUN-16 1547833    07-JUN-16
     
437.   1    29      1547833    07-JUN-16 1551061    08-JUN-16
     
438.   1    30      1551061    08-JUN-16 1556025    09-JUN-16
     
439.   1    31      1556025    09-JUN-16 1558620    09-JUN-16
     
440.   1    32      1558620    09-JUN-16 1566664    09-JUN-16
     
441. 
     
442. BS Key  Size       Device Type Elapsed Time Completion Time
     
443. ------- ---------- ----------- ------------ ---------------
     
444. 98      34.57M     DISK        00:00:01     14-JUN-16      
     
445.         BP Key: 98   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
446.         Piece Name: /home/oracle/manual_backup/db_3dr84bpg_1_1.bkp
     
447. 
     
448.   List of Archived Logs in backup set 98
     
449.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
450.   ---- ------- ---------- --------- ---------- ---------
     
451.   1    33      1566664    09-JUN-16 1571637    09-JUN-16
     
452.   1    34      1571637    09-JUN-16 1576311    09-JUN-16
     
453.   1    35      1576311    09-JUN-16 1576732    09-JUN-16
     
454.   1    36      1576732    09-JUN-16 1579324    09-JUN-16
     
455.   1    37      1579324    09-JUN-16 1579341    09-JUN-16
     
456.   1    38      1579341    09-JUN-16 1579347    09-JUN-16
     
457. 
     
458. BS Key  Size       Device Type Elapsed Time Completion Time
     
459. ------- ---------- ----------- ------------ ---------------
     
460. 99      4.40M      DISK        00:00:01     14-JUN-16      
     
461.         BP Key: 99   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
462.         Piece Name: /home/oracle/manual_backup/db_3er84bph_1_1.bkp
     
463. 
     
464.   List of Archived Logs in backup set 99
     
465.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
466.   ---- ------- ---------- --------- ---------- ---------
     
467.   1    39      1579347    09-JUN-16 1579350    09-JUN-16
     
468.   1    40      1579350    09-JUN-16 1579357    09-JUN-16
     
469.   1    41      1579357    09-JUN-16 1579362    09-JUN-16
     
470.   1    42      1579362    09-JUN-16 1581794    09-JUN-16
     
471.   1    43      1581794    09-JUN-16 1581798    09-JUN-16
     
472.   1    44      1581798    09-JUN-16 1581804    09-JUN-16
     
473. 
     
474. BS Key  Size       Device Type Elapsed Time Completion Time
     
475. ------- ---------- ----------- ------------ ---------------
     
476. 100     47.54M     DISK        00:00:00     14-JUN-16      
     
477.         BP Key: 100   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
478.         Piece Name: /home/oracle/manual_backup/db_3fr84bpi_1_1.bkp
     
479. 
     
480.   List of Archived Logs in backup set 100
     
481.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
482.   ---- ------- ---------- --------- ---------- ---------
     
483.   1    45      1581804    09-JUN-16 1581821    09-JUN-16
     
484.   1    46      1581821    09-JUN-16 1581828    09-JUN-16
     
485.   1    47      1581828    09-JUN-16 1581834    09-JUN-16
     
486.   1    48      1581834    09-JUN-16 1589624    10-JUN-16
     
487.   1    49      1589624    10-JUN-16 1597330    10-JUN-16
     
488.   1    50      1597330    10-JUN-16 1606215    10-JUN-16
     
489. 
     
490. BS Key  Size       Device Type Elapsed Time Completion Time
     
491. ------- ---------- ----------- ------------ ---------------
     
492. 101     81.24M     DISK        00:00:02     14-JUN-16      
     
493.         BP Key: 101   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
494.         Piece Name: /home/oracle/manual_backup/db_3gr84bpi_1_1.bkp
     
495. 
     
496.   List of Archived Logs in backup set 101
     
497.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
498.   ---- ------- ---------- --------- ---------- ---------
     
499.   1    51      1606215    10-JUN-16 1614895    10-JUN-16
     
500.   1    52      1614895    10-JUN-16 1621126    10-JUN-16
     
501.   1    53      1621126    10-JUN-16 1629156    10-JUN-16
     
502.   1    54      1629156    10-JUN-16 1640810    10-JUN-16
     
503. 
     
504. BS Key  Size       Device Type Elapsed Time Completion Time
     
505. ------- ---------- ----------- ------------ ---------------
     
506. 102     75.37M     DISK        00:00:01     14-JUN-16      
     
507.         BP Key: 102   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
508.         Piece Name: /home/oracle/manual_backup/db_3hr84bpj_1_1.bkp
     
509. 
     
510.   List of Archived Logs in backup set 102
     
511.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
512.   ---- ------- ---------- --------- ---------- ---------
     
513.   1    55      1640810    10-JUN-16 1643713    10-JUN-16
     
514.   1    56      1643713    10-JUN-16 1647766    10-JUN-16
     
515.   1    57      1647766    10-JUN-16 1652920    10-JUN-16
     
516.   1    58      1652920    10-JUN-16 1658842    11-JUN-16
     
517. 
     
518. BS Key  Size       Device Type Elapsed Time Completion Time
     
519. ------- ---------- ----------- ------------ ---------------
     
520. 103     71.79M     DISK        00:00:01     14-JUN-16      
     
521.         BP Key: 103   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
522.         Piece Name: /home/oracle/manual_backup/db_3ir84bpk_1_1.bkp
     
523. 
     
524.   List of Archived Logs in backup set 103
     
525.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
526.   ---- ------- ---------- --------- ---------- ---------
     
527.   1    59      1658842    11-JUN-16 1681438    11-JUN-16
     
528.   1    60      1681438    11-JUN-16 1698387    11-JUN-16
     
529.   1    61      1698387    11-JUN-16 1712256    12-JUN-16
     
530.   1    62      1712256    12-JUN-16 1717419    12-JUN-16
     
531. 
     
532. BS Key  Size       Device Type Elapsed Time Completion Time
     
533. ------- ---------- ----------- ------------ ---------------
     
534. 104     84.13M     DISK        00:00:02     14-JUN-16      
     
535.         BP Key: 104   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
536.         Piece Name: /home/oracle/manual_backup/db_3jr84bpk_1_1.bkp
     
537. 
     
538.   List of Archived Logs in backup set 104
     
539.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
540.   ---- ------- ---------- --------- ---------- ---------
     
541.   1    63      1717419    12-JUN-16 1728637    12-JUN-16
     
542.   1    64      1728637    12-JUN-16 1734560    12-JUN-16
     
543.   1    65      1734560    12-JUN-16 1761707    13-JUN-16
     
544.   1    66      1761707    13-JUN-16 1776507    13-JUN-16
     
545.   1    67      1776507    13-JUN-16 1792700    14-JUN-16
     
546. 
     
547. BS Key  Size       Device Type Elapsed Time Completion Time
     
548. ------- ---------- ----------- ------------ ---------------
     
549. 105     61.08M     DISK        00:00:00     14-JUN-16      
     
550.         BP Key: 105   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
551.         Piece Name: /home/oracle/manual_backup/db_3kr84bpn_1_1.bkp
     
552. 
     
553.   List of Archived Logs in backup set 105
     
554.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
555.   ---- ------- ---------- --------- ---------- ---------
     
556.   1    68      1792700    14-JUN-16 1795688    14-JUN-16
     
557.   1    69      1795688    14-JUN-16 1800404    14-JUN-16
     
558.   1    70      1800404    14-JUN-16 1827856    14-JUN-16
     
559.   1    71      1827856    14-JUN-16 1855748    14-JUN-16
     
560.   1    72      1855748    14-JUN-16 1856632    14-JUN-16
     
561. 
     
562. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
563. ------- ---- -- ---------- ----------- ------------ ---------------
     
564. 106     Full    602.71M    DISK        00:00:07     14-JUN-16      
     
565.         BP Key: 106   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
566.         Piece Name: /home/oracle/manual_backup/db_3lr84bps_1_1.bkp
     
567.   List of Datafiles in backup set 106
     
568.   File LV Type Ckp SCN    Ckp Time  Name
     
569.   ---- -- ---- ---------- --------- ----
     
570.   1       Full 1856660    14-JUN-16 +DATA/orcl/datafile/system.256.914102913
     
571. 
     
572. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
573. ------- ---- -- ---------- ----------- ------------ ---------------
     
574. 107     Full    80.00K     DISK        00:00:04     14-JUN-16      
     
575.         BP Key: 107   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
576.         Piece Name: /home/oracle/manual_backup/db_3rr84bpv_1_1.bkp
     
577.   SPFILE Included: Modification time: 14-JUN-16
     
578.   SPFILE db_unique_name: ORCL
     
579. 
     
580. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
581. ------- ---- -- ---------- ----------- ------------ ---------------
     
582. 108     Full    4.41M      DISK        00:00:08     14-JUN-16      
     
583.         BP Key: 108   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
584.         Piece Name: /home/oracle/manual_backup/db_3nr84bps_1_1.bkp
     
585.   List of Datafiles in backup set 108
     
586.   File LV Type Ckp SCN    Ckp Time  Name
     
587.   ---- -- ---- ---------- --------- ----
     
588.   3       Full 1856664    14-JUN-16 +DATA/orcl/datafile/undotbs1.258.816169553
     
589. 
     
590. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
591. ------- ---- -- ---------- ----------- ------------ ---------------
     
592. 109     Full    1.10M      DISK        00:00:10     14-JUN-16      
     
593.         BP Key: 109   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
594.         Piece Name: /home/oracle/manual_backup/db_3pr84bpu_1_1.bkp
     
595.   List of Datafiles in backup set 109
     
596.   File LV Type Ckp SCN    Ckp Time  Name
     
597.   ---- -- ---- ---------- --------- ----
     
598.   4       Full 1856668    14-JUN-16 +DATA/orcl/datafile/users.259.914101365
     
599. 
     
600. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
601. ------- ---- -- ---------- ----------- ------------ ---------------
     
602. 110     Full    509.99M    DISK        00:00:12     14-JUN-16      
     
603.         BP Key: 110   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
604.         Piece Name: /home/oracle/manual_backup/db_3mr84bps_1_1.bkp
     
605.   List of Datafiles in backup set 110
     
606.   File LV Type Ckp SCN    Ckp Time  Name
     
607.   ---- -- ---- ---------- --------- ----
     
608.   2       Full 1856662    14-JUN-16 +DATA/orcl/datafile/sysaux.257.816169553
     
609. 
     
610. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
611. ------- ---- -- ---------- ----------- ------------ ---------------
     
612. 111     Full    14.94M     DISK        00:00:12     14-JUN-16      
     
613.         BP Key: 111   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
614.         Piece Name: /home/oracle/manual_backup/db_3or84bps_1_1.bkp
     
615.   List of Datafiles in backup set 111
     
616.   File LV Type Ckp SCN    Ckp Time  Name
     
617.   ---- -- ---- ---------- --------- ----
     
618.   5       Full 1856669    14-JUN-16 +DATA/orcl/datafile/example.265.816169651
     
619. 
     
620. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
621. ------- ---- -- ---------- ----------- ------------ ---------------
     
622. 112     Full    9.58M      DISK        00:00:10     14-JUN-16      
     
623.         BP Key: 112   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
624.         Piece Name: /home/oracle/manual_backup/db_3qr84bpu_1_1.bkp
     
625.   Control File Included: Ckp SCN: 1856666      Ckp time: 14-JUN-16
     
626. 
     
627. BS Key  Size       Device Type Elapsed Time Completion Time
     
628. ------- ---------- ----------- ------------ ---------------
     
629. 113     10.50K     DISK        00:00:00     14-JUN-16      
     
630.         BP Key: 113   Status: AVAILABLE  Compressed: NO  Tag: 1T_WHOLE_INCR0
     
631.         Piece Name: /home/oracle/manual_backup/db_3sr84bqb_1_1.bkp
     
632. 
     
633.   List of Archived Logs in backup set 113
     
634.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
635.   ---- ------- ---------- --------- ---------- ---------
     
636.   1    73      1856632    14-JUN-16 1856677    14-JUN-16
     
637. 
     
638. RMAN> exit
     
639. 
     
640. 
     
641. Recovery Manager complete.
     
642. [oracle@station90 ~]$ ls
     
643. 3_2014-05-21-1.sql       mail            rcat.sql                 tnsnames.ora              公共的  文档
     
644. afiedt.buf               manual_backup   revertape-root.sh        ttio.rcv                  模板    下载
     
645. copytape-root.sh         oradiag_oracle  select_t04209_uname.sql  update2_t04209_uname.sql  视频    音乐
     
646. create_t04209_uname.sql  rac_tns         t05310.sql               update_t04209_uname.sql   图片    桌面
     
647. [oracle@station90 ~]$ mkdir archivelog
     
648. [oracle@station90 ~]$ cd archivelog/
     
649. [oracle@station90 archivelog]$ ls
     
650. [oracle@station90 archivelog]$ sqlplus /nolog
     
651. 
     
652. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 14 12:23:57 2016
     
653. 
     
654. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
655. 
     
656. SQL> conn /as sysdba
     
657. Connected.
     
658. SQL> show parameter archive_LOG
     
659. SQL> show parameter log_archive
     
660. 
     
661. NAME                                     TYPE         VALUE
     
662. ------------------------------------ ----------- ------------------------------
     
663. log_archive_config                     string
     
664. log_archive_dest                     string
     
665. log_archive_dest_1                     string
     
666. log_archive_dest_10                     string
     
667. log_archive_dest_11                     string
     
668. log_archive_dest_12                     string
     
669. log_archive_dest_13                     string
     
670. log_archive_dest_14                     string
     
671. log_archive_dest_15                     string
     
672. log_archive_dest_16                     string
     
673. log_archive_dest_17                     string
     
674. 
     
675. NAME                                     TYPE         VALUE
     
676. ------------------------------------ ----------- ------------------------------
     
677. log_archive_dest_18                     string
     
678. log_archive_dest_19                     string
     
679. log_archive_dest_2                     string
     
680. log_archive_dest_20                     string
     
681. log_archive_dest_21                     string
     
682. log_archive_dest_22                     string
     
683. log_archive_dest_23                     string
     
684. log_archive_dest_24                     string
     
685. log_archive_dest_25                     string
     
686. log_archive_dest_26                     string
     
687. log_archive_dest_27                     string
     
688. 
     
689. NAME                                     TYPE         VALUE
     
690. ------------------------------------ ----------- ------------------------------
     
691. log_archive_dest_28                     string
     
692. log_archive_dest_29                     string
     
693. log_archive_dest_3                     string
     
694. log_archive_dest_30                     string
     
695. log_archive_dest_31                     string
     
696. log_archive_dest_4                     string
     
697. log_archive_dest_5                     string
     
698. log_archive_dest_6                     string
     
699. log_archive_dest_7                     string
     
700. log_archive_dest_8                     string
     
701. log_archive_dest_9                     string
     
702. 
     
703. NAME                                     TYPE         VALUE
     
704. ------------------------------------ ----------- ------------------------------
     
705. log_archive_dest_state_1             string         enable
     
706. log_archive_dest_state_10             string         enable
     
707. log_archive_dest_state_11             string         enable
     
708. log_archive_dest_state_12             string         enable
     
709. log_archive_dest_state_13             string         enable
     
710. log_archive_dest_state_14             string         enable
     
711. log_archive_dest_state_15             string         enable
     
712. log_archive_dest_state_16             string         enable
     
713. log_archive_dest_state_17             string         enable
     
714. log_archive_dest_state_18             string         enable
     
715. log_archive_dest_state_19             string         enable
     
716. 
     
717. NAME                                     TYPE         VALUE
     
718. ------------------------------------ ----------- ------------------------------
     
719. log_archive_dest_state_2             string         enable
     
720. log_archive_dest_state_20             string         enable
     
721. log_archive_dest_state_21             string         enable
     
722. log_archive_dest_state_22             string         enable
     
723. log_archive_dest_state_23             string         enable
     
724. log_archive_dest_state_24             string         enable
     
725. log_archive_dest_state_25             string         enable
     
726. log_archive_dest_state_26             string         enable
     
727. log_archive_dest_state_27             string         enable
     
728. log_archive_dest_state_28             string         enable
     
729. log_archive_dest_state_29             string         enable
     
730. 
     
731. NAME                                     TYPE         VALUE
     
732. ------------------------------------ ----------- ------------------------------
     
733. log_archive_dest_state_3             string         enable
     
734. log_archive_dest_state_30             string         enable
     
735. log_archive_dest_state_31             string         enable
     
736. log_archive_dest_state_4             string         enable
     
737. log_archive_dest_state_5             string         enable
     
738. log_archive_dest_state_6             string         enable
     
739. log_archive_dest_state_7             string         enable
     
740. log_archive_dest_state_8             string         enable
     
741. log_archive_dest_state_9             string         enable
     
742. log_archive_duplex_dest              string
     
743. log_archive_format                     string         %t_%s_%r.dbf
     
744. 
     
745. NAME                                     TYPE         VALUE
     
746. ------------------------------------ ----------- ------------------------------
     
747. log_archive_local_first              boolean         TRUE
     
748. log_archive_max_processes             integer         4
     
749. log_archive_min_succeed_dest             integer         1
     
750. log_archive_start                     boolean         FALSE
     
751. log_archive_trace                     integer         0
     
752. SQL> alter system set log_archive_dest_1='location=use_db_recovery_file_dest';
     
753. 
     
754. System altered.
     
755. 
     
756. SQL> alter system set log_archive_dest_2='location=/home/oracle/archivelog';
     
757. 
     
758. System altered.
     
759. 
     
760. SQL> alter system switch logfile;
     
761. 
     
762. System altered.
     
763. 
     
764. SQL> alter system switch logfile;
     
765. 
     
766. System altered.
     
767. 
     
768. SQL> exit
     
769. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
770. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
771. and Real Application Testing options
     
772. [oracle@station90 archivelog]$ cd
     
773. [oracle@station90 ~]$ . oraenv
     
774. ORACLE_SID = [orcl] ? +ASM
     
775. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid is /u01/app/oracle
     
776. [oracle@station90 ~]$ asmcmd
     
777. ASMCMD> ls
     
778. DATA/
     
779. FRA/
     
780. ASMCMD> cd FRA/
     
781. ASMCMD> ls
     
782. ORCL/
     
783. ASMCMD> cd ORCL/
     
784. ASMCMD> ls
     
785. AUTOBACKUP/
     
786. BACKUPSET/
     
787. CHANGETRACKING/
     
788. CONTROLFILE/
     
789. DATAFILE/
     
790. ONLINELOG/
     
791. ASMCMD> exit
     
792. [oracle@station90 ~]$ cd /home
     
793. [oracle@station90 home]$ ls
     
794. guests  oracle  oradev  orawb  vncviewer  vtl
     
795. [oracle@station90 home]$ cd oracle
     
796. [oracle@station90 ~]$ ls
     
797. 3_2014-05-21-1.sql       mail            revertape-root.sh        update2_t04209_uname.sql  图片
     
798. afiedt.buf               manual_backup   select_t04209_uname.sql  update_t04209_uname.sql   文档
     
799. archivelog               oradiag_oracle  t05310.sql               公共的                    下载
     
800. copytape-root.sh         rac_tns         tnsnames.ora             模板                      音乐
     
801. create_t04209_uname.sql  rcat.sql        ttio.rcv                 视频                      桌面
     
802. [oracle@station90 ~]$ cd archivelog/
     
803. [oracle@station90 archivelog]$ l
     
804. -bash: l: command not found
     
805. [oracle@station90 archivelog]$ ls
     
806. 1_74_913410354.dbf  1_75_913410354.dbf  1_76_913410354.dbf
     
807. [oracle@station90 archivelog]$ sqlplus /nolog
     
808. 
     
809. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 14 12:48:48 2016
     
810. 
     
811. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
812. 
     
813. SQL> conn / as sysdba
     
814. Connected.
     
815. SQL> alter system switch logfile ;
     
816. alter system switch logfile
     
817. *
     
818. ERROR at line 1:
     
819. ORA-01109: database not open
     
820. 
     
821. 
     
822. SQL> exit
     
823. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
824. With the Automatic Storage Management option
     
825. [oracle@station90 archivelog]$ . oraenv
     
826. ORACLE_SID = [+ASM] ? orcl
     
827. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
     
828. [oracle@station90 archivelog]$ sqlplus /nolog
     
829. 
     
830. SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 14 12:49:08 2016
     
831. 
     
832. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
833. 
     
834. SQL> conn / as sysdba
     
835. Connected.
     
836. SQL> alter system switch logfile;
     
837. 
     
838. System altered.
     
839. 
     
840. SQL> exit
     
841. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
     
842. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
     
843. and Real Application Testing options
     
844. [oracle@station90 archivelog]$ ls
     
845. [oracle@station90 archivelog]$ pwd
     
846. /home/oracle/archivelog
     
847. 
     

复制代码

botang

botang 发表于 2016-6-13 10:54

1. [oracle@station90 archivelog]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 14 12:51:05 2016
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1343950367)
   
8. 
   
9. RMAN> delete noprompt backup;
   
10. 
    
11. using target database control file instead of recovery catalog
    
12. allocated channel: ORA_DISK_1
    
13. channel ORA_DISK_1: SID=8 device type=DISK
    
14. allocated channel: ORA_DISK_2
    
15. channel ORA_DISK_2: SID=79 device type=DISK
    
16. allocated channel: ORA_DISK_3
    
17. channel ORA_DISK_3: SID=140 device type=DISK
    
18. allocated channel: ORA_DISK_4
    
19. channel ORA_DISK_4: SID=196 device type=DISK
    
20. allocated channel: ORA_DISK_5
    
21. channel ORA_DISK_5: SID=15 device type=DISK
    
22. allocated channel: ORA_DISK_6
    
23. channel ORA_DISK_6: SID=78 device type=DISK
    
24. allocated channel: ORA_DISK_7
    
25. channel ORA_DISK_7: SID=141 device type=DISK
    
26. allocated channel: ORA_DISK_8
    
27. channel ORA_DISK_8: SID=201 device type=DISK
    
28. allocated channel: ORA_SBT_TAPE_1
    
29. channel ORA_SBT_TAPE_1: SID=16 device type=SBT_TAPE
    
30. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
31. allocated channel: ORA_SBT_TAPE_2
    
32. channel ORA_SBT_TAPE_2: SID=80 device type=SBT_TAPE
    
33. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
34. allocated channel: ORA_SBT_TAPE_3
    
35. channel ORA_SBT_TAPE_3: SID=142 device type=SBT_TAPE
    
36. channel ORA_SBT_TAPE_3: Oracle Secure Backup
    
37. allocated channel: ORA_SBT_TAPE_4
    
38. channel ORA_SBT_TAPE_4: SID=202 device type=SBT_TAPE
    
39. channel ORA_SBT_TAPE_4: Oracle Secure Backup
    
40. allocated channel: ORA_SBT_TAPE_5
    
41. channel ORA_SBT_TAPE_5: SID=17 device type=SBT_TAPE
    
42. channel ORA_SBT_TAPE_5: Oracle Secure Backup
    
43. allocated channel: ORA_SBT_TAPE_6
    
44. channel ORA_SBT_TAPE_6: SID=81 device type=SBT_TAPE
    
45. channel ORA_SBT_TAPE_6: Oracle Secure Backup
    
46. allocated channel: ORA_SBT_TAPE_7
    
47. channel ORA_SBT_TAPE_7: SID=143 device type=SBT_TAPE
    
48. channel ORA_SBT_TAPE_7: Oracle Secure Backup
    
49. allocated channel: ORA_SBT_TAPE_8
    
50. channel ORA_SBT_TAPE_8: SID=203 device type=SBT_TAPE
    
51. channel ORA_SBT_TAPE_8: Oracle Secure Backup
    
52. 
    
53. List of Backup Pieces
    
54. BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
    
55. ------- ------- --- --- ----------- ----------- ----------
    
56. 80      80      1   1   AVAILABLE   SBT_TAPE    2rr7iu9g_1_1
    
57. 82      82      1   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_08/nnndn1_ora_oem_level_0_0.279.914016939
    
58. 84      84      1   1   AVAILABLE   SBT_TAPE    2vr7lilj_1_1
    
59. 86      86      1   1   AVAILABLE   SBT_TAPE    31r7o2en_1_1
    
60. 88      88      1   1   AVAILABLE   SBT_TAPE    33r7o2ma_1_1
    
61. 91      91      1   1   AVAILABLE   DISK        +FRA/orcl/autobackup/2016_06_09/s_914101817.298.914101817
    
62. 92      92      1   1   AVAILABLE   SBT_TAPE    37r84aog_1_1
    
63. 93      93      1   1   AVAILABLE   SBT_TAPE    c-1343950367-20160614-00
    
64. 94      94      1   1   AVAILABLE   SBT_TAPE    3br84b92_1_1
    
65. 95      95      1   1   AVAILABLE   SBT_TAPE    39r84b92_1_1
    
66. 96      96      1   1   AVAILABLE   SBT_TAPE    3ar84b92_1_1
    
67. 97      97      1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3cr84bpg_1_1.bkp
    
68. 98      98      1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3dr84bpg_1_1.bkp
    
69. 99      99      1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3er84bph_1_1.bkp
    
70. 100     100     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3fr84bpi_1_1.bkp
    
71. 101     101     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3gr84bpi_1_1.bkp
    
72. 102     102     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3hr84bpj_1_1.bkp
    
73. 103     103     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3ir84bpk_1_1.bkp
    
74. 104     104     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3jr84bpk_1_1.bkp
    
75. 105     105     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3kr84bpn_1_1.bkp
    
76. 106     106     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3lr84bps_1_1.bkp
    
77. 107     107     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3rr84bpv_1_1.bkp
    
78. 108     108     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3nr84bps_1_1.bkp
    
79. 109     109     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3pr84bpu_1_1.bkp
    
80. 110     110     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3mr84bps_1_1.bkp
    
81. 111     111     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3or84bps_1_1.bkp
    
82. 112     112     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3qr84bpu_1_1.bkp
    
83. 113     113     1   1   AVAILABLE   DISK        /home/oracle/manual_backup/db_3sr84bqb_1_1.bkp
    
84. 114     114     1   1   AVAILABLE   SBT_TAPE    3tr84dsd_1_1
    
85. 115     115     1   1   AVAILABLE   SBT_TAPE    3ur84dsd_1_1
    
86. 116     116     1   1   AVAILABLE   SBT_TAPE    3vr84dsd_1_1
    
87. 117     117     1   1   AVAILABLE   SBT_TAPE    41r84e3b_1_1
    
88. 118     118     1   1   AVAILABLE   SBT_TAPE    40r84e3b_1_1
    
89. deleted backup piece
    
90. backup piece handle=+FRA/orcl/backupset/2016_06_08/nnndn1_ora_oem_level_0_0.279.914016939 RECID=82 STAMP=914016938
    
91. deleted backup piece
    
92. backup piece handle=+FRA/orcl/autobackup/2016_06_09/s_914101817.298.914101817 RECID=91 STAMP=914101817
    
93. deleted backup piece
    
94. backup piece handle=/home/oracle/manual_backup/db_3cr84bpg_1_1.bkp RECID=97 STAMP=914501424
    
95. deleted backup piece
    
96. backup piece handle=/home/oracle/manual_backup/db_3dr84bpg_1_1.bkp RECID=98 STAMP=914501425
    
97. deleted backup piece
    
98. backup piece handle=/home/oracle/manual_backup/db_3er84bph_1_1.bkp RECID=99 STAMP=914501426
    
99. deleted backup piece
    
100. backup piece handle=/home/oracle/manual_backup/db_3fr84bpi_1_1.bkp RECID=100 STAMP=914501426
     
101. deleted backup piece
     
102. backup piece handle=/home/oracle/manual_backup/db_3gr84bpi_1_1.bkp RECID=101 STAMP=914501427
     
103. deleted backup piece
     
104. backup piece handle=/home/oracle/manual_backup/db_3hr84bpj_1_1.bkp RECID=102 STAMP=914501427
     
105. deleted backup piece
     
106. backup piece handle=/home/oracle/manual_backup/db_3ir84bpk_1_1.bkp RECID=103 STAMP=914501428
     
107. deleted backup piece
     
108. backup piece handle=/home/oracle/manual_backup/db_3jr84bpk_1_1.bkp RECID=104 STAMP=914501429
     
109. deleted backup piece
     
110. backup piece handle=/home/oracle/manual_backup/db_3kr84bpn_1_1.bkp RECID=105 STAMP=914501431
     
111. deleted backup piece
     
112. backup piece handle=/home/oracle/manual_backup/db_3lr84bps_1_1.bkp RECID=106 STAMP=914501436
     
113. deleted backup piece
     
114. backup piece handle=/home/oracle/manual_backup/db_3rr84bpv_1_1.bkp RECID=107 STAMP=914501440
     
115. deleted backup piece
     
116. backup piece handle=/home/oracle/manual_backup/db_3nr84bps_1_1.bkp RECID=108 STAMP=914501443
     
117. deleted backup piece
     
118. backup piece handle=/home/oracle/manual_backup/db_3pr84bpu_1_1.bkp RECID=109 STAMP=914501443
     
119. deleted backup piece
     
120. backup piece handle=/home/oracle/manual_backup/db_3mr84bps_1_1.bkp RECID=110 STAMP=914501443
     
121. deleted backup piece
     
122. backup piece handle=/home/oracle/manual_backup/db_3or84bps_1_1.bkp RECID=111 STAMP=914501444
     
123. deleted backup piece
     
124. backup piece handle=/home/oracle/manual_backup/db_3qr84bpu_1_1.bkp RECID=112 STAMP=914501447
     
125. deleted backup piece
     
126. backup piece handle=/home/oracle/manual_backup/db_3sr84bqb_1_1.bkp RECID=113 STAMP=914501451
     
127. Deleted 19 objects
     
128. 
     
129. deleted backup piece
     
130. backup piece handle=2rr7iu9g_1_1 RECID=80 STAMP=913930544
     
131. deleted backup piece
     
132. backup piece handle=2vr7lilj_1_1 RECID=84 STAMP=914016947
     
133. deleted backup piece
     
134. backup piece handle=31r7o2en_1_1 RECID=86 STAMP=914098648
     
135. deleted backup piece
     
136. backup piece handle=33r7o2ma_1_1 RECID=88 STAMP=914098890
     
137. deleted backup piece
     
138. backup piece handle=37r84aog_1_1 RECID=92 STAMP=914500369
     
139. deleted backup piece
     
140. backup piece handle=c-1343950367-20160614-00 RECID=93 STAMP=914500418
     
141. deleted backup piece
     
142. backup piece handle=3br84b92_1_1 RECID=94 STAMP=914500898
     
143. deleted backup piece
     
144. backup piece handle=39r84b92_1_1 RECID=95 STAMP=914500899
     
145. deleted backup piece
     
146. backup piece handle=3ar84b92_1_1 RECID=96 STAMP=914500899
     
147. deleted backup piece
     
148. backup piece handle=3tr84dsd_1_1 RECID=114 STAMP=914503565
     
149. deleted backup piece
     
150. backup piece handle=3ur84dsd_1_1 RECID=115 STAMP=914503565
     
151. deleted backup piece
     
152. backup piece handle=3vr84dsd_1_1 RECID=116 STAMP=914503565
     
153. deleted backup piece
     
154. backup piece handle=41r84e3b_1_1 RECID=117 STAMP=914503787
     
155. deleted backup piece
     
156. backup piece handle=40r84e3b_1_1 RECID=118 STAMP=914503787
     
157. Deleted 14 objects
     
158. 
     
159. 
     
160. RMAN> delete noprompt copy;
     
161. 
     
162. released channel: ORA_DISK_1
     
163. released channel: ORA_DISK_2
     
164. released channel: ORA_DISK_3
     
165. released channel: ORA_DISK_4
     
166. released channel: ORA_DISK_5
     
167. released channel: ORA_DISK_6
     
168. released channel: ORA_DISK_7
     
169. released channel: ORA_DISK_8
     
170. released channel: ORA_SBT_TAPE_1
     
171. released channel: ORA_SBT_TAPE_2
     
172. released channel: ORA_SBT_TAPE_3
     
173. released channel: ORA_SBT_TAPE_4
     
174. released channel: ORA_SBT_TAPE_5
     
175. released channel: ORA_SBT_TAPE_6
     
176. released channel: ORA_SBT_TAPE_7
     
177. released channel: ORA_SBT_TAPE_8
     
178. allocated channel: ORA_DISK_1
     
179. channel ORA_DISK_1: SID=8 device type=DISK
     
180. allocated channel: ORA_DISK_2
     
181. channel ORA_DISK_2: SID=79 device type=DISK
     
182. allocated channel: ORA_DISK_3
     
183. channel ORA_DISK_3: SID=140 device type=DISK
     
184. allocated channel: ORA_DISK_4
     
185. channel ORA_DISK_4: SID=196 device type=DISK
     
186. allocated channel: ORA_DISK_5
     
187. channel ORA_DISK_5: SID=15 device type=DISK
     
188. allocated channel: ORA_DISK_6
     
189. channel ORA_DISK_6: SID=78 device type=DISK
     
190. allocated channel: ORA_DISK_7
     
191. channel ORA_DISK_7: SID=141 device type=DISK
     
192. allocated channel: ORA_DISK_8
     
193. channel ORA_DISK_8: SID=201 device type=DISK
     
194. specification does not match any control file copy in the repository
     
195. specification does not match any archived log in the repository
     
196. List of Datafile Copies
     
197. =======================
     
198. 
     
199. Key     File S Completion Time Ckp SCN    Ckp Time      
     
200. ------- ---- - --------------- ---------- ---------------
     
201. 27      1    A 08-JUN-16       1547159    07-JUN-16      
     
202.         Name: +FRA/orcl/datafile/system.268.913844129
     
203.         Tag: ORA_OEM_LEVEL_0
     
204. 
     
205. 28      2    A 08-JUN-16       1547159    07-JUN-16      
     
206.         Name: +FRA/orcl/datafile/sysaux.267.913844145
     
207.         Tag: ORA_OEM_LEVEL_0
     
208. 
     
209. 26      3    A 08-JUN-16       1547159    07-JUN-16      
     
210.         Name: +FRA/orcl/datafile/undotbs1.287.913844159
     
211.         Tag: ORA_OEM_LEVEL_0
     
212. 
     
213. 25      5    A 08-JUN-16       1547159    07-JUN-16      
     
214.         Name: +FRA/orcl/datafile/example.269.913844163
     
215.         Tag: ORA_OEM_LEVEL_0
     
216. 
     
217. deleted datafile copy
     
218. datafile copy file name=+FRA/orcl/datafile/sysaux.267.913844145 RECID=28 STAMP=914016933
     
219. deleted datafile copy
     
220. datafile copy file name=+FRA/orcl/datafile/undotbs1.287.913844159 RECID=26 STAMP=914016932
     
221. deleted datafile copy
     
222. datafile copy file name=+FRA/orcl/datafile/example.269.913844163 RECID=25 STAMP=914016932
     
223. Deleted 3 objects
     
224. 
     
225. 
     
226. RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
     
227. RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
     
228. RMAN-06210: List of Mismatched objects
     
229. RMAN-06211: ==========================
     
230. RMAN-06212:   Object Type   Filename/Handle
     
231. RMAN-06213: --------------- ---------------------------------------------------
     
232. RMAN-06214: Datafile Copy   +FRA/orcl/datafile/system.268.913844129
     
233. 
     
234. 
     
235. RMAN> crosscheck copy;
     
236. 
     
237. released channel: ORA_DISK_1
     
238. released channel: ORA_DISK_2
     
239. released channel: ORA_DISK_3
     
240. released channel: ORA_DISK_4
     
241. released channel: ORA_DISK_5
     
242. released channel: ORA_DISK_6
     
243. released channel: ORA_DISK_7
     
244. released channel: ORA_DISK_8
     
245. allocated channel: ORA_DISK_1
     
246. channel ORA_DISK_1: SID=8 device type=DISK
     
247. allocated channel: ORA_DISK_2
     
248. channel ORA_DISK_2: SID=79 device type=DISK
     
249. allocated channel: ORA_DISK_3
     
250. channel ORA_DISK_3: SID=140 device type=DISK
     
251. allocated channel: ORA_DISK_4
     
252. channel ORA_DISK_4: SID=196 device type=DISK
     
253. allocated channel: ORA_DISK_5
     
254. channel ORA_DISK_5: SID=15 device type=DISK
     
255. allocated channel: ORA_DISK_6
     
256. channel ORA_DISK_6: SID=78 device type=DISK
     
257. allocated channel: ORA_DISK_7
     
258. channel ORA_DISK_7: SID=141 device type=DISK
     
259. allocated channel: ORA_DISK_8
     
260. channel ORA_DISK_8: SID=201 device type=DISK
     
261. specification does not match any control file copy in the repository
     
262. specification does not match any archived log in the repository
     
263. validation failed for datafile copy
     
264. datafile copy file name=+FRA/orcl/datafile/system.268.913844129 RECID=27 STAMP=914016932
     
265. Crosschecked 1 objects
     
266. 
     
267. 
     
268. RMAN> delete expired copy;
     
269. 
     
270. released channel: ORA_DISK_1
     
271. released channel: ORA_DISK_2
     
272. released channel: ORA_DISK_3
     
273. released channel: ORA_DISK_4
     
274. released channel: ORA_DISK_5
     
275. released channel: ORA_DISK_6
     
276. released channel: ORA_DISK_7
     
277. released channel: ORA_DISK_8
     
278. allocated channel: ORA_DISK_1
     
279. channel ORA_DISK_1: SID=8 device type=DISK
     
280. allocated channel: ORA_DISK_2
     
281. channel ORA_DISK_2: SID=79 device type=DISK
     
282. allocated channel: ORA_DISK_3
     
283. channel ORA_DISK_3: SID=140 device type=DISK
     
284. allocated channel: ORA_DISK_4
     
285. channel ORA_DISK_4: SID=196 device type=DISK
     
286. allocated channel: ORA_DISK_5
     
287. channel ORA_DISK_5: SID=15 device type=DISK
     
288. allocated channel: ORA_DISK_6
     
289. channel ORA_DISK_6: SID=78 device type=DISK
     
290. allocated channel: ORA_DISK_7
     
291. channel ORA_DISK_7: SID=141 device type=DISK
     
292. allocated channel: ORA_DISK_8
     
293. channel ORA_DISK_8: SID=201 device type=DISK
     
294. specification does not match any control file copy in the repository
     
295. specification does not match any archived log in the repository
     
296. List of Datafile Copies
     
297. =======================
     
298. 
     
299. Key     File S Completion Time Ckp SCN    Ckp Time      
     
300. ------- ---- - --------------- ---------- ---------------
     
301. 27      1    X 08-JUN-16       1547159    07-JUN-16      
     
302.         Name: +FRA/orcl/datafile/system.268.913844129
     
303.         Tag: ORA_OEM_LEVEL_0
     
304. 
     
305. 
     
306. Do you really want to delete the above objects (enter YES or NO)? YES
     
307. deleted datafile copy
     
308. datafile copy file name=+FRA/orcl/datafile/system.268.913844129 RECID=27 STAMP=914016932
     
309. Deleted 1 EXPIRED objects
     
310. 
     
311. 
     
312. RMAN> list copy;
     
313. 
     
314. specification does not match any datafile copy in the repository
     
315. specification does not match any control file copy in the repository
     
316. specification does not match any archived log in the repository
     
317. 
     
318. RMAN> list backup;
     
319. 
     
320. specification does not match any backup in the repository
     
321. 
     
322. RMAN> show all;
     
323. 
     
324. RMAN configuration parameters for database with db_unique_name ORCL are:
     
325. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
     
326. CONFIGURE BACKUP OPTIMIZATION ON;
     
327. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
     
328. CONFIGURE CONTROLFILE AUTOBACKUP OFF;
     
329. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
     
330. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
     
331. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
     
332. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
     
333. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
334. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
335. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
336. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
337. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
338. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
339. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
340. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
341. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
342. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
343. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
344. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
345. CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
346. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
     
347. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
     
348. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
     
349. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
     
350. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
     
351. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
     
352. 
     
353. RMAN> backup tag '1T_WHOLE_INCR0'   incremental level 0 database ;
     
354. 
     
355. Starting backup at 14-JUN-16
     
356. released channel: ORA_DISK_1
     
357. released channel: ORA_DISK_2
     
358. released channel: ORA_DISK_3
     
359. released channel: ORA_DISK_4
     
360. released channel: ORA_DISK_5
     
361. released channel: ORA_DISK_6
     
362. released channel: ORA_DISK_7
     
363. released channel: ORA_DISK_8
     
364. allocated channel: ORA_SBT_TAPE_1
     
365. channel ORA_SBT_TAPE_1: SID=8 device type=SBT_TAPE
     
366. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
367. allocated channel: ORA_SBT_TAPE_2
     
368. channel ORA_SBT_TAPE_2: SID=79 device type=SBT_TAPE
     
369. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
370. allocated channel: ORA_SBT_TAPE_3
     
371. channel ORA_SBT_TAPE_3: SID=140 device type=SBT_TAPE
     
372. channel ORA_SBT_TAPE_3: Oracle Secure Backup
     
373. allocated channel: ORA_SBT_TAPE_4
     
374. channel ORA_SBT_TAPE_4: SID=196 device type=SBT_TAPE
     
375. channel ORA_SBT_TAPE_4: Oracle Secure Backup
     
376. allocated channel: ORA_SBT_TAPE_5
     
377. channel ORA_SBT_TAPE_5: SID=15 device type=SBT_TAPE
     
378. channel ORA_SBT_TAPE_5: Oracle Secure Backup
     
379. allocated channel: ORA_SBT_TAPE_6
     
380. channel ORA_SBT_TAPE_6: SID=78 device type=SBT_TAPE
     
381. channel ORA_SBT_TAPE_6: Oracle Secure Backup
     
382. allocated channel: ORA_SBT_TAPE_7
     
383. channel ORA_SBT_TAPE_7: SID=141 device type=SBT_TAPE
     
384. channel ORA_SBT_TAPE_7: Oracle Secure Backup
     
385. allocated channel: ORA_SBT_TAPE_8
     
386. channel ORA_SBT_TAPE_8: SID=201 device type=SBT_TAPE
     
387. channel ORA_SBT_TAPE_8: Oracle Secure Backup
     
388. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
     
389. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
390. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.914102913
     
391. channel ORA_SBT_TAPE_1: starting piece 1 at 14-JUN-16
     
392. channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
     
393. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
     
394. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
     
395. channel ORA_SBT_TAPE_2: starting piece 1 at 14-JUN-16
     
396. channel ORA_SBT_TAPE_3: starting incremental level 0 datafile backup set
     
397. channel ORA_SBT_TAPE_3: specifying datafile(s) in backup set
     
398. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
     
399. channel ORA_SBT_TAPE_3: starting piece 1 at 14-JUN-16
     
400. channel ORA_SBT_TAPE_4: starting incremental level 0 datafile backup set
     
401. channel ORA_SBT_TAPE_4: specifying datafile(s) in backup set
     
402. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
     
403. channel ORA_SBT_TAPE_4: starting piece 1 at 14-JUN-16
     
404. channel ORA_SBT_TAPE_5: starting incremental level 0 datafile backup set
     
405. channel ORA_SBT_TAPE_5: specifying datafile(s) in backup set
     
406. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
     
407. channel ORA_SBT_TAPE_5: starting piece 1 at 14-JUN-16
     
408. channel ORA_SBT_TAPE_6: starting incremental level 0 datafile backup set
     
409. channel ORA_SBT_TAPE_6: specifying datafile(s) in backup set
     
410. channel ORA_SBT_TAPE_7: starting incremental level 0 datafile backup set
     
411. channel ORA_SBT_TAPE_7: specifying datafile(s) in backup set
     
412. including current SPFILE in backup set
     
413. channel ORA_SBT_TAPE_7: starting piece 1 at 14-JUN-16
     
414. including current control file in backup set
     
415. channel ORA_SBT_TAPE_6: starting piece 1 at 14-JUN-16
     
416. channel ORA_SBT_TAPE_7: finished piece 1 at 14-JUN-16
     
417. piece handle=48r84eav_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
     
418. channel ORA_SBT_TAPE_7: backup set complete, elapsed time: 00:00:26
     
419. channel ORA_SBT_TAPE_1: finished piece 1 at 14-JUN-16
     
420. piece handle=42r84eau_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
     
421. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:17
     
422. channel ORA_SBT_TAPE_5: finished piece 1 at 14-JUN-16
     
423. piece handle=46r84eau_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
     
424. channel ORA_SBT_TAPE_5: backup set complete, elapsed time: 00:01:36
     
425. channel ORA_SBT_TAPE_2: finished piece 1 at 14-JUN-16
     
426. piece handle=43r84eau_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
     
427. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:01:57
     
428. channel ORA_SBT_TAPE_4: finished piece 1 at 14-JUN-16
     
429. piece handle=45r84eau_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
     
430. channel ORA_SBT_TAPE_4: backup set complete, elapsed time: 00:02:17
     
431. channel ORA_SBT_TAPE_6: finished piece 1 at 14-JUN-16
     
432. piece handle=47r84eav_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
     
433. channel ORA_SBT_TAPE_6: backup set complete, elapsed time: 00:02:15
     
434. channel ORA_SBT_TAPE_3: finished piece 1 at 14-JUN-16
     
435. piece handle=44r84eau_1_1 tag=1T_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
     
436. channel ORA_SBT_TAPE_3: backup set complete, elapsed time: 00:02:37
     
437. Finished backup at 14-JUN-16
     
438. 
     
439. 
     

复制代码