课程第35次：2016-06-15星期三

botang

【上完1Z0-053的第4章】：配置rman、TDE和rman三种加密方式
【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】：共8章（0 1 2 3 4 10 11 12）
sqlnet.ora：

1. ENCRYPTION_WALLET_LOCATION=
   
2. (
   
3.   SOURCE=(METHOD=FILE)
   
4.           (METHOD_DATA=
   
5.            (DIRECTORY=/u01/app/oracle/product/11.2.0/dbhome_1/mywallet/)
   
6.           )
   
7.   )
   

复制代码

rman随堂：

1. [root@station90 桌面]# cd /tmp/
   
2. [root@station90 tmp]# ls
   
3. 9ufUH75P.zip.part                     keyring-JVmQ8t       OSB-SBT-PROXY-23952                    virtd4z96p7
   
4. A+1AKQzH.pdf.part                     keyring-lrCZw0       OSB-SBT-PROXY-23966                    virtdaiCZ59
   
5. acroread_0_0                          keyring-NVnfWr       OSB-SBT-PROXY-24053                    virtddBcF3K
   
6. botang-config-server1                 keyring-QJZo3j       OSB-SBT-PROXY-24082                    virtdkhff5E
   
7. botang-config-xshare                  keyring-SATyne       OSB-SBT-PROXY-24195                    virtdlvKiHx
   
8. gnome-system-monitor.root.2623832447  keyring-tdXx54       OSB-SBT-PROXY-24204                    virtdU4qRPn
   
9. hsperfdata_oracle                     keyring-xAKJWE       OSB-SBT-PROXY-24215                    virtdw7h3Gx
   
10. kde-root                              ksocket-root         pulse-EeBQxGF73h1i                     virtdZYy9Px
    
11. keyring-0pt7it                        libshadowsocks.log   pulse-sdb6jdQkkPR1                     virtual-oracle.7gpGsP
    
12. keyring-0UVLlg                        ofaXGw.png           pulse-Z9SdZWt5bnwy                     virtual-root.Bd4BR8
    
13. keyring-a43rtz                        orbit-gdm            sess_27a35bafcb12865982d98a9dba18e87b  virtual-root.EDY4fl
    
14. keyring-E7WkyM                        orbit-oracle         SIP-XXLHcyZM                           virtual-root.hVnZFF
    
15. keyring-ezvIzr                        orbit-root           SIP-XXv4poGm                           virtual-root.P7XyG2
    
16. keyring-hzSHrh                        OSB-SBT-PROXY-23946  ssh-kpjZD21610                         virtual-root.ZE45zl
    
17. [root@station90 tmp]# cd botang-config-xshare/
    
18. [root@station90 botang-config-xshare]# ls
    
19. blacklist       temp_command24       temp_command_doit16  temp_command_doit8  temp_prepare3        temp_prepare_doit20
    
20. course          temp_command3        temp_command_doit17  temp_command_doit9  temp_prepare4        temp_prepare_doit21
    
21. temp_command10  temp_command37       temp_command_doit18  temp_ip             temp_prepare5        temp_prepare_doit22
    
22. temp_command11  temp_command38       temp_command_doit19  temp_prepare10      temp_prepare6        temp_prepare_doit24
    
23. temp_command12  temp_command4        temp_command_doit20  temp_prepare11      temp_prepare7        temp_prepare_doit3
    
24. temp_command13  temp_command5        temp_command_doit21  temp_prepare12      temp_prepare8        temp_prepare_doit4
    
25. temp_command14  temp_command6        temp_command_doit22  temp_prepare13      temp_prepare9        temp_prepare_doit5
    
26. temp_command15  temp_command7        temp_command_doit23  temp_prepare14      temp_prepare_doit10  temp_prepare_doit6
    
27. temp_command16  temp_command8        temp_command_doit24  temp_prepare15      temp_prepare_doit11  temp_prepare_doit7
    
28. temp_command17  temp_command9        temp_command_doit3   temp_prepare16      temp_prepare_doit12  temp_prepare_doit8
    
29. temp_command18  temp_command_doit10  temp_command_doit37  temp_prepare17      temp_prepare_doit13  temp_prepare_doit9
    
30. temp_command19  temp_command_doit11  temp_command_doit38  temp_prepare19      temp_prepare_doit14  temp_randomip
    
31. temp_command20  temp_command_doit12  temp_command_doit4   temp_prepare20      temp_prepare_doit15  temp_selection
    
32. temp_command21  temp_command_doit13  temp_command_doit5   temp_prepare21      temp_prepare_doit16  temp_xstartup
    
33. temp_command22  temp_command_doit14  temp_command_doit6   temp_prepare22      temp_prepare_doit17
    
34. temp_command23  temp_command_doit15  temp_command_doit7   temp_prepare24      temp_prepare_doit19
    
35. [root@station90 botang-config-xshare]# cd course/
    
36. [root@station90 course]# ls
    
37. general
    
38. [root@station90 course]# mkdir demo
    
39. [root@station90 course]# cd demo/
    
40. [root@station90 demo]# ls
    
41. [root@station90 demo]# cp ../general/
    
42. fnkeys                                           save201606201466430236_v_botang_all_ipsshd_open
    
43. save201606141465873820_v_botang_all_ipsshd_open  save201606201466430251_v_botang_all_ipsshd_open
    
44. save201606141465873881_v_botang_all_ipsshd_open  tmpp1_v_botang_all_ipsshd_open
    
45. save201606141465873954_v_botang_all_ipsshd_open  tmp_v_botang_all_ipsshd_open
    
46. save201606141465878146_v_botang_all_ipsshd_open  tmp_v_botang_dhcp_ipsshd_open
    
47. save201606141465878482_v_botang_all_ipsshd_open  tmp_v_botang_notdhcp_ipsshd_open
    
48. save201606181466256854_v_botang_all_ipsshd_open  v_botang_all_ipsshd_open
    
49. save201606181466256951_v_botang_all_ipsshd_open  v_botang_dhcp_ip
    
50. save201606181466257065_v_botang_all_ipsshd_open  v_botang_dhcp_ipsshd_open
    
51. save201606181466257470_v_botang_all_ipsshd_open  v_botang_notdhcp_ipsshd_open
    
52. save201606201466430166_v_botang_all_ipsshd_open  
    
53. [root@station90 demo]# cp ../general/v_botang_all_ipsshd_open   ./
    
54. [root@station90 demo]# ls
    
55. v_botang_all_ipsshd_open
    
56. [root@station90 demo]# vim v_botang_all_ipsshd_open
    
57. [root@station90 demo]# ssh station90
    
58. The authenticity of host 'station90 (192.168.0.90)' can't be established.
    
59. RSA key fingerprint is b9:1c:59:ca:5c:15:d1:9a:d3:1b:14:b4:a4:bb:74:2a.
    
60. Are you sure you want to continue connecting (yes/no)? yes
    
61. Warning: Permanently added 'station90,192.168.0.90' (RSA) to the list of known hosts.
    
62. Unable to get valid context for root
    
63. Last login: Thu Jun  9 20:35:31 2016 from station90.example.com
    
64. [root@station90 ~]# exit
    
65. logout
    
66. Connection to station90 closed.
    
67. [root@station90 demo]# bcl --O11g05 1a  
    
68. Password Number is: 5.
    
69. RAC FITABLE
    
70. The course for you to decide: ?
    
71. demo  general
    
72. Please input your decision: ? demo
    
73. Your input is: "demo". Are you sure ?(y/n) y
    
74. 
    
75. ****************************************************************************************************
    
76. 一般注意事项：
    
77. 
    
78.   1.以下大多数实验要求数据库处于归档模式，一些实验要求有全库备份，请一定注意users表空间要有单独的备份通道（使它自己包含在它自己的备份集中）。
    
79. 
    
80.   2.把压缩包中各个实验脚本中的*.sql和bclcustom-subprogram放在/home/oracle/下面， 以root身份运行Cbclcustom.sh(可以放在任何地方)，即可实施破坏并作实验。
    
81.         
    
82.   3.sys的密码一定要叫做oracle_4U。
    
83. 
    
84.   4.实验环境的grid和db_home1一定要按照课程环境安装。
    
85. 
    
86.   5.唯独实验6b和实验15需要在执行完成Cbclcustom.sh之后运行各自文件夹下面的begin-realpost。作进一步破坏，请打开begin-realpost阅读一下就明白了。
    
87. 
    
88.   6.11g没有实验2。
    
89. 
    
90. ****************************************************************************************************
    
91. 
    
92. 0_copy_rever
    
93. 10a_当前控制文件损坏_备份时下线user表空间不完全恢复_用控制文件二进制备份_数据不丢_不需备份
    
94. 10b_当前控制文件损坏_备份时下线user表空间完全恢复_用控制文件脚本_不需备份
    
95. 10c_当前控制文件损坏_备份时只读user表空间不完全恢复_用控制文件二进制备份_数据不丢_不需备份
    
96. 10d_当前控制文件损坏_备份时只读user表空间完全恢复_用控制文件脚本_不需备份
    
97. 11a_当前控制文件和日志文件全部损坏_不完全恢复_用控制文件二进制备份
    
98. 11b_当前控制文件和日志文件全部损坏_不完全恢复_用控制文件脚本
    
99. 12a_当前控制文件和日志文件全部损坏_备份时下线user表空间不完全恢复_用控制文件二进制备份
    
100. 12b_当前控制文件和日志文件全部损坏_备份时下线user表空间不完全恢复_用控制文件脚本
     
101. 12c_当前控制文件和日志文件全部损坏_备份时只读user表空间不完全恢复_用控制文件二进制备份
     
102. 12d_当前控制文件和日志文件全部损坏_备份时只读user表空间不完全恢复_用控制文件脚本
     
103. 13a_当前控制文件损坏_新建tbsocp05_test2表空间不完全恢复_用控制文件二进制备份_数据不丢_不需备份
     
104. 13b_当前控制文件损坏_新建tbsocp05_test3表空间完全恢复_用控制文件脚本_不需备份
     
105. 14_删除表空间不完全恢复
     
106. 15_穿越incarnation不完全恢复
     
107. 1a_users表空间在线损坏
     
108. 1b_下线user表空间损坏
     
109. 1c_只读user表空间损坏
     
110. 1d_users表空间热备
     
111. 3_system表空间离线损坏
     
112. 4_tbsocp05_test没有备份的表空间损坏
     
113. 5_基于时间的不完全恢复
     
114. 6a_基于log序列号的不完全恢复
     
115. 6b_基于cancel的不完全恢复
     
116. 7a_当前控制文件和数据文件完好_日志文件全部损坏_正常关机不完全恢复_数据不丢_不需备份
     
117. 7b_当前控制文件和数据文件完好_日志文件全部损坏_不正常关机不完全恢复
     
118. 8a_当前控制文件损坏_不完全恢复_用控制文件二进制备份_数据不丢_不需备份
     
119. 8b_当前控制文件损坏_完全恢复_用控制文件脚本_不需备份
     
120. 9a_当前控制文件损坏_下线user表空间不完全恢复_用控制文件二进制备份_数据不丢_不需备份
     
121. 9b_当前控制文件损坏_下线user表空间完全恢复_用控制文件脚本_不需备份
     
122. 9c_当前控制文件损坏_只读user表空间不完全恢复_用控制文件二进制备份_数据不丢_不需备份
     
123. 9d_当前控制文件损坏_只读user表空间完全恢复_用控制文件脚本_不需备份
     
124. bclcustom-subprogram
     
125. begin-prepare
     
126. begin-real
     
127. end
     
128. ptable.sql
     
129. rtable.sql
     
130.   ********
     
131.   * 提醒 * 从7b开始讲师需要准备catalog。 如果使用磁带机，从11a开始请注意users的备份是否存在。
     
132.   ********
     
133. Preparation or not, continue: ? y
     
134. Password Number is: 5.
     
135. RAC FITABLE
     
136. The course for you to decide: ?
     
137. demo  general
     
138. Please input your decision: ? demo
     
139. Your input is: "demo". Are you sure ?(y/n) y
     
140. Uniquely Customing 192.168.0.90......
     
141. Please wait ......
     
142. 关闭 vsftpd：                                              [确定]
     
143. 为 vsftpd 启动 vsftpd：                                    [确定]
     
144. Preparation finished, continue: ? y
     
145. Password Number is: 5.
     
146. RAC FITABLE
     
147. The course for you to decide: ?
     
148. demo  general
     
149. Please input your decision: ? demo
     
150. Your input is: "demo". Are you sure ?(y/n) y
     
151. Uniquely Customing 192.168.0.90......
     
152. Please wait ......
     
153. Waiting result for full output from 192.168.0.90......
     
154. Waiting result for full output from 192.168.0.90......
     
155. Waiting result for full output from 192.168.0.90......
     
156. Waiting result for full output from 192.168.0.90......
     
157. Waiting result for full output from 192.168.0.90......
     
158. Waiting result for full output from 192.168.0.90......
     
159. Waiting result for full output from 192.168.0.90......
     
160. Waiting result for full output from 192.168.0.90......
     
161. Waiting result for full output from 192.168.0.90......
     
162. Waiting result for full output from 192.168.0.90......
     
163. Waiting result for full output from 192.168.0.90......
     
164. Waiting result for full output from 192.168.0.90......
     
165. Waiting result for full output from 192.168.0.90......
     
166. Waiting result for full output from 192.168.0.90......
     
167. Waiting result for full output from 192.168.0.90......
     
168. Waiting result for full output from 192.168.0.90......
     
169. Waiting result for full output from 192.168.0.90......
     
170. 关闭 vsftpd：                                              [确定]
     
171. 为 vsftpd 启动 vsftpd：                                    [确定]
     
172. Reallabs finished, continue ?y
     
173. Password Number is: 5.
     
174. RAC FITABLE
     
175. The course for you to decide: ?
     
176. demo  general
     
177. Please input your decision: ? demo
     
178. Your input is: "demo". Are you sure ?(y/n) y
     
179. Uniquely Customing 192.168.0.90......
     
180. Please wait ......
     
181. 关闭 vsftpd：                                              [确定]
     
182. 为 vsftpd 启动 vsftpd：                                    [确定]
     
183. [root@station90 demo]# su - oracle
     
184. [oracle@station90 ~]$ rman target /  
     
185. 
     
186. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 21 00:07:33 2016
     
187. 
     
188. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
189. 
     
190. connected to target database: ORCL (DBID=1343950367)
     
191. 
     
192. RMAN> backup '2T_USERS_INCR0'  incremental level 0 tablespace users ;  
     
193. 
     
194. RMAN-00571: ===========================================================
     
195. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
196. RMAN-00571: ===========================================================
     
197. RMAN-00558: error encountered while parsing input commands
     
198. RMAN-01009: syntax error: found "single-quoted-string": expecting one of: "archivelog, as, auxiliary, backupset, backup, channel, check, controlfilecopy, copies, copy, cumulative, current, database, datafilecopy, datafile, db_file_name_convert, db_recovery_file_dest, device, diskratio, duration, filesperset, force, format, for, from, full, incremental, keep, maxsetsize, nochecksum, noexclude, nokeep, not, pool, proxy, recovery, reuse, section, skip readonly, skip, spfile, tablespace, tag, to, validate, ("
     
199. RMAN-01007: at line 1 column 8 file: standard input
     
200. 
     
201. RMAN> backup tag  '2T_USERS_INCR0'  incremental level 0 tablespace users ;  
     
202. 
     
203. Starting backup at 2016-06-21:00:08:21
     
204. using target database control file instead of recovery catalog
     
205. allocated channel: ORA_SBT_TAPE_1
     
206. channel ORA_SBT_TAPE_1: SID=86 device type=SBT_TAPE
     
207. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
208. allocated channel: ORA_SBT_TAPE_2
     
209. channel ORA_SBT_TAPE_2: SID=18 device type=SBT_TAPE
     
210. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
211. allocated channel: ORA_SBT_TAPE_3
     
212. channel ORA_SBT_TAPE_3: SID=138 device type=SBT_TAPE
     
213. channel ORA_SBT_TAPE_3: Oracle Secure Backup
     
214. allocated channel: ORA_SBT_TAPE_4
     
215. channel ORA_SBT_TAPE_4: SID=83 device type=SBT_TAPE
     
216. channel ORA_SBT_TAPE_4: Oracle Secure Backup
     
217. allocated channel: ORA_SBT_TAPE_5
     
218. channel ORA_SBT_TAPE_5: SID=20 device type=SBT_TAPE
     
219. channel ORA_SBT_TAPE_5: Oracle Secure Backup
     
220. allocated channel: ORA_SBT_TAPE_6
     
221. channel ORA_SBT_TAPE_6: SID=145 device type=SBT_TAPE
     
222. channel ORA_SBT_TAPE_6: Oracle Secure Backup
     
223. allocated channel: ORA_SBT_TAPE_7
     
224. channel ORA_SBT_TAPE_7: SID=23 device type=SBT_TAPE
     
225. channel ORA_SBT_TAPE_7: Oracle Secure Backup
     
226. allocated channel: ORA_SBT_TAPE_8
     
227. channel ORA_SBT_TAPE_8: SID=152 device type=SBT_TAPE
     
228. channel ORA_SBT_TAPE_8: Oracle Secure Backup
     
229. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
     
230. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
231. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915062657
     
232. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-21:00:09:04
     
233. RMAN-00571: ===========================================================
     
234. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
235. RMAN-00571: ===========================================================
     
236. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 06/21/2016 00:09:05
     
237. ORA-19914: unable to encrypt backup
     
238. ORA-28365: wallet is not open
     
239. 
     
240. RMAN> set encryption on identified by "redhat12";
     
241. 
     
242. executing command: SET encryption
     
243. 
     
244. RMAN> backup tag  '2T_USERS_INCR0'  incremental level 0 tablespace users ;  
     
245. 
     
246. Starting backup at 2016-06-21:00:09:29
     
247. using channel ORA_SBT_TAPE_1
     
248. using channel ORA_SBT_TAPE_2
     
249. using channel ORA_SBT_TAPE_3
     
250. using channel ORA_SBT_TAPE_4
     
251. using channel ORA_SBT_TAPE_5
     
252. using channel ORA_SBT_TAPE_6
     
253. using channel ORA_SBT_TAPE_7
     
254. using channel ORA_SBT_TAPE_8
     
255. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
     
256. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
257. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915062657
     
258. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-21:00:09:29
     
259. RMAN-00571: ===========================================================
     
260. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
261. RMAN-00571: ===========================================================
     
262. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 06/21/2016 00:09:30
     
263. ORA-19914: unable to encrypt backup
     
264. ORA-28365: wallet is not open
     
265. 
     
266. RMAN> run {
     
267. 2> set encryption on identified by "redhat12";
     
268. 3>  backup tag  '2T_USERS_INCR0'  incremental level 0 tablespace users ;
     
269. 4> }
     
270. 
     
271. RMAN-00571: ===========================================================
     
272. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
273. RMAN-00571: ===========================================================
     
274. RMAN-03032: this option of set command needs to be used outside of a run block
     
275. 
     
276. RMAN> show all;
     
277. 
     
278. RMAN configuration parameters for database with db_unique_name ORCL are:
     
279. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
     
280. CONFIGURE BACKUP OPTIMIZATION ON;
     
281. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
     
282. CONFIGURE CONTROLFILE AUTOBACKUP OFF;
     
283. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
     
284. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
     
285. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO COMPRESSED BACKUPSET;
     
286. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
     
287. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
288. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
289. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
290. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
291. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
292. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
293. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
294. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
295. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
296. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
297. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
298. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
299. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
     
300. CONFIGURE ENCRYPTION FOR DATABASE ON;
     
301. CONFIGURE ENCRYPTION ALGORITHM 'AES256';
     
302. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
     
303. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
     
304. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
     
305. 
     
306. RMAN> set encryption on identified by "redhat12"  only ;
     
307. 
     
308. executing command: SET encryption
     
309. 
     
310. RMAN>  backup tag  '2PET_USERS_INCR0'  incremental level 0 tablespace users ;
     
311. 
     
312. Starting backup at 2016-06-21:00:10:50
     
313. using channel ORA_SBT_TAPE_1
     
314. using channel ORA_SBT_TAPE_2
     
315. using channel ORA_SBT_TAPE_3
     
316. using channel ORA_SBT_TAPE_4
     
317. using channel ORA_SBT_TAPE_5
     
318. using channel ORA_SBT_TAPE_6
     
319. using channel ORA_SBT_TAPE_7
     
320. using channel ORA_SBT_TAPE_8
     
321. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
     
322. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
323. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.915062657
     
324. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-21:00:10:50
     
325. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-21:00:11:15
     
326. piece handle=6rr8lg8a_1_1 tag=2PET_USERS_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
     
327. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
     
328. Finished backup at 2016-06-21:00:11:15
     
329. 
     
330. RMAN> exit
     
331. 
     
332. 
     
333. Recovery Manager complete.
     
334. [oracle@station90 ~]$ rman target /
     
335. 
     
336. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 21 00:12:32 2016
     
337. 
     
338. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
339. 
     
340. connected to target database: ORCL (DBID=1343950367)
     
341. 
     
342. RMAN> list backup;
     
343. 
     
344. using target database control file instead of recovery catalog
     
345. 
     
346. List of Backup Sets
     
347. ===================
     
348. 
     
349. 
     
350. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
351. ------- ---- -- ---------- ----------- ------------ -------------------
     
352. 197     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-20:23:56:17
     
353.         BP Key: 213   Status: AVAILABLE  Compressed: NO  Tag: 1ET_USERS_INCR0
     
354.         Handle: 6or8lfc9_1_1   Media: station90-000019
     
355.   List of Datafiles in backup set 197
     
356.   File LV Type Ckp SCN    Ckp Time            Name
     
357.   ---- -- ---- ---------- ------------------- ----
     
358.   4    0  Incr 2126701    2016-06-20:23:55:53 +DATA/orcl/datafile/users.259.915062657
     
359. 
     
360. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
361. ------- ---- -- ---------- ----------- ------------ -------------------
     
362. 198     Incr 0  1.25M      SBT_TAPE    00:00:24     2016-06-21:00:11:14
     
363.         BP Key: 214   Status: AVAILABLE  Compressed: NO  Tag: 2PET_USERS_INCR0
     
364.         Handle: 6rr8lg8a_1_1   Media: station90-000019
     
365.   List of Datafiles in backup set 198
     
366.   File LV Type Ckp SCN    Ckp Time            Name
     
367.   ---- -- ---- ---------- ------------------- ----
     
368.   4    0  Incr 2131009    2016-06-21:00:10:50 +DATA/orcl/datafile/users.259.915062657
     
369. 
     
370. RMAN> restore  tablespace users ;
     
371. 
     
372. Starting restore at 2016-06-21:00:13:08
     
373. allocated channel: ORA_DISK_1
     
374. channel ORA_DISK_1: SID=201 device type=DISK
     
375. allocated channel: ORA_DISK_2
     
376. channel ORA_DISK_2: SID=17 device type=DISK
     
377. allocated channel: ORA_DISK_3
     
378. channel ORA_DISK_3: SID=75 device type=DISK
     
379. allocated channel: ORA_DISK_4
     
380. channel ORA_DISK_4: SID=130 device type=DISK
     
381. allocated channel: ORA_DISK_5
     
382. channel ORA_DISK_5: SID=205 device type=DISK
     
383. allocated channel: ORA_DISK_6
     
384. channel ORA_DISK_6: SID=24 device type=DISK
     
385. allocated channel: ORA_DISK_7
     
386. channel ORA_DISK_7: SID=85 device type=DISK
     
387. allocated channel: ORA_DISK_8
     
388. channel ORA_DISK_8: SID=140 device type=DISK
     
389. allocated channel: ORA_SBT_TAPE_1
     
390. channel ORA_SBT_TAPE_1: SID=195 device type=SBT_TAPE
     
391. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
392. allocated channel: ORA_SBT_TAPE_2
     
393. channel ORA_SBT_TAPE_2: SID=135 device type=SBT_TAPE
     
394. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
395. allocated channel: ORA_SBT_TAPE_3
     
396. channel ORA_SBT_TAPE_3: SID=9 device type=SBT_TAPE
     
397. channel ORA_SBT_TAPE_3: Oracle Secure Backup
     
398. allocated channel: ORA_SBT_TAPE_4
     
399. channel ORA_SBT_TAPE_4: SID=137 device type=SBT_TAPE
     
400. channel ORA_SBT_TAPE_4: Oracle Secure Backup
     
401. allocated channel: ORA_SBT_TAPE_5
     
402. channel ORA_SBT_TAPE_5: SID=84 device type=SBT_TAPE
     
403. channel ORA_SBT_TAPE_5: Oracle Secure Backup
     
404. allocated channel: ORA_SBT_TAPE_6
     
405. channel ORA_SBT_TAPE_6: SID=22 device type=SBT_TAPE
     
406. channel ORA_SBT_TAPE_6: Oracle Secure Backup
     
407. allocated channel: ORA_SBT_TAPE_7
     
408. channel ORA_SBT_TAPE_7: SID=78 device type=SBT_TAPE
     
409. channel ORA_SBT_TAPE_7: Oracle Secure Backup
     
410. allocated channel: ORA_SBT_TAPE_8
     
411. channel ORA_SBT_TAPE_8: SID=86 device type=SBT_TAPE
     
412. channel ORA_SBT_TAPE_8: Oracle Secure Backup
     
413. 
     
414. channel ORA_SBT_TAPE_1: starting datafile backup set restore
     
415. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
     
416. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.259.915062657
     
417. channel ORA_SBT_TAPE_1: reading from backup piece 6rr8lg8a_1_1
     
418. RMAN-00571: ===========================================================
     
419. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
420. RMAN-00571: ===========================================================
     
421. RMAN-03002: failure of restore command at 06/21/2016 00:14:28
     
422. ORA-19870: error while restoring backup piece 6rr8lg8a_1_1
     
423. ORA-19913: unable to decrypt backup
     
424. ORA-28365: wallet is not open
     
425. 
     
426. RMAN> set decrytion identified by "java12","oracle12";
     
427. 
     
428. RMAN-00571: ===========================================================
     
429. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
430. RMAN-00571: ===========================================================
     
431. RMAN-00558: error encountered while parsing input commands
     
432. RMAN-01009: syntax error: found "identifier": expecting one of: "archivelog, autobackup, auxiliary, auxname, backup, command, compression, controlfile, database, dbid, decryption, echo, encryption, high, incarnation, maxcorrupt, maxseq, newname, nocfau, restore, snapshot, to restore point, until restore point, until"
     
433. RMAN-01008: the bad identifier was: decrytion
     
434. RMAN-01007: at line 1 column 5 file: standard input
     
435. 
     
436. RMAN> set decryption identified by "java12","oracle12";
     
437. 
     
438. executing command: SET decryption
     
439. 
     
440. RMAN> restore  tablespace users ;
     
441. 
     
442. Starting restore at 2016-06-21:00:15:40
     
443. using channel ORA_DISK_1
     
444. using channel ORA_DISK_2
     
445. using channel ORA_DISK_3
     
446. using channel ORA_DISK_4
     
447. using channel ORA_DISK_5
     
448. using channel ORA_DISK_6
     
449. using channel ORA_DISK_7
     
450. using channel ORA_DISK_8
     
451. using channel ORA_SBT_TAPE_1
     
452. using channel ORA_SBT_TAPE_2
     
453. using channel ORA_SBT_TAPE_3
     
454. using channel ORA_SBT_TAPE_4
     
455. using channel ORA_SBT_TAPE_5
     
456. using channel ORA_SBT_TAPE_6
     
457. using channel ORA_SBT_TAPE_7
     
458. using channel ORA_SBT_TAPE_8
     
459. 
     
460. channel ORA_SBT_TAPE_1: starting datafile backup set restore
     
461. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
     
462. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.259.915062657
     
463. channel ORA_SBT_TAPE_1: reading from backup piece 6rr8lg8a_1_1
     
464. 
     
465. RMAN-00571: ===========================================================
     
466. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
467. RMAN-00571: ===========================================================
     
468. RMAN-03002: failure of restore command at 06/21/2016 00:16:09
     
469. ORA-19870: error while restoring backup piece 6rr8lg8a_1_1
     
470. ORA-19913: unable to decrypt backup
     
471. ORA-28365: wallet is not open
     
472. 
     
473. RMAN> set decryption identified by "java12","redhat12","oracle12";
     
474. 
     
475. executing command: SET decryption
     
476. 
     
477. RMAN> restore  tablespace users ;
     
478. 
     
479. Starting restore at 2016-06-21:00:16:25
     
480. using channel ORA_DISK_1
     
481. using channel ORA_DISK_2
     
482. using channel ORA_DISK_3
     
483. using channel ORA_DISK_4
     
484. using channel ORA_DISK_5
     
485. using channel ORA_DISK_6
     
486. using channel ORA_DISK_7
     
487. using channel ORA_DISK_8
     
488. using channel ORA_SBT_TAPE_1
     
489. using channel ORA_SBT_TAPE_2
     
490. using channel ORA_SBT_TAPE_3
     
491. using channel ORA_SBT_TAPE_4
     
492. using channel ORA_SBT_TAPE_5
     
493. using channel ORA_SBT_TAPE_6
     
494. using channel ORA_SBT_TAPE_7
     
495. using channel ORA_SBT_TAPE_8
     
496. 
     
497. channel ORA_SBT_TAPE_1: starting datafile backup set restore
     
498. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
     
499. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.259.915062657
     
500. channel ORA_SBT_TAPE_1: reading from backup piece 6rr8lg8a_1_1
     
501. channel ORA_SBT_TAPE_1: piece handle=6rr8lg8a_1_1 tag=2PET_USERS_INCR0
     
502. channel ORA_SBT_TAPE_1: restored backup piece 1
     
503. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:25
     
504. Finished restore at 2016-06-21:00:16:51
     
505. 
     
506. RMAN> recover tablespace users ;
     
507. 
     
508. Starting recover at 2016-06-21:00:17:12
     
509. using channel ORA_DISK_1
     
510. using channel ORA_DISK_2
     
511. using channel ORA_DISK_3
     
512. using channel ORA_DISK_4
     
513. using channel ORA_DISK_5
     
514. using channel ORA_DISK_6
     
515. using channel ORA_DISK_7
     
516. using channel ORA_DISK_8
     
517. using channel ORA_SBT_TAPE_1
     
518. using channel ORA_SBT_TAPE_2
     
519. using channel ORA_SBT_TAPE_3
     
520. using channel ORA_SBT_TAPE_4
     
521. using channel ORA_SBT_TAPE_5
     
522. using channel ORA_SBT_TAPE_6
     
523. using channel ORA_SBT_TAPE_7
     
524. using channel ORA_SBT_TAPE_8
     
525. 
     
526. starting media recovery
     
527. media recovery complete, elapsed time: 00:00:00
     
528. 
     
529. Finished recover at 2016-06-21:00:17:13
     
530. 
     
531. RMAN>
     

复制代码

加密部分：

1. [root@station90 桌面]# su - oracle
   
2. [oracle@station90 ~]$ sqlplus /nolog
   
3. 
   
4. SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 20 23:50:09 2016
   
5. 
   
6. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
7. 
   
8. SQL> conn   / as sysdba
   
9. Connected.
   
10. SQL> alter system set encryption wallet close identified  by "oracle12";
    
11. 
    
12. System altered.
    
13. 
    
14. SQL> alter system set encryption wallet open identified  by "oracle12";
    
15. 
    
16. System altered.
    
17. 
    
18. SQL> exit
    
19. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
20. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
    
21. and Real Application Testing options
    
22. [oracle@station90 ~]$ rman target  /
    
23. 
    
24. Recovery Manager: Release 11.2.0.1.0 - Production on Mon Jun 20 23:51:17 2016
    
25. 
    
26. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
27. 
    
28. connected to target database: ORCL (DBID=1343950367)
    
29. 
    
30. RMAN> delete noprompt backup ;
    
31. 
    
32. using target database control file instead of recovery catalog
    
33. allocated channel: ORA_DISK_1
    
34. channel ORA_DISK_1: SID=137 device type=DISK
    
35. allocated channel: ORA_DISK_2
    
36. channel ORA_DISK_2: SID=135 device type=DISK
    
37. allocated channel: ORA_DISK_3
    
38. channel ORA_DISK_3: SID=197 device type=DISK
    
39. allocated channel: ORA_DISK_4
    
40. channel ORA_DISK_4: SID=14 device type=DISK
    
41. allocated channel: ORA_DISK_5
    
42. channel ORA_DISK_5: SID=78 device type=DISK
    
43. allocated channel: ORA_DISK_6
    
44. channel ORA_DISK_6: SID=140 device type=DISK
    
45. allocated channel: ORA_DISK_7
    
46. channel ORA_DISK_7: SID=191 device type=DISK
    
47. allocated channel: ORA_DISK_8
    
48. channel ORA_DISK_8: SID=15 device type=DISK
    
49. allocated channel: ORA_SBT_TAPE_1
    
50. channel ORA_SBT_TAPE_1: SID=75 device type=SBT_TAPE
    
51. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
52. allocated channel: ORA_SBT_TAPE_2
    
53. channel ORA_SBT_TAPE_2: SID=198 device type=SBT_TAPE
    
54. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
55. allocated channel: ORA_SBT_TAPE_3
    
56. channel ORA_SBT_TAPE_3: SID=195 device type=SBT_TAPE
    
57. channel ORA_SBT_TAPE_3: Oracle Secure Backup
    
58. allocated channel: ORA_SBT_TAPE_4
    
59. channel ORA_SBT_TAPE_4: SID=139 device type=SBT_TAPE
    
60. channel ORA_SBT_TAPE_4: Oracle Secure Backup
    
61. allocated channel: ORA_SBT_TAPE_5
    
62. channel ORA_SBT_TAPE_5: SID=17 device type=SBT_TAPE
    
63. channel ORA_SBT_TAPE_5: Oracle Secure Backup
    
64. allocated channel: ORA_SBT_TAPE_6
    
65. channel ORA_SBT_TAPE_6: SID=144 device type=SBT_TAPE
    
66. channel ORA_SBT_TAPE_6: Oracle Secure Backup
    
67. allocated channel: ORA_SBT_TAPE_7
    
68. channel ORA_SBT_TAPE_7: SID=86 device type=SBT_TAPE
    
69. channel ORA_SBT_TAPE_7: Oracle Secure Backup
    
70. allocated channel: ORA_SBT_TAPE_8
    
71. channel ORA_SBT_TAPE_8: SID=22 device type=SBT_TAPE
    
72. channel ORA_SBT_TAPE_8: Oracle Secure Backup
    
73. 
    
74. List of Backup Pieces
    
75. BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
    
76. ------- ------- --- --- ----------- ----------- ----------
    
77. 181     177     1   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_20/nnsnn0_1d_system_incr0_0.301.915056827
    
78. 182     178     1   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_20/ncnnn0_1d_system_incr0_0.303.915056829
    
79. 183     179     1   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_20/nnndn0_1d_system_incr0_0.300.915056829
    
80. 184     180     1   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_20/nnsnn0_2d_system_incr0_0.306.915057063
    
81. 185     181     1   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_20/ncnnn0_2d_system_incr0_0.316.915057065
    
82. 186     182     1   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_20/nnndn0_2d_system_incr0_0.268.915057065
    
83. 187     182     2   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_20/nnndn0_2d_system_incr0_0.310.915057067
    
84. 188     182     3   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_20/nnndn0_2d_system_incr0_0.309.915057071
    
85. 189     182     4   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_20/nnndn0_2d_system_incr0_0.311.915057073
    
86. 190     182     5   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_20/nnndn0_2d_system_incr0_0.314.915057077
    
87. 191     182     6   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_20/nnndn0_2d_system_incr0_0.308.915057079
    
88. 192     182     7   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_20/nnndn0_2d_system_incr0_0.341.915057083
    
89. 193     183     1   1   AVAILABLE   DISK        /home/oracle/maxpieces/6ar8laie_1_1.bkp
    
90. 194     183     2   1   AVAILABLE   DISK        /home/oracle/maxpieces/6ar8laie_2_1.bkp
    
91. 195     183     3   1   AVAILABLE   DISK        /home/oracle/maxpieces/6ar8laie_3_1.bkp
    
92. 196     183     4   1   AVAILABLE   DISK        /home/oracle/maxpieces/6ar8laie_4_1.bkp
    
93. 197     183     5   1   AVAILABLE   DISK        /home/oracle/maxpieces/6ar8laie_5_1.bkp
    
94. 198     183     6   1   AVAILABLE   DISK        /home/oracle/maxpieces/6ar8laie_6_1.bkp
    
95. 199     183     7   1   AVAILABLE   DISK        /home/oracle/maxpieces/6ar8laie_7_1.bkp
    
96. 200     184     1   1   AVAILABLE   DISK        /home/oracle/maxpieces/6br8lain_1_1.bkp
    
97. 201     185     1   1   AVAILABLE   SBT_TAPE    6dr8latl_1_1
    
98. 202     186     1   1   AVAILABLE   SBT_TAPE    6cr8latl_1_1
    
99. 203     187     1   1   AVAILABLE   SBT_TAPE    6fr8laup_1_1
    
100. 204     188     1   1   AVAILABLE   SBT_TAPE    6er8laup_1_1
     
101. 205     189     1   1   AVAILABLE   SBT_TAPE    6jr8lauq_1_1
     
102. 206     190     1   1   AVAILABLE   SBT_TAPE    6gr8laup_1_1
     
103. 207     191     1   1   AVAILABLE   SBT_TAPE    6hr8laup_1_1
     
104. 208     192     1   1   AVAILABLE   SBT_TAPE    6ir8laup_1_1
     
105. 210     194     1   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_20/nnsnn0_1cd_system_incr0_0.305.915058285
     
106. 211     195     1   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_20/ncnnn0_1cd_system_incr0_0.328.915058287
     
107. 212     196     1   1   AVAILABLE   DISK        +FRA/orcl/backupset/2016_06_20/nnndn0_1cd_system_incr0_0.334.915058285
     
108. deleted backup piece
     
109. backup piece handle=+FRA/orcl/backupset/2016_06_20/nnsnn0_1d_system_incr0_0.301.915056827 RECID=181 STAMP=915056827
     
110. deleted backup piece
     
111. backup piece handle=+FRA/orcl/backupset/2016_06_20/ncnnn0_1d_system_incr0_0.303.915056829 RECID=182 STAMP=915056828
     
112. deleted backup piece
     
113. backup piece handle=+FRA/orcl/backupset/2016_06_20/nnndn0_1d_system_incr0_0.300.915056829 RECID=183 STAMP=915056827
     
114. deleted backup piece
     
115. backup piece handle=+FRA/orcl/backupset/2016_06_20/nnsnn0_2d_system_incr0_0.306.915057063 RECID=184 STAMP=915057062
     
116. deleted backup piece
     
117. backup piece handle=+FRA/orcl/backupset/2016_06_20/ncnnn0_2d_system_incr0_0.316.915057065 RECID=185 STAMP=915057063
     
118. deleted backup piece
     
119. backup piece handle=+FRA/orcl/backupset/2016_06_20/nnndn0_2d_system_incr0_0.268.915057065 RECID=186 STAMP=915057064
     
120. deleted backup piece
     
121. backup piece handle=+FRA/orcl/backupset/2016_06_20/nnndn0_2d_system_incr0_0.310.915057067 RECID=187 STAMP=915057067
     
122. deleted backup piece
     
123. backup piece handle=+FRA/orcl/backupset/2016_06_20/nnndn0_2d_system_incr0_0.309.915057071 RECID=188 STAMP=915057070
     
124. deleted backup piece
     
125. backup piece handle=+FRA/orcl/backupset/2016_06_20/nnndn0_2d_system_incr0_0.311.915057073 RECID=189 STAMP=915057073
     
126. deleted backup piece
     
127. backup piece handle=+FRA/orcl/backupset/2016_06_20/nnndn0_2d_system_incr0_0.314.915057077 RECID=190 STAMP=915057076
     
128. deleted backup piece
     
129. backup piece handle=+FRA/orcl/backupset/2016_06_20/nnndn0_2d_system_incr0_0.308.915057079 RECID=191 STAMP=915057079
     
130. deleted backup piece
     
131. backup piece handle=+FRA/orcl/backupset/2016_06_20/nnndn0_2d_system_incr0_0.341.915057083 RECID=192 STAMP=915057082
     
132. deleted backup piece
     
133. backup piece handle=/home/oracle/maxpieces/6ar8laie_1_1.bkp RECID=193 STAMP=915057230
     
134. deleted backup piece
     
135. backup piece handle=/home/oracle/maxpieces/6ar8laie_2_1.bkp RECID=194 STAMP=915057233
     
136. deleted backup piece
     
137. backup piece handle=/home/oracle/maxpieces/6ar8laie_3_1.bkp RECID=195 STAMP=915057234
     
138. deleted backup piece
     
139. backup piece handle=/home/oracle/maxpieces/6ar8laie_4_1.bkp RECID=196 STAMP=915057235
     
140. deleted backup piece
     
141. backup piece handle=/home/oracle/maxpieces/6ar8laie_5_1.bkp RECID=197 STAMP=915057236
     
142. deleted backup piece
     
143. backup piece handle=/home/oracle/maxpieces/6ar8laie_6_1.bkp RECID=198 STAMP=915057237
     
144. deleted backup piece
     
145. backup piece handle=/home/oracle/maxpieces/6ar8laie_7_1.bkp RECID=199 STAMP=915057238
     
146. deleted backup piece
     
147. backup piece handle=/home/oracle/maxpieces/6br8lain_1_1.bkp RECID=200 STAMP=915057240
     
148. deleted backup piece
     
149. backup piece handle=+FRA/orcl/backupset/2016_06_20/nnsnn0_1cd_system_incr0_0.305.915058285 RECID=210 STAMP=915058285
     
150. deleted backup piece
     
151. backup piece handle=+FRA/orcl/backupset/2016_06_20/ncnnn0_1cd_system_incr0_0.328.915058287 RECID=211 STAMP=915058286
     
152. deleted backup piece
     
153. backup piece handle=+FRA/orcl/backupset/2016_06_20/nnndn0_1cd_system_incr0_0.334.915058285 RECID=212 STAMP=915058285
     
154. Deleted 23 objects
     
155. 
     
156. deleted backup piece
     
157. backup piece handle=6dr8latl_1_1 RECID=201 STAMP=915057589
     
158. deleted backup piece
     
159. backup piece handle=6cr8latl_1_1 RECID=202 STAMP=915057589
     
160. deleted backup piece
     
161. backup piece handle=6fr8laup_1_1 RECID=203 STAMP=915057626
     
162. deleted backup piece
     
163. backup piece handle=6er8laup_1_1 RECID=204 STAMP=915057625
     
164. deleted backup piece
     
165. backup piece handle=6jr8lauq_1_1 RECID=205 STAMP=915057626
     
166. deleted backup piece
     
167. backup piece handle=6gr8laup_1_1 RECID=206 STAMP=915057626
     
168. deleted backup piece
     
169. backup piece handle=6hr8laup_1_1 RECID=207 STAMP=915057626
     
170. deleted backup piece
     
171. backup piece handle=6ir8laup_1_1 RECID=208 STAMP=915057627
     
172. Deleted 8 objects
     
173. 
     
174. 
     
175. RMAN> delete noprompt copy;
     
176. 
     
177. released channel: ORA_DISK_1
     
178. released channel: ORA_DISK_2
     
179. released channel: ORA_DISK_3
     
180. released channel: ORA_DISK_4
     
181. released channel: ORA_DISK_5
     
182. released channel: ORA_DISK_6
     
183. released channel: ORA_DISK_7
     
184. released channel: ORA_DISK_8
     
185. released channel: ORA_SBT_TAPE_1
     
186. released channel: ORA_SBT_TAPE_2
     
187. released channel: ORA_SBT_TAPE_3
     
188. released channel: ORA_SBT_TAPE_4
     
189. released channel: ORA_SBT_TAPE_5
     
190. released channel: ORA_SBT_TAPE_6
     
191. released channel: ORA_SBT_TAPE_7
     
192. released channel: ORA_SBT_TAPE_8
     
193. allocated channel: ORA_DISK_1
     
194. channel ORA_DISK_1: SID=137 device type=DISK
     
195. allocated channel: ORA_DISK_2
     
196. channel ORA_DISK_2: SID=135 device type=DISK
     
197. allocated channel: ORA_DISK_3
     
198. channel ORA_DISK_3: SID=197 device type=DISK
     
199. allocated channel: ORA_DISK_4
     
200. channel ORA_DISK_4: SID=14 device type=DISK
     
201. allocated channel: ORA_DISK_5
     
202. channel ORA_DISK_5: SID=78 device type=DISK
     
203. allocated channel: ORA_DISK_6
     
204. channel ORA_DISK_6: SID=140 device type=DISK
     
205. allocated channel: ORA_DISK_7
     
206. channel ORA_DISK_7: SID=191 device type=DISK
     
207. allocated channel: ORA_DISK_8
     
208. channel ORA_DISK_8: SID=15 device type=DISK
     
209. specification does not match any datafile copy in the repository
     
210. specification does not match any control file copy in the repository
     
211. specification does not match any archived log in the repository
     
212. 
     
213. RMAN> list copy;
     
214. 
     
215. specification does not match any datafile copy in the repository
     
216. specification does not match any control file copy in the repository
     
217. specification does not match any archived log in the repository
     
218. 
     
219. RMAN> list backup;
     
220. 
     
221. specification does not match any backup in the repository
     
222. 
     
223. RMAN> show all;
     
224. 
     
225. RMAN configuration parameters for database with db_unique_name ORCL are:
     
226. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
     
227. CONFIGURE BACKUP OPTIMIZATION ON;
     
228. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
     
229. CONFIGURE CONTROLFILE AUTOBACKUP OFF;
     
230. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
     
231. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
     
232. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO COMPRESSED BACKUPSET;
     
233. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
     
234. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
235. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
236. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
237. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
238. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
239. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
240. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
241. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
242. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
243. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
244. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
245. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
246. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
     
247. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
     
248. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
     
249. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
     
250. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
     
251. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
     
252. 
     
253. RMAN> CONFIGURE ENCRYPTION FOR DATABASE  ON;
     
254. 
     
255. new RMAN configuration parameters:
     
256. CONFIGURE ENCRYPTION FOR DATABASE ON;
     
257. new RMAN configuration parameters are successfully stored
     
258. 
     
259. RMAN> CONFIGURE ENCRYPTION ALGORITHM 'AES192' ;
     
260. 
     
261. new RMAN configuration parameters:
     
262. CONFIGURE ENCRYPTION ALGORITHM 'AES192';
     
263. new RMAN configuration parameters are successfully stored
     
264. 
     
265. RMAN> CONFIGURE ENCRYPTION ALGORITHM 'AES256';
     
266. 
     
267. old RMAN configuration parameters:
     
268. CONFIGURE ENCRYPTION ALGORITHM 'AES192';
     
269. new RMAN configuration parameters:
     
270. CONFIGURE ENCRYPTION ALGORITHM 'AES256';
     
271. new RMAN configuration parameters are successfully stored
     
272. 
     
273. RMAN> show all;
     
274. 
     
275. RMAN configuration parameters for database with db_unique_name ORCL are:
     
276. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
     
277. CONFIGURE BACKUP OPTIMIZATION ON;
     
278. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
     
279. CONFIGURE CONTROLFILE AUTOBACKUP OFF;
     
280. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
     
281. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
     
282. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO COMPRESSED BACKUPSET;
     
283. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
     
284. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
285. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
286. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
     
287. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
     
288. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
289. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
290. CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
291. CONFIGURE CHANNEL 4 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
292. CONFIGURE CHANNEL 5 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
293. CONFIGURE CHANNEL 6 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
294. CONFIGURE CHANNEL 7 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
295. CONFIGURE CHANNEL 8 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
     
296. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
     
297. CONFIGURE ENCRYPTION FOR DATABASE ON;
     
298. CONFIGURE ENCRYPTION ALGORITHM 'AES256';
     
299. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
     
300. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
     
301. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
     
302. 
     
303. RMAN> CONFIGURE DEFAULT DEVICE TYPE TO  sbt;
     
304. 
     
305. old RMAN configuration parameters:
     
306. CONFIGURE DEFAULT DEVICE TYPE TO DISK;
     
307. new RMAN configuration parameters:
     
308. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
     
309. new RMAN configuration parameters are successfully stored
     
310. released channel: ORA_DISK_1
     
311. released channel: ORA_DISK_2
     
312. released channel: ORA_DISK_3
     
313. released channel: ORA_DISK_4
     
314. released channel: ORA_DISK_5
     
315. released channel: ORA_DISK_6
     
316. released channel: ORA_DISK_7
     
317. released channel: ORA_DISK_8
     
318. 
     
319. RMAN> backup tag  '1ET_USERS_INCR0' incremental level 0  tablespace users ;
     
320. 
     
321. Starting backup at 2016-06-20:23:55:11
     
322. allocated channel: ORA_SBT_TAPE_1
     
323. channel ORA_SBT_TAPE_1: SID=137 device type=SBT_TAPE
     
324. channel ORA_SBT_TAPE_1: Oracle Secure Backup
     
325. allocated channel: ORA_SBT_TAPE_2
     
326. channel ORA_SBT_TAPE_2: SID=135 device type=SBT_TAPE
     
327. channel ORA_SBT_TAPE_2: Oracle Secure Backup
     
328. allocated channel: ORA_SBT_TAPE_3
     
329. channel ORA_SBT_TAPE_3: SID=197 device type=SBT_TAPE
     
330. channel ORA_SBT_TAPE_3: Oracle Secure Backup
     
331. allocated channel: ORA_SBT_TAPE_4
     
332. channel ORA_SBT_TAPE_4: SID=14 device type=SBT_TAPE
     
333. channel ORA_SBT_TAPE_4: Oracle Secure Backup
     
334. allocated channel: ORA_SBT_TAPE_5
     
335. channel ORA_SBT_TAPE_5: SID=78 device type=SBT_TAPE
     
336. channel ORA_SBT_TAPE_5: Oracle Secure Backup
     
337. allocated channel: ORA_SBT_TAPE_6
     
338. channel ORA_SBT_TAPE_6: SID=140 device type=SBT_TAPE
     
339. channel ORA_SBT_TAPE_6: Oracle Secure Backup
     
340. allocated channel: ORA_SBT_TAPE_7
     
341. channel ORA_SBT_TAPE_7: SID=191 device type=SBT_TAPE
     
342. channel ORA_SBT_TAPE_7: Oracle Secure Backup
     
343. allocated channel: ORA_SBT_TAPE_8
     
344. channel ORA_SBT_TAPE_8: SID=15 device type=SBT_TAPE
     
345. channel ORA_SBT_TAPE_8: Oracle Secure Backup
     
346. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
     
347. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
     
348. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.914101365
     
349. channel ORA_SBT_TAPE_1: starting piece 1 at 2016-06-20:23:55:53
     
350. channel ORA_SBT_TAPE_1: finished piece 1 at 2016-06-20:23:56:18
     
351. piece handle=6or8lfc9_1_1 tag=1ET_USERS_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
     
352. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
     
353. Finished backup at 2016-06-20:23:56:18
     
354. 
     
355. RMAN> exit
     
356. 
     
357. 
     
358. Recovery Manager complete.
     
359. [oracle@station90 ~]$ sqlplus /nolog
     
360. 
     
361. SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 20 23:59:22 2016
     
362. 
     
363. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
     
364. 
     
365. SQL> conn / as sysdba
     
366. Connected.
     
367. SQL> alter system set encryption wallet close identfied "oracle12";
     
368. alter system set encryption wallet close identfied "oracle12"
     
369.                                          *
     
370. ERROR at line 1:
     
371. ORA-28364: invalid wallet operation
     
372. 
     
373. 
     
374. SQL> alter system set encryption wallet close identified "oracle12";
     
375. alter system set encryption wallet close identified "oracle12"
     
376.                                                     *
     
377. ERROR at line 1:
     
378. ORA-28392: invalid close wallet syntax
     
379. 
     
380. 
     
381. SQL> alter system set encryption wallet close identified  by "oracle12";
     
382. 
     
383. System altered.
     
384. 
     
385. SQL> alter database datafile 4 offline;
     
386. 
     
387. Database altered.
     
388. 
     
389. SQL> alter system set encryption wallet open identified  by "oracle12";
     
390. 
     
391. System altered.
     
392. 
     
393. SQL> alter tablespace users online ;
     
394. 
     
395. Tablespace altered.
     
396. 
     
397. SQL> alter system set encryption wallet close  identified  by "oracle12";
     
398. 
     
399. System altered.
     
400. 
     
401. SQL> alter tablespace users online ;
     
402. alter tablespace users online
     
403. *
     
404. ERROR at line 1:
     
405. ORA-01113: file 4 needs media recovery
     
406. ORA-01110: data file 4: '+DATA/orcl/datafile/users.259.915062657'
     
407. 
     
408. 
     
409. SQL> alter tablespace users online ;
     
410. 
     
411. Tablespace altered.
     
412. 
     
413. SQL>
     
414. 
     
415. 
     

复制代码