课程第33次

botang

RMAN加密的dual模式，仍然需要打开wallet，如果wallet没有开，就会报如下错误：

1. [oracle@station76 wallet]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.4.0 - Production on Fri Dec 20 20:32:16 2019
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1554722616)
   
8. 
   
9. RMAN> set encryption identified by "java123456" ;
   
10. 
    
11. executing command: SET encryption
    
12. using target database control file instead of recovery catalog
    
13. 
    
14. RMAN> backup tag '1T_USERS_FULL'  tablespace users;
    
15. 
    
16. Starting backup at 2019-12-20:20:33:06
    
17. allocated channel: ORA_SBT_TAPE_1
    
18. channel ORA_SBT_TAPE_1: SID=203 device type=SBT_TAPE
    
19. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
20. allocated channel: ORA_SBT_TAPE_2
    
21. channel ORA_SBT_TAPE_2: SID=70 device type=SBT_TAPE
    
22. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
23. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
24. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
25. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.1026941797
    
26. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:20:33:37
    
27. RMAN-00571: ===========================================================
    
28. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
29. RMAN-00571: ===========================================================
    
30. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 12/20/2019 20:33:39
    
31. ORA-19914: unable to encrypt backup
    
32. ORA-28365: wallet is not open
    
33. 
    
34. RMAN>

复制代码

如果使用密码方式加密，那么即使主密钥没有开，也不会报错，就只使用临时口令（set encryption identified by "java123456" only）。
如果使用TDE，那就不用口令。
得出推论：生产环境没有人使用以上两种模式，都是使用双重模式。

1. Last login: Fri Dec 20 20:37:25 2019 from station41.example.com
   
2. [root@station76 ~]# su - oracle
   
3. [oracle@station76 ~]$ rman target /
   
4. 
   
5. Recovery Manager: Release 11.2.0.4.0 - Production on Fri Dec 20 20:42:51 2019
   
6. 
   
7. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
8. 
   
9. connected to target database: ORCL (DBID=1554722616)
   
10. 
    
11. RMAN>  set encryption identified by "java123456" only;
    
12. 
    
13. executing command: SET encryption
    
14. using target database control file instead of recovery catalog
    
15. 
    
16. RMAN>  backup tag '1T_USERS_FULL'  tablespace users;
    
17. 
    
18. Starting backup at 2019-12-20:20:44:01
    
19. allocated channel: ORA_SBT_TAPE_1
    
20. channel ORA_SBT_TAPE_1: SID=5 device type=SBT_TAPE
    
21. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
22. allocated channel: ORA_SBT_TAPE_2
    
23. channel ORA_SBT_TAPE_2: SID=76 device type=SBT_TAPE
    
24. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
25. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
26. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
27. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.1026941797
    
28. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:20:44:19
    
29. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:20:44:54
    
30. piece handle=2buju4d3_1_1 tag=1T_USERS_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
31. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
    
32. Finished backup at 2019-12-20:20:44:54
    
33. 
    
34. RMAN> exit
    
35. 
    
36. 
    
37. Recovery Manager complete.
    
38. [oracle@station76 ~]$ rman target /
    
39. 
    
40. Recovery Manager: Release 11.2.0.4.0 - Production on Fri Dec 20 20:45:41 2019
    
41. 
    
42. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
    
43. 
    
44. connected to target database: ORCL (DBID=1554722616)
    
45. 
    
46. RMAN>  backup tag  '2T_USERS_FULL' tablespace users;
    
47. 
    
48. Starting backup at 2019-12-20:20:46:02
    
49. using target database control file instead of recovery catalog
    
50. allocated channel: ORA_SBT_TAPE_1
    
51. channel ORA_SBT_TAPE_1: SID=76 device type=SBT_TAPE
    
52. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
53. allocated channel: ORA_SBT_TAPE_2
    
54. channel ORA_SBT_TAPE_2: SID=70 device type=SBT_TAPE
    
55. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
56. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
57. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
58. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.1026941797
    
59. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:20:46:26
    
60. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:20:47:01
    
61. piece handle=2cuju4h1_1_1 tag=2T_USERS_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
62. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
    
63. Finished backup at 2019-12-20:20:47:01
    
64. 
    
65. RMAN> restore tablespace users ;
    
66. 
    
67. Starting restore at 2019-12-20:20:55:07
    
68. allocated channel: ORA_DISK_1
    
69. channel ORA_DISK_1: SID=17 device type=DISK
    
70. allocated channel: ORA_DISK_2
    
71. channel ORA_DISK_2: SID=5 device type=DISK
    
72. allocated channel: ORA_DISK_3
    
73. channel ORA_DISK_3: SID=204 device type=DISK
    
74. allocated channel: ORA_DISK_4
    
75. channel ORA_DISK_4: SID=12 device type=DISK
    
76. allocated channel: ORA_DISK_5
    
77. channel ORA_DISK_5: SID=77 device type=DISK
    
78. allocated channel: ORA_DISK_6
    
79. channel ORA_DISK_6: SID=141 device type=DISK
    
80. allocated channel: ORA_DISK_7
    
81. channel ORA_DISK_7: SID=206 device type=DISK
    
82. allocated channel: ORA_DISK_8
    
83. channel ORA_DISK_8: SID=14 device type=DISK
    
84. using channel ORA_SBT_TAPE_1
    
85. using channel ORA_SBT_TAPE_2
    
86. 
    
87. channel ORA_SBT_TAPE_1: starting datafile backup set restore
    
88. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
    
89. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.265.1026941797
    
90. channel ORA_SBT_TAPE_1: reading from backup piece 2cuju4h1_1_1
    
91. RMAN-00571: ===========================================================
    
92. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
93. RMAN-00571: ===========================================================
    
94. RMAN-03002: failure of restore command at 12/20/2019 20:56:05
    
95. ORA-19870: error while restoring backup piece 2cuju4h1_1_1
    
96. ORA-19913: unable to decrypt backup
    
97. ORA-28365: wallet is not open
    
98. 
    
99. RMAN> list backup;
    
100. 
     
101. 
     
102. List of Backup Sets
     
103. ===================
     
104. 
     
105. 
     
106. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
107. ------- ---- -- ---------- ----------- ------------ -------------------
     
108. 63      Full    1.50M      SBT_TAPE    00:00:26     2019-12-20:20:44:45
     
109.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: 1T_USERS_FULL
     
110.         Handle: 2buju4d3_1_1   Media: station76-000053
     
111.   List of Datafiles in backup set 63
     
112.   File LV Type Ckp SCN    Ckp Time            Name
     
113.   ---- -- ---- ---------- ------------------- ----
     
114.   4       Full 1286715    2019-12-20:20:44:19 +DATA/orcl/datafile/users.265.1026941797
     
115. 
     
116. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
117. ------- ---- -- ---------- ----------- ------------ -------------------
     
118. 64      Full    1.50M      SBT_TAPE    00:00:32     2019-12-20:20:46:57
     
119.         BP Key: 79   Status: AVAILABLE  Compressed: NO  Tag: 2T_USERS_FULL
     
120.         Handle: 2cuju4h1_1_1   Media: station76-000053
     
121.   List of Datafiles in backup set 64
     
122.   File LV Type Ckp SCN    Ckp Time            Name
     
123.   ---- -- ---- ---------- ------------------- ----
     
124.   4       Full 1286844    2019-12-20:20:46:26 +DATA/orcl/datafile/users.265.1026941797
     
125. 
     
126. RMAN>  set decryption identified by "oracle123456","java123456";
     
127. 
     
128. executing command: SET decryption
     
129. 
     
130. RMAN> restore tablespace users ;
     
131. 
     
132. Starting restore at 2019-12-20:20:57:27
     
133. using channel ORA_DISK_1
     
134. using channel ORA_DISK_2
     
135. using channel ORA_DISK_3
     
136. using channel ORA_DISK_4
     
137. using channel ORA_DISK_5
     
138. using channel ORA_DISK_6
     
139. using channel ORA_DISK_7
     
140. using channel ORA_DISK_8
     
141. using channel ORA_SBT_TAPE_1
     
142. using channel ORA_SBT_TAPE_2
     
143. 
     
144. channel ORA_SBT_TAPE_1: starting datafile backup set restore
     
145. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
     
146. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.265.1026941797
     
147. channel ORA_SBT_TAPE_1: reading from backup piece 2cuju4h1_1_1
     
148. RMAN-00571: ===========================================================
     
149. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
150. RMAN-00571: ===========================================================
     
151. RMAN-03002: failure of restore command at 12/20/2019 20:58:06
     
152. ORA-19870: error while restoring backup piece 2cuju4h1_1_1
     
153. ORA-19913: unable to decrypt backup
     
154. ORA-28365: wallet is not open
     
155. 
     
156. RMAN> list backup of tablespace users;
     
157. 
     
158. 
     
159. List of Backup Sets
     
160. ===================
     
161. 
     
162. 
     
163. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
164. ------- ---- -- ---------- ----------- ------------ -------------------
     
165. 63      Full    1.50M      SBT_TAPE    00:00:26     2019-12-20:20:44:45
     
166.         BP Key: 78   Status: AVAILABLE  Compressed: NO  Tag: 1T_USERS_FULL
     
167.         Handle: 2buju4d3_1_1   Media: station76-000053
     
168.   List of Datafiles in backup set 63
     
169.   File LV Type Ckp SCN    Ckp Time            Name
     
170.   ---- -- ---- ---------- ------------------- ----
     
171.   4       Full 1286715    2019-12-20:20:44:19 +DATA/orcl/datafile/users.265.1026941797
     
172. 
     
173. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
174. ------- ---- -- ---------- ----------- ------------ -------------------
     
175. 64      Full    1.50M      SBT_TAPE    00:00:32     2019-12-20:20:46:57
     
176.         BP Key: 79   Status: AVAILABLE  Compressed: NO  Tag: 2T_USERS_FULL
     
177.         Handle: 2cuju4h1_1_1   Media: station76-000053
     
178.   List of Datafiles in backup set 64
     
179.   File LV Type Ckp SCN    Ckp Time            Name
     
180.   ---- -- ---- ---------- ------------------- ----
     
181.   4       Full 1286844    2019-12-20:20:46:26 +DATA/orcl/datafile/users.265.1026941797
     
182. 
     
183. RMAN> restore tablespace users from tag '1T_USERS_FULL';
     
184. 
     
185. Starting restore at 2019-12-20:20:58:45
     
186. using channel ORA_DISK_1
     
187. using channel ORA_DISK_2
     
188. using channel ORA_DISK_3
     
189. using channel ORA_DISK_4
     
190. using channel ORA_DISK_5
     
191. using channel ORA_DISK_6
     
192. using channel ORA_DISK_7
     
193. using channel ORA_DISK_8
     
194. using channel ORA_SBT_TAPE_1
     
195. using channel ORA_SBT_TAPE_2
     
196. 
     
197. channel ORA_SBT_TAPE_1: starting datafile backup set restore
     
198. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
     
199. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.265.1026941797
     
200. channel ORA_SBT_TAPE_1: reading from backup piece 2buju4d3_1_1
     
201. channel ORA_SBT_TAPE_1: piece handle=2buju4d3_1_1 tag=1T_USERS_FULL
     
202. channel ORA_SBT_TAPE_1: restored backup piece 1
     
203. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
     
204. Finished restore at 2019-12-20:20:59:23
     
205. 
     
206. RMAN> exit
     
207. 
     
208. 
     
209. Recovery Manager complete.
     
210. [oracle@station76 ~]$ rman target /
     
211. 
     
212. Recovery Manager: Release 11.2.0.4.0 - Production on Fri Dec 20 20:59:56 2019
     
213. 
     
214. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
     
215. 
     
216. connected to target database: ORCL (DBID=1554722616)
     
217. 
     
218. RMAN> set decryption identified by "xxxx123456";
     
219. 
     
220. executing command: SET decryption
     
221. using target database control file instead of recovery catalog
     
222. 
     
223. RMAN> restore tablespace users from tag '1T_USERS_FULL';
     
224. 
     
225. Starting restore at 2019-12-20:21:00:42
     
226. allocated channel: ORA_DISK_1
     
227. channel ORA_DISK_1: SID=14 device type=DISK
     
228. allocated channel: ORA_DISK_2
     
229. channel ORA_DISK_2: SID=76 device type=DISK
     
230. allocated channel: ORA_DISK_3
     
231. channel ORA_DISK_3: SID=144 device type=DISK
     
232. allocated channel: ORA_DISK_4
     
233. channel ORA_DISK_4: SID=12 device type=DISK
     
234. allocated channel: ORA_DISK_5
     
235. channel ORA_DISK_5: SID=77 device type=DISK
     
236. allocated channel: ORA_DISK_6
     
237. channel ORA_DISK_6: SID=17 device type=DISK
     
238. allocated channel: ORA_DISK_7
     
239. channel ORA_DISK_7: SID=82 device type=DISK
     
240. allocated channel: ORA_DISK_8
     
241. channel ORA_DISK_8: SID=141 device type=DISK
     
242. allocated channel: ORA_SBT_TAPE_1
     
243. channel ORA_SBT_TAPE_1: SID=206 device type=SBT_TAPE
     
244. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
245. allocated channel: ORA_SBT_TAPE_2
     
246. channel ORA_SBT_TAPE_2: SID=204 device type=SBT_TAPE
     
247. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
248. 
     
249. channel ORA_SBT_TAPE_1: starting datafile backup set restore
     
250. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
     
251. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.265.1027544353
     
252. channel ORA_SBT_TAPE_1: reading from backup piece 2buju4d3_1_1
     
253. RMAN-00571: ===========================================================
     
254. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
255. RMAN-00571: ===========================================================
     
256. RMAN-03002: failure of restore command at 12/20/2019 21:01:58
     
257. ORA-19870: error while restoring backup piece 2buju4d3_1_1
     
258. ORA-19913: unable to decrypt backup
     
259. ORA-28365: wallet is not open
     
260. 
     
261. RMAN>  set decryption identified by "xxxx123456","java123456";
     
262. 
     
263. executing command: SET decryption
     
264. 
     
265. RMAN> restore tablespace users from tag '1T_USERS_FULL';
     
266. 
     
267. Starting restore at 2019-12-20:21:02:21
     
268. using channel ORA_DISK_1
     
269. using channel ORA_DISK_2
     
270. using channel ORA_DISK_3
     
271. using channel ORA_DISK_4
     
272. using channel ORA_DISK_5
     
273. using channel ORA_DISK_6
     
274. using channel ORA_DISK_7
     
275. using channel ORA_DISK_8
     
276. using channel ORA_SBT_TAPE_1
     
277. using channel ORA_SBT_TAPE_2
     
278. 
     
279. channel ORA_SBT_TAPE_1: starting datafile backup set restore
     
280. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
     
281. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.265.1027544353
     
282. channel ORA_SBT_TAPE_1: reading from backup piece 2buju4d3_1_1
     
283. channel ORA_SBT_TAPE_1: piece handle=2buju4d3_1_1 tag=1T_USERS_FULL
     
284. channel ORA_SBT_TAPE_1: restored backup piece 1
     
285. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
     
286. Finished restore at 2019-12-20:21:03:09
     
287. 
     
288. RMAN> recover tablespace users;
     
289. 
     
290. Starting recover at 2019-12-20:21:03:33
     
291. using channel ORA_DISK_1
     
292. using channel ORA_DISK_2
     
293. using channel ORA_DISK_3
     
294. using channel ORA_DISK_4
     
295. using channel ORA_DISK_5
     
296. using channel ORA_DISK_6
     
297. using channel ORA_DISK_7
     
298. using channel ORA_DISK_8
     
299. using channel ORA_SBT_TAPE_1
     
300. using channel ORA_SBT_TAPE_2
     
301. 
     
302. starting media recovery
     
303. 
     
304. archived log for thread 1 with sequence 29 is already on disk as file +FRA/orcl/archivelog/2019_12_20/thread_1_seq_29.492.1027543835
     
305. archived log for thread 1 with sequence 30 is already on disk as file +FRA/orcl/archivelog/2019_12_20/thread_1_seq_30.277.1027543835
     
306. archived log for thread 1 with sequence 31 is already on disk as file +FRA/orcl/archivelog/2019_12_20/thread_1_seq_31.483.1027543837
     
307. archived log for thread 1 with sequence 32 is already on disk as file +FRA/orcl/archivelog/2019_12_20/thread_1_seq_32.496.1027543837
     
308. archived log for thread 1 with sequence 33 is already on disk as file +FRA/orcl/archivelog/2019_12_20/thread_1_seq_33.514.1027543837
     
309. archived log for thread 1 with sequence 34 is already on disk as file +FRA/orcl/archivelog/2019_12_20/thread_1_seq_34.484.1027543839
     
310. archived log file name=+FRA/orcl/archivelog/2019_12_20/thread_1_seq_29.492.1027543835 thread=1 sequence=29
     
311. archived log file name=+FRA/orcl/archivelog/2019_12_20/thread_1_seq_30.277.1027543835 thread=1 sequence=30
     
312. archived log file name=+FRA/orcl/archivelog/2019_12_20/thread_1_seq_31.483.1027543837 thread=1 sequence=31
     
313. archived log file name=+FRA/orcl/archivelog/2019_12_20/thread_1_seq_32.496.1027543837 thread=1 sequence=32
     
314. media recovery complete, elapsed time: 00:00:01
     
315. Finished recover at 2019-12-20:21:03:39
     
316. 
     
317. RMAN>

复制代码

归档性备份：

1. RMAN> backup tag '3T_WHOLE_FULL' database keep until time 'sysdate+60' restore point rsp_archive1;
   
2. 
   
3. Starting backup at 2019-12-20:21:50:45
   
4. current log archived
   
5. 
   
6. using channel ORA_SBT_TAPE_1
   
7. using channel ORA_SBT_TAPE_2
   
8. backup will be obsolete on date 2020-02-18:21:50:48
   
9. archived logs required to recover from this backup will be backed up
   
10. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
11. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
12. input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
    
13. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.1027544577
    
14. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:21:50:51
    
15. channel ORA_SBT_TAPE_2: starting full datafile backup set
    
16. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
    
17. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.282.1026941797
    
18. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.281.1026941797
    
19. channel ORA_SBT_TAPE_2: starting piece 1 at 2019-12-20:21:50:52
    
20. channel ORA_SBT_TAPE_2: finished piece 1 at 2019-12-20:21:53:27
    
21. piece handle=2ouju89r_1_1 tag=3T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
22. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:02:35
    
23. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:21:53:37
    
24. piece handle=2nuju89r_1_1 tag=3T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
25. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:02:46
    
26. 
    
27. using channel ORA_SBT_TAPE_1
    
28. using channel ORA_SBT_TAPE_2
    
29. backup will be obsolete on date 2020-02-18:21:53:39
    
30. archived logs required to recover from this backup will be backed up
    
31. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
32. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
33. including current SPFILE in backup set
    
34. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:21:53:42
    
35. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:21:54:28
    
36. piece handle=2puju8f6_1_1 tag=3T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
37. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:46
    
38. 
    
39. 
    
40. current log archived
    
41. using channel ORA_SBT_TAPE_1
    
42. using channel ORA_SBT_TAPE_2
    
43. backup will be obsolete on date 2020-02-18:21:54:32
    
44. archived logs required to recover from this backup will be backed up
    
45. channel ORA_SBT_TAPE_1: starting archived log backup set
    
46. channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
    
47. input archived log thread=1 sequence=36 RECID=31 STAMP=1027547671
    
48. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:21:54:34
    
49. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:21:54:59
    
50. piece handle=2quju8gp_1_1 tag=3T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
51. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
52. 
    
53. using channel ORA_SBT_TAPE_1
    
54. using channel ORA_SBT_TAPE_2
    
55. backup will be obsolete on date 2020-02-18:21:54:59
    
56. archived logs required to recover from this backup will be backed up
    
57. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
58. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
59. including current control file in backup set
    
60. channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:21:55:01
    
61. channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:21:55:36
    
62. piece handle=2ruju8hk_1_1 tag=3T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
    
63. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
    
64. Finished backup at 2019-12-20:21:55:37
    
65. 
    
66. RMAN>

复制代码

以上请注意观察这段：
current log archived
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
backup will be obsolete on date 2020-02-18:21:54:32
archived logs required to recover from this backup will be backed up
channel ORA_SBT_TAPE_1: starting archived log backup set
channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=36 RECID=31 STAMP=1027547671
channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:21:54:34
channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:21:54:59
piece handle=2quju8gp_1_1 tag=3T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25

using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
backup will be obsolete on date 2020-02-18:21:54:59
archived logs required to recover from this backup will be backed up
channel ORA_SBT_TAPE_1: starting full datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:21:55:01
channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:21:55:36
piece handle=2ruju8hk_1_1 tag=3T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
Finished backup at 2019-12-20:21:55:37

RMAN>

列出归档性备份：
BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
65      Full    470.50M    SBT_TAPE    00:02:26     2019-12-20:21:53:17
        BP Key: 80   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_FULL
        Handle: 2ouju89r_1_1   Media: station76-000054
        Keep: BACKUP_LOGS        Until: 2020-02-18:21:50:48
  List of Datafiles in backup set 65
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  2       Full 1291130    2019-12-20:21:50:52 +DATA/orcl/datafile/sysaux.282.1026941797
  3       Full 1291130    2019-12-20:21:50:52 +DATA/orcl/datafile/undotbs1.281.1026941797
BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
66      Full    642.25M    SBT_TAPE    00:02:39     2019-12-20:21:53:30
        BP Key: 81   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_FULL
        Handle: 2nuju89r_1_1   Media: station76-000053
       Keep: BACKUP_LOGS        Until: 2020-02-18:21:50:48
  List of Datafiles in backup set 66
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 1291129    2019-12-20:21:50:51 +DATA/orcl/datafile/system.283.1026941797
  4       Full 1291129    2019-12-20:21:50:51 +DATA/orcl/datafile/users.265.1027544577
BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
67      Full    256.00K    SBT_TAPE    00:00:39     2019-12-20:21:54:21
        BP Key: 82   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_FULL
        Handle: 2puju8f6_1_1   Media: station76-000053
       Keep: BACKUP_LOGS        Until: 2020-02-18:21:53:39
  SPFILE Included: Modification time: 2019-12-20:18:34:54
  SPFILE db_unique_name: ORCL
BS Key  Size       Device Type Elapsed Time Completion Time   
------- ---------- ----------- ------------ -------------------
68      256.00K    SBT_TAPE    00:00:25     2019-12-20:21:54:58
        BP Key: 83   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_FULL
        Handle: 2quju8gp_1_1   Media: station76-000053
        Keep: BACKUP_LOGS        Until: 2020-02-18:21:54:32
  List of Archived Logs in backup set 68
  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time
  ---- ------- ---------- ------------------- ---------- ---------
  1    36      1291121    2019-12-20:21:50:46 1291274    2019-12-20:21:54:30
BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
------- ---- -- ---------- ----------- ------------ -------------------
69      Full    9.50M      SBT_TAPE    00:00:27     2019-12-20:21:55:27
        BP Key: 84   Status: AVAILABLE  Compressed: NO  Tag: 3T_WHOLE_FULL
        Handle: 2ruju8hk_1_1   Media: station76-000053
       Keep: BACKUP_LOGS        Until: 2020-02-18:21:54:59
  Control File Included: Ckp SCN: 1291337      Ckp time: 2019-12-20:21:55:00
RMAN>