活动第23/24次（2018-06-02星期六上下午）

botang

做recovery catalog的流程：

1. --SYS
   
2. select * from  dba_tablespaces;
   
3. 
   
4. create tablespace rcat datafile size 50M autoextend on  maxsize 3G;
   
5. 
   
6. create user u87 identified by oracle_4U default tablespace rcat
   
7.   quota unlimited on rcat;
   
8.   
   
9. grant recovery_catalog_owner to u87;

复制代码

1. --U87
   
2. select  * from tab;

复制代码

是空的。

1. [oracle@station87 admin]$ rman catalog  u87/oracle_4U@orcl90
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 2 09:38:41 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. 
   
8. connected to recovery catalog database
   
9. 
   
10. RMAN>
    
11. RMAN> create catalog ;
    
12. 
    
13. recovery catalog created
    
14. 
    
15. RMAN>
    

复制代码

1. --U87
   
2. select * from tab;

复制代码

就有了142个空的表和视图以及一些程序。这些就叫资料档案库。

1. --U87
   
2. select  * from db;

复制代码

空的。

1. [oracle@station87 admin]$ rman   target  / catalog  u87/oracle_4U@orcl90
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 2 09:42:55 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1359978017)
   
8. connected to recovery catalog database
   
9. 
   
10. RMAN> register database;
    
11. 
    
12. database registered in recovery catalog
    
13. starting full resync of recovery catalog
    
14. full resync complete
    
15. 
    
16. RMAN>
    

复制代码

这是目标数据库的控制文件：



这是复制了目标数据库控制文件信息后的CATALOG机器上U87的自己的表：



结论：本地的V$...变成远程的RC...，但是在RC...中为了保持多个注册数据库备份信息的唯一性，备份集号会重新编号:

1. [oracle@station87 admin]$ rman   target  / catalog  u87/oracle_4U@orcl90
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 2 09:42:55 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1359978017)
   
8. connected to recovery catalog database
   
9. 
   
10. RMAN> register database;
    
11. 
    
12. database registered in recovery catalog
    
13. starting full resync of recovery catalog
    
14. full resync complete
    
15. 
    
16. RMAN> exit
    
17. 
    
18. 
    
19. Recovery Manager complete.
    
20. [oracle@station87 admin]$ rman   target  / catalog  u87/oracle_4U@orcl90
    
21. 
    
22. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 2 09:52:45 2018
    
23. 
    
24. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
25. 
    
26. connected to target database: ORCL (DBID=1359978017)
    
27. connected to recovery catalog database
    
28. 
    
29. RMAN> resync catalog;
    
30. 
    
31. starting full resync of recovery catalog
    
32. full resync complete
    
33. 
    
34. RMAN> list backup;
    
35. 
    
36. 
    
37. List of Backup Sets
    
38. ===================
    
39. 
    
40. 
    
41. BS Key  Size       Device Type Elapsed Time Completion Time
    
42. ------- ---------- ----------- ------------ ---------------
    
43. 77      23.50M     DISK        00:00:06     22-NOV-13      
    
44.         BP Key: 88   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_FULL
    
45.         Piece Name: +FRA/orcl/backupset/2013_11_22/annnf0_1d_whole_full_0.261.832198953
    
46. 
    
47.   List of Archived Logs in backup set 77
    
48.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
    
49.   ---- ------- ---------- --------- ---------- ---------
    
50.   1    6       838362     22-NOV-13 846906     22-NOV-13
    
51. 
    
52. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
53. ------- ---- -- ---------- ----------- ------------ ---------------
    
54. 78      Full    69.00M     DISK        00:00:59     22-NOV-13      
    
55.         BP Key: 89   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_FULL
    
56.         Piece Name: +FRA/orcl/backupset/2013_11_22/nnndf0_1d_whole_full_0.264.832198977
    
57.   List of Datafiles in backup set 78
    
58.   File LV Type Ckp SCN    Ckp Time  Name
    
59.   ---- -- ---- ---------- --------- ----
    
60.   5       Full 847289     22-NOV-13 +DATA/orcl/datafile/example.265.832197353
    
61. 
    
62. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
63. ------- ---- -- ---------- ----------- ------------ ---------------
    
64. 79      Full    88.20M     DISK        00:01:18     22-NOV-13      
    
65.         BP Key: 90   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_FULL
    
66.         Piece Name: +FRA/orcl/backupset/2013_11_22/nnndf0_1d_whole_full_0.265.832198999
    
67.   List of Datafiles in backup set 79
    
68.   File LV Type Ckp SCN    Ckp Time  Name
    
69.   ---- -- ---- ---------- --------- ----
    
70.   3       Full 847302     22-NOV-13 +DATA/orcl/datafile/undotbs1.258.832197065
    
71. 
    
72. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
73. ------- ---- -- ---------- ----------- ------------ ---------------
    
74. 80      Full    3.27M      DISK        00:01:09     22-NOV-13      
    
75.         BP Key: 91   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_FULL
    
76.         Piece Name: +FRA/orcl/backupset/2013_11_22/nnndf0_1d_whole_full_0.266.832199027
    
77.   List of Datafiles in backup set 80
    
78.   File LV Type Ckp SCN    Ckp Time  Name
    
79.   ---- -- ---- ---------- --------- ----
    
80.   4       Full 847418     22-NOV-13 +DATA/orcl/datafile/users.259.832197065
    
81. 
    
82. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
83. ------- ---- -- ---------- ----------- ------------ ---------------
    
84. 81      Full    374.35M    DISK        00:02:08     22-NOV-13      
    
85.         BP Key: 92   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_FULL
    
86.         Piece Name: +FRA/orcl/backupset/2013_11_22/nnndf0_1d_whole_full_0.263.832198971
    
87.   List of Datafiles in backup set 81
    
88.   File LV Type Ckp SCN    Ckp Time  Name
    
89.   ---- -- ---- ---------- --------- ----
    
90.   2       Full 847220     22-NOV-13 +DATA/orcl/datafile/sysaux.257.832197065
    
91. 
    
92. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
93. ------- ---- -- ---------- ----------- ------------ ---------------
    
94. 82      Full    587.40M    DISK        00:02:25     22-NOV-13      
    
95.         BP Key: 93   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_FULL
    
96.         Piece Name: +FRA/orcl/backupset/2013_11_22/nnndf0_1d_whole_full_0.262.832198965
    
97.   List of Datafiles in backup set 82
    
98.   File LV Type Ckp SCN    Ckp Time  Name
    
99.   ---- -- ---- ---------- --------- ----
    
100.   1       Full 847210     22-NOV-13 +DATA/orcl/datafile/system.256.832197063
     
101. 
     
102. BS Key  Size       Device Type Elapsed Time Completion Time
     
103. ------- ---------- ----------- ------------ ---------------
     
104. 83      6.12M      DISK        00:00:00     22-NOV-13      
     
105.         BP Key: 94   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_FULL
     
106.         Piece Name: +FRA/orcl/backupset/2013_11_22/annnf0_1d_whole_full_0.268.832199115
     
107. 
     
108.   List of Archived Logs in backup set 83
     
109.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
110.   ---- ------- ---------- --------- ---------- ---------
     
111.   1    7       846906     22-NOV-13 848069     22-NOV-13
     
112. 
     
113. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
114. ------- ---- -- ---------- ----------- ------------ ---------------
     
115. 84      Full    9.36M      DISK        00:00:02     22-NOV-13      
     
116.         BP Key: 95   Status: AVAILABLE  Compressed: NO  Tag: TAG20131122T222515
     
117.         Piece Name: +FRA/orcl/autobackup/2013_11_22/s_832199115.269.832199117
     
118.   SPFILE Included: Modification time: 22-NOV-13
     
119.   SPFILE db_unique_name: ORCL
     
120.   Control File Included: Ckp SCN: 848078       Ckp time: 22-NOV-13
     
121. 
     
122. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
123. ------- ---- -- ---------- ----------- ------------ ---------------
     
124. 85      Full    608.25M    SBT_TAPE    00:01:51     01-JUN-18      
     
125.         BP Key: 96   Status: AVAILABLE  Compressed: NO  Tag: TAG20180601T114101
     
126.         Handle: 09t4bo6e_1_1   Media: station87-000001
     
127.   List of Datafiles in backup set 85
     
128.   File LV Type Ckp SCN    Ckp Time  Name
     
129.   ---- -- ---- ---------- --------- ----
     
130.   1       Full 1013462    01-JUN-18 +DATA/orcl/datafile/system.256.832197063
     
131.   3       Full 1013462    01-JUN-18 +DATA/orcl/datafile/undotbs1.258.832197065
     
132. 
     
133. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
134. ------- ---- -- ---------- ----------- ------------ ---------------
     
135. 86      Full    462.00M    SBT_TAPE    00:01:54     01-JUN-18      
     
136.         BP Key: 97   Status: AVAILABLE  Compressed: NO  Tag: TAG20180601T114101
     
137.         Handle: 0at4bo6e_1_1   Media: station87-000002
     
138.   List of Datafiles in backup set 86
     
139.   File LV Type Ckp SCN    Ckp Time  Name
     
140.   ---- -- ---- ---------- --------- ----
     
141.   2       Full 1013463    01-JUN-18 +DATA/orcl/datafile/sysaux.257.832197065
     
142.   4       Full 1013463    01-JUN-18 +DATA/orcl/datafile/users.259.832197065
     
143.   5       Full 1013463    01-JUN-18 +DATA/orcl/datafile/example.265.832197353
     
144. 
     
145. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
146. ------- ---- -- ---------- ----------- ------------ ---------------
     
147. 87      Full    9.38M      SBT_TAPE    00:00:31     01-JUN-18      
     
148.         BP Key: 98   Status: AVAILABLE  Compressed: NO  Tag: TAG20180601T114257
     
149.         Handle: c-1359978017-20180601-00   Media: station87-000001
     
150.   SPFILE Included: Modification time: 01-JUN-18
     
151.   SPFILE db_unique_name: ORCL
     
152.   Control File Included: Ckp SCN: 1013510      Ckp time: 01-JUN-18
     
153. 
     
154. RMAN> exit
     
155. 
     
156. 
     
157. Recovery Manager complete.
     
158. [oracle@station87 admin]$ rman target  /
     
159. 
     
160. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 2 09:55:19 2018
     
161. 
     
162. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
163. 
     
164. connected to target database: ORCL (DBID=1359978017)
     
165. 
     
166. RMAN> list backup;
     
167. 
     
168. using target database control file instead of recovery catalog
     
169. 
     
170. List of Backup Sets
     
171. ===================
     
172. 
     
173. 
     
174. BS Key  Size       Device Type Elapsed Time Completion Time
     
175. ------- ---------- ----------- ------------ ---------------
     
176. 1       23.50M     DISK        00:00:06     22-NOV-13      
     
177.         BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_FULL
     
178.         Piece Name: +FRA/orcl/backupset/2013_11_22/annnf0_1d_whole_full_0.261.832198953
     
179. 
     
180.   List of Archived Logs in backup set 1
     
181.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
182.   ---- ------- ---------- --------- ---------- ---------
     
183.   1    6       838362     22-NOV-13 846906     22-NOV-13
     
184. 
     
185. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
186. ------- ---- -- ---------- ----------- ------------ ---------------
     
187. 2       Full    69.00M     DISK        00:00:59     22-NOV-13      
     
188.         BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_FULL
     
189.         Piece Name: +FRA/orcl/backupset/2013_11_22/nnndf0_1d_whole_full_0.264.832198977
     
190.   List of Datafiles in backup set 2
     
191.   File LV Type Ckp SCN    Ckp Time  Name
     
192.   ---- -- ---- ---------- --------- ----
     
193.   5       Full 847289     22-NOV-13 +DATA/orcl/datafile/example.265.832197353
     
194. 
     
195. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
196. ------- ---- -- ---------- ----------- ------------ ---------------
     
197. 3       Full    88.20M     DISK        00:01:18     22-NOV-13      
     
198.         BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_FULL
     
199.         Piece Name: +FRA/orcl/backupset/2013_11_22/nnndf0_1d_whole_full_0.265.832198999
     
200.   List of Datafiles in backup set 3
     
201.   File LV Type Ckp SCN    Ckp Time  Name
     
202.   ---- -- ---- ---------- --------- ----
     
203.   3       Full 847302     22-NOV-13 +DATA/orcl/datafile/undotbs1.258.832197065
     
204. 
     
205. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
206. ------- ---- -- ---------- ----------- ------------ ---------------
     
207. 4       Full    3.27M      DISK        00:01:09     22-NOV-13      
     
208.         BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_FULL
     
209.         Piece Name: +FRA/orcl/backupset/2013_11_22/nnndf0_1d_whole_full_0.266.832199027
     
210.   List of Datafiles in backup set 4
     
211.   File LV Type Ckp SCN    Ckp Time  Name
     
212.   ---- -- ---- ---------- --------- ----
     
213.   4       Full 847418     22-NOV-13 +DATA/orcl/datafile/users.259.832197065
     
214. 
     
215. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
216. ------- ---- -- ---------- ----------- ------------ ---------------
     
217. 5       Full    374.35M    DISK        00:02:08     22-NOV-13      
     
218.         BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_FULL
     
219.         Piece Name: +FRA/orcl/backupset/2013_11_22/nnndf0_1d_whole_full_0.263.832198971
     
220.   List of Datafiles in backup set 5
     
221.   File LV Type Ckp SCN    Ckp Time  Name
     
222.   ---- -- ---- ---------- --------- ----
     
223.   2       Full 847220     22-NOV-13 +DATA/orcl/datafile/sysaux.257.832197065
     
224. 
     
225. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
226. ------- ---- -- ---------- ----------- ------------ ---------------
     
227. 6       Full    587.40M    DISK        00:02:25     22-NOV-13      
     
228.         BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_FULL
     
229.         Piece Name: +FRA/orcl/backupset/2013_11_22/nnndf0_1d_whole_full_0.262.832198965
     
230.   List of Datafiles in backup set 6
     
231.   File LV Type Ckp SCN    Ckp Time  Name
     
232.   ---- -- ---- ---------- --------- ----
     
233.   1       Full 847210     22-NOV-13 +DATA/orcl/datafile/system.256.832197063
     
234. 
     
235. BS Key  Size       Device Type Elapsed Time Completion Time
     
236. ------- ---------- ----------- ------------ ---------------
     
237. 7       6.12M      DISK        00:00:00     22-NOV-13      
     
238.         BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: 1D_WHOLE_FULL
     
239.         Piece Name: +FRA/orcl/backupset/2013_11_22/annnf0_1d_whole_full_0.268.832199115
     
240. 
     
241.   List of Archived Logs in backup set 7
     
242.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
243.   ---- ------- ---------- --------- ---------- ---------
     
244.   1    7       846906     22-NOV-13 848069     22-NOV-13
     
245. 
     
246. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
247. ------- ---- -- ---------- ----------- ------------ ---------------
     
248. 8       Full    9.36M      DISK        00:00:02     22-NOV-13      
     
249.         BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20131122T222515
     
250.         Piece Name: +FRA/orcl/autobackup/2013_11_22/s_832199115.269.832199117
     
251.   SPFILE Included: Modification time: 22-NOV-13
     
252.   SPFILE db_unique_name: ORCL
     
253.   Control File Included: Ckp SCN: 848078       Ckp time: 22-NOV-13
     
254. 
     
255. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
256. ------- ---- -- ---------- ----------- ------------ ---------------
     
257. 9       Full    608.25M    SBT_TAPE    00:01:51     01-JUN-18      
     
258.         BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20180601T114101
     
259.         Handle: 09t4bo6e_1_1   Media: station87-000001
     
260.   List of Datafiles in backup set 9
     
261.   File LV Type Ckp SCN    Ckp Time  Name
     
262.   ---- -- ---- ---------- --------- ----
     
263.   1       Full 1013462    01-JUN-18 +DATA/orcl/datafile/system.256.832197063
     
264.   3       Full 1013462    01-JUN-18 +DATA/orcl/datafile/undotbs1.258.832197065
     
265. 
     
266. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
267. ------- ---- -- ---------- ----------- ------------ ---------------
     
268. 10      Full    462.00M    SBT_TAPE    00:01:54     01-JUN-18      
     
269.         BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20180601T114101
     
270.         Handle: 0at4bo6e_1_1   Media: station87-000002
     
271.   List of Datafiles in backup set 10
     
272.   File LV Type Ckp SCN    Ckp Time  Name
     
273.   ---- -- ---- ---------- --------- ----
     
274.   2       Full 1013463    01-JUN-18 +DATA/orcl/datafile/sysaux.257.832197065
     
275.   4       Full 1013463    01-JUN-18 +DATA/orcl/datafile/users.259.832197065
     
276.   5       Full 1013463    01-JUN-18 +DATA/orcl/datafile/example.265.832197353
     
277. 
     
278. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
279. ------- ---- -- ---------- ----------- ------------ ---------------
     
280. 11      Full    9.38M      SBT_TAPE    00:00:31     01-JUN-18      
     
281.         BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20180601T114257
     
282.         Handle: c-1359978017-20180601-00   Media: station87-000001
     
283.   SPFILE Included: Modification time: 01-JUN-18
     
284.   SPFILE db_unique_name: ORCL
     
285.   Control File Included: Ckp SCN: 1013510      Ckp time: 01-JUN-18
     
286. 
     
287. RMAN>
     

复制代码

作为动词的CATALOG，去注册备份片，然后同步远程两个CATALOG；



备份recovery catalog：

1. [oracle@station90 ~]$ expdp system/oracle_4U directory=dir1  dumpfile=u87.dmp schemas=u87

复制代码

恢复recovery catalog：

1. [oracle@station90 ~]$ impdp system/oracle_4U directory=dir1 dumpfile=u87.dmp

复制代码

11.2.0.3的rman客户端建的catalog，如果要导入11.2.0.1的rman客户端建的catalog，需要把后者upgrade catalog：

1. [oracle@station90 ~]$ rman  catalog u87/oracle_4U
   
2. 
   
3. Recovery Manager: Release 11.2.0.3.0 - Production on Sat Jun 2 11:05:28 2018
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to recovery catalog database
   
8. PL/SQL package U87.DBMS_RCVCAT version 11.02.00.01 in RCVCAT database is not current
   
9. PL/SQL package U87.DBMS_RCVMAN version 11.02.00.01 in RCVCAT database is not current
   
10. 
    
11. RMAN> upgrade catalog;
    
12. 
    
13. recovery catalog owner is U87
    
14. enter UPGRADE CATALOG command again to confirm catalog upgrade
    
15. 
    
16. RMAN> upgrade catalog;
    
17. 
    
18. recovery catalog upgraded to version 11.02.00.03
    
19. DBMS_RCVMAN package upgraded to version 11.02.00.03
    
20. DBMS_RCVCAT package upgraded to version 11.02.00.03
    
21. 
    
22. RMAN>
    

复制代码

1. Recovery Manager complete.
   
2. [oracle@station90 ~]$ rman  catalog u870/oracle_4U
   
3. 
   
4. Recovery Manager: Release 11.2.0.3.0 - Production on Sat Jun 2 11:07:49 2018
   
5. 
   
6. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
7. 
   
8. connected to recovery catalog database
   
9. 
   
10. RMAN> import  catalog u87/oracle_4U@orcl;
    
11. 
    
12. Starting import catalog at 2018-06-02:11:07:53
    
13. connected to source recovery catalog database
    
14. import validation complete
    
15. database unregistered from the source recovery catalog
    
16. Finished import catalog at 2018-06-02:11:07:59
    
17. 
    
18. RMAN>
    

复制代码

两个CATALOG之间复制数据，加上"NO UNREGISTER":

1. [oracle@station90 ~]$ rman  catalog u87/oracle_4U
   
2. 
   
3. Recovery Manager: Release 11.2.0.3.0 - Production on Sat Jun 2 11:09:32 2018
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to recovery catalog database
   
8. 
   
9. RMAN> import  catalog u870/oracle_4U@orcl  no unregister;
   
10. 
    
11. Starting import catalog at 2018-06-02:11:09:53
    
12. connected to source recovery catalog database
    
13. import validation complete
    
14. Finished import catalog at 2018-06-02:11:09:55
    
15. 
    
16. RMAN>
    

复制代码

1. [oracle@station87 ~]$ rman target / catalog u87/oracle_4U@orcl90
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 2 11:09:24 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1359978017)
   
8. connected to recovery catalog database
   
9. 
   
10. RMAN> list backup;
    
11. 
    
12. 
    
13. List of Backup Sets
    
14. ===================
    
15. 
    
16. 
    
17. BS Key  Size
    
18. ------- ----------
    
19. 881     494.50K
    
20. 
    
21.   List of Archived Logs in backup set 881
    
22.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
    
23.   ---- ------- ---------- --------- ---------- ---------
    
24.   1    27      1066478    02-JUN-18 1066773    02-JUN-18
    
25. 
    
26.   Backup Set Copy #1 of backup set 881
    
27.   Device Type Elapsed Time Completion Time Compressed Tag
    
28.   ----------- ------------ --------------- ---------- ---
    
29.   DISK        00:00:01     02-JUN-18       NO         TAG20180602T102520
    
30. 
    
31.     List of Backup Pieces for backup set 881 Copy #1
    
32.     BP Key  Pc# Status      Piece Name
    
33.     ------- --- ----------- ----------
    
34.     884     1   AVAILABLE   /home/oracle/0ht4e84g_1_1
    
35. 
    
36.   Backup Set Copy #2 of backup set 881
    
37.   Device Type Elapsed Time Completion Time Compressed Tag
    
38.   ----------- ------------ --------------- ---------- ---
    
39.   DISK        00:00:01     02-JUN-18       NO         TAG20180602T102520
    
40. 
    
41.     List of Backup Pieces for backup set 881 Copy #2
    
42.     BP Key  Pc# Status      Piece Name
    
43.     ------- --- ----------- ----------
    
44.     887     1   AVAILABLE   /home/oracle/xxxx
    
45. 
    
46. BS Key  Size       Device Type Elapsed Time Completion Time
    
47. ------- ---------- ----------- ------------ ---------------
    
48. 882     261.00K    DISK        00:00:00     02-JUN-18      
    
49.         BP Key: 885   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T102541
    
50.         Piece Name: /home/oracle/0jt4e855_1_1
    
51. 
    
52.   List of Archived Logs in backup set 882
    
53.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
    
54.   ---- ------- ---------- --------- ---------- ---------
    
55.   1    28      1066773    02-JUN-18 1066782    02-JUN-18
    
56.   1    29      1066782    02-JUN-18 1067019    02-JUN-18
    
57.   1    30      1067019    02-JUN-18 1067073    02-JUN-18
    
58. 
    
59. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
60. ------- ---- -- ---------- ----------- ------------ ---------------
    
61. 883     Full    9.36M      DISK        00:00:01     02-JUN-18      
    
62.         BP Key: 886   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T102542
    
63.         Piece Name: +FRA/orcl/autobackup/2018_06_02/s_977739942.278.977739943
    
64.   SPFILE Included: Modification time: 02-JUN-18
    
65.   SPFILE db_unique_name: ORCL
    
66.   Control File Included: Ckp SCN: 1067084      Ckp time: 02-JUN-18
    
67. 
    
68. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
69. ------- ---- -- ---------- ----------- ------------ ---------------
    
70. 947     Full    3.31M      SBT_TAPE    00:00:46     02-JUN-18      
    
71.         BP Key: 953   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T104700
    
72.         Handle: 0lt4e9d4_1_1   Media: station87-000003
    
73.   List of Datafiles in backup set 947
    
74.   File LV Type Ckp SCN    Ckp Time  Name
    
75.   ---- -- ---- ---------- --------- ----
    
76.   4       Full 1068770    02-JUN-18 +DATA/orcl/datafile/users.259.832197065
    
77. 
    
78. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
79. ------- ---- -- ---------- ----------- ------------ ---------------
    
80. 948     Full    9.38M      SBT_TAPE    00:00:41     02-JUN-18      
    
81.         BP Key: 954   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T104750
    
82.         Handle: c-1359978017-20180602-02   Media: station87-000003
    
83.   SPFILE Included: Modification time: 02-JUN-18
    
84.   SPFILE db_unique_name: ORCL
    
85.   Control File Included: Ckp SCN: 1068808      Ckp time: 02-JUN-18
    
86. 
    
87. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
88. ------- ---- -- ---------- ----------- ------------ ---------------
    
89. 949     Full    3.31M      SBT_TAPE    00:00:26     02-JUN-18      
    
90.         BP Key: 955   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T105056
    
91.         Handle: 0nt4e9kg_1_1   Media: station87-000003
    
92.   List of Datafiles in backup set 949
    
93.   File LV Type Ckp SCN    Ckp Time  Name
    
94.   ---- -- ---- ---------- --------- ----
    
95.   4       Full 1069050    02-JUN-18 +DATA/orcl/datafile/users.259.832197065
    
96. 
    
97. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
98. ------- ---- -- ---------- ----------- ------------ ---------------
    
99. 950     Full    9.38M      SBT_TAPE    00:00:27     02-JUN-18      
    
100.         BP Key: 956   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T105132
     
101.         Handle: c-1359978017-20180602-03   Media: station87-000003
     
102.   SPFILE Included: Modification time: 02-JUN-18
     
103.   SPFILE db_unique_name: ORCL
     
104.   Control File Included: Ckp SCN: 1069085      Ckp time: 02-JUN-18
     
105. 
     
106. RMAN> exit
     
107. 
     
108. 
     
109. Recovery Manager complete.
     
110. [oracle@station87 ~]$ rman target / catalog u870/oracle_4U@orcl90
     
111. 
     
112. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 2 11:09:36 2018
     
113. 
     
114. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
     
115. 
     
116. connected to target database: ORCL (DBID=1359978017)
     
117. connected to recovery catalog database
     
118. 
     
119. RMAN> list backup;
     
120. 
     
121. 
     
122. List of Backup Sets
     
123. ===================
     
124. 
     
125. 
     
126. BS Key  Size
     
127. ------- ----------
     
128. 639     494.50K
     
129. 
     
130.   List of Archived Logs in backup set 639
     
131.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
132.   ---- ------- ---------- --------- ---------- ---------
     
133.   1    27      1066478    02-JUN-18 1066773    02-JUN-18
     
134. 
     
135.   Backup Set Copy #1 of backup set 639
     
136.   Device Type Elapsed Time Completion Time Compressed Tag
     
137.   ----------- ------------ --------------- ---------- ---
     
138.   DISK        00:00:01     02-JUN-18       NO         TAG20180602T102520
     
139. 
     
140.     List of Backup Pieces for backup set 639 Copy #1
     
141.     BP Key  Pc# Status      Piece Name
     
142.     ------- --- ----------- ----------
     
143.     642     1   AVAILABLE   /home/oracle/0ht4e84g_1_1
     
144. 
     
145.   Backup Set Copy #2 of backup set 639
     
146.   Device Type Elapsed Time Completion Time Compressed Tag
     
147.   ----------- ------------ --------------- ---------- ---
     
148.   DISK        00:00:01     02-JUN-18       NO         TAG20180602T102520
     
149. 
     
150.     List of Backup Pieces for backup set 639 Copy #2
     
151.     BP Key  Pc# Status      Piece Name
     
152.     ------- --- ----------- ----------
     
153.     645     1   AVAILABLE   /home/oracle/xxxx
     
154. 
     
155. BS Key  Size       Device Type Elapsed Time Completion Time
     
156. ------- ---------- ----------- ------------ ---------------
     
157. 640     261.00K    DISK        00:00:00     02-JUN-18      
     
158.         BP Key: 643   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T102541
     
159.         Piece Name: /home/oracle/0jt4e855_1_1
     
160. 
     
161.   List of Archived Logs in backup set 640
     
162.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
     
163.   ---- ------- ---------- --------- ---------- ---------
     
164.   1    28      1066773    02-JUN-18 1066782    02-JUN-18
     
165.   1    29      1066782    02-JUN-18 1067019    02-JUN-18
     
166.   1    30      1067019    02-JUN-18 1067073    02-JUN-18
     
167. 
     
168. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
169. ------- ---- -- ---------- ----------- ------------ ---------------
     
170. 641     Full    9.36M      DISK        00:00:01     02-JUN-18      
     
171.         BP Key: 644   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T102542
     
172.         Piece Name: +FRA/orcl/autobackup/2018_06_02/s_977739942.278.977739943
     
173.   SPFILE Included: Modification time: 02-JUN-18
     
174.   SPFILE db_unique_name: ORCL
     
175.   Control File Included: Ckp SCN: 1067084      Ckp time: 02-JUN-18
     
176. 
     
177. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
178. ------- ---- -- ---------- ----------- ------------ ---------------
     
179. 705     Full    3.31M      SBT_TAPE    00:00:46     02-JUN-18      
     
180.         BP Key: 711   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T104700
     
181.         Handle: 0lt4e9d4_1_1   Media: station87-000003
     
182.   List of Datafiles in backup set 705
     
183.   File LV Type Ckp SCN    Ckp Time  Name
     
184.   ---- -- ---- ---------- --------- ----
     
185.   4       Full 1068770    02-JUN-18 +DATA/orcl/datafile/users.259.832197065
     
186. 
     
187. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
188. ------- ---- -- ---------- ----------- ------------ ---------------
     
189. 706     Full    9.38M      SBT_TAPE    00:00:41     02-JUN-18      
     
190.         BP Key: 712   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T104750
     
191.         Handle: c-1359978017-20180602-02   Media: station87-000003
     
192.   SPFILE Included: Modification time: 02-JUN-18
     
193.   SPFILE db_unique_name: ORCL
     
194.   Control File Included: Ckp SCN: 1068808      Ckp time: 02-JUN-18
     
195. 
     
196. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
197. ------- ---- -- ---------- ----------- ------------ ---------------
     
198. 707     Full    3.31M      SBT_TAPE    00:00:26     02-JUN-18      
     
199.         BP Key: 713   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T105056
     
200.         Handle: 0nt4e9kg_1_1   Media: station87-000003
     
201.   List of Datafiles in backup set 707
     
202.   File LV Type Ckp SCN    Ckp Time  Name
     
203.   ---- -- ---- ---------- --------- ----
     
204.   4       Full 1069050    02-JUN-18 +DATA/orcl/datafile/users.259.832197065
     
205. 
     
206. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
207. ------- ---- -- ---------- ----------- ------------ ---------------
     
208. 708     Full    9.38M      SBT_TAPE    00:00:27     02-JUN-18      
     
209.         BP Key: 714   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T105132
     
210.         Handle: c-1359978017-20180602-03   Media: station87-000003
     
211.   SPFILE Included: Modification time: 02-JUN-18
     
212.   SPFILE db_unique_name: ORCL
     
213.   Control File Included: Ckp SCN: 1069085      Ckp time: 02-JUN-18
     
214. 
     
215. RMAN>
     

复制代码

虚拟专用CATALOG的配置过程：
先创建三个catalog用户：

1. create user u100 identified by oracle_4U default tablespace rcat
   
2. quota unlimited on rcat;
   
3. 
   
4. grant recovery_catalog_owner to u100;
   
5. 
   
6. 
   
7. create user v101 identified by oracle_4U default tablespace rcat
   
8. quota unlimited on rcat;
   
9. 
   
10. grant recovery_catalog_owner to v101;
    
11. 
    
12. create user v102 identified by oracle_4U default tablespace rcat
    
13. quota unlimited on rcat;
    
14. 
    
15. grant recovery_catalog_owner to v102;
    

复制代码

让u100去注册两个target数据库：

1. [oracle@station90 ~]$ rman target / catalog u100/oracle_4U@rcat
   
2. 
   
3. Recovery Manager: Release 12.1.0.2.0 - Production on Sat Jun 2 11:24:08 2018
   
4. 
   
5. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: EMREP (DBID=4188960434)
   
8. connected to recovery catalog database
   
9. 
   
10. RMAN> register database;
    
11. 
    
12. database registered in recovery catalog
    
13. starting full resync of recovery catalog
    
14. full resync complete
    
15. 
    
16. RMAN>
    

复制代码

1. [oracle@station87 ~]$ rman target / catalog u100/oracle_4U@rcat  
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 2 11:24:04 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1359978017)
   
8. connected to recovery catalog database
   
9. 
   
10. RMAN> register database;
    
11. 
    
12. database registered in recovery catalog
    
13. starting full resync of recovery catalog
    
14. full resync complete
    

复制代码

顺便查看一下 U100、V101和V102的db表的情况：

1. [oracle@station90 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 12.1.0.2.0 Production on Sat Jun 2 11:25:05 2018
   
4. 
   
5. Copyright (c) 1982, 2014, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn u100/oracle_4U@rcat
   
8. Connected.
   
9. SQL> select  * from db;
   
10. 
    
11.     DB_KEY        DB_ID REG_DB_UNIQUE_NAME             CURR_DBINC_KEY S
    
12. ---------- ---------- ------------------------------ -------------- -
    
13.         77 1359978017 ORCL                                         78 N
    
14.          1 4188960434 EMREP                                          2 N
    
15. 
    
16. SQL> conn v101/oracle_4U@rcat
    
17. Connected.
    
18. SQL> select  * from db;
    
19. select        * from db
    
20.                *
    
21. ERROR at line 1:
    
22. ORA-00942: table or view does not exist
    
23. 
    
24. 
    
25. SQL> conn v102/oracle_4U@rcat
    
26. Connected.
    
27. SQL> select  * from db;
    
28. select        * from db
    
29.                *
    
30. ERROR at line 1:
    
31. ORA-00942: table or view does not exist
    
32. 
    
33. 
    
34. SQL>
    

复制代码

从U100开始分（1Z0-053书上3-28幻灯的3b分支）：

1. [oracle@station90 ~]$ rman catalog u100/oracle_4U@rcat
   
2. 
   
3. Recovery Manager: Release 12.1.0.2.0 - Production on Sat Jun 2 11:30:59 2018
   
4. 
   
5. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to recovery catalog database
   
8. 
   
9. 
   
10. RMAN> grant catalog for database 4188960434 to v101;
    
11. 
    
12. Grant succeeded.
    
13. 
    
14. RMAN> grant catalog for database 1359978017 to v102;
    
15. 
    
16. Grant succeeded.
    
17. 
    
18. RMAN>
    

复制代码

顺便查看一下 U100、V101和V102的db表的情况：

1. [oracle@station90 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 12.1.0.2.0 Production on Sat Jun 2 11:32:52 2018
   
4. 
   
5. Copyright (c) 1982, 2014, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn u100/oracle_4U@rcat
   
8. Connected.
   
9. SQL> select  * from db;
   
10. 
    
11.     DB_KEY        DB_ID REG_DB_UNIQUE_NAME             CURR_DBINC_KEY S
    
12. ---------- ---------- ------------------------------ -------------- -
    
13.         77 1359978017 ORCL                                         78 N
    
14.          1 4188960434 EMREP                                          2 N
    
15. 
    
16. SQL> conn v101/oracle_4U@rcat
    
17. Connected.
    
18. SQL> select  * from db;
    
19. 
    
20.     DB_KEY        DB_ID REG_DB_UNIQUE_NAME             CURR_DBINC_KEY S
    
21. ---------- ---------- ------------------------------ -------------- -
    
22.          1 4188960434 EMREP                                          2 N
    
23. 
    
24. SQL> conn v102/oracle_4U@rcat
    
25. Connected.
    
26. SQL> select  * from db;
    
27. 
    
28.     DB_KEY        DB_ID REG_DB_UNIQUE_NAME             CURR_DBINC_KEY S
    
29. ---------- ---------- ------------------------------ -------------- -
    
30.         77 1359978017 ORCL                                         78 N
    
31. 
    
32. SQL>
    

复制代码

开始用V101和V102：

1. [oracle@station90 ~]$ rman catalog v101/oracle_4U@rcat
   
2. 
   
3. Recovery Manager: Release 12.1.0.2.0 - Production on Sat Jun 2 11:35:42 2018
   
4. 
   
5. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to recovery catalog database
   
8. RMAN-07540: Cleanup is required for the VPC user schema
   
9. 
   
10. RMAN> create virtual catalog;
    
11. 
    
12. found eligible base catalog owned by U100
    
13. found ineligible base catalog owned by U90
    
14. created virtual catalog against base catalog owned by U100
    
15. 
    
16. RMAN> exit
    
17. 
    
18. 
    
19. Recovery Manager complete.
    
20. [oracle@station90 ~]$ rman catalog v102/oracle_4U@rcat
    
21. 
    
22. Recovery Manager: Release 12.1.0.2.0 - Production on Sat Jun 2 11:35:55 2018
    
23. 
    
24. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
    
25. 
    
26. connected to recovery catalog database
    
27. RMAN-07540: Cleanup is required for the VPC user schema
    
28. 
    
29. RMAN> create virtual catalog;
    
30. 
    
31. found ineligible base catalog owned by U90
    
32. found eligible base catalog owned by U100
    
33. created virtual catalog against base catalog owned by U100
    
34. 
    
35. RMAN>
    

复制代码

1. [oracle@station90 ~]$ rman target / catalog v101/oracle_4U@rcat
   
2. 
   
3. Recovery Manager: Release 12.1.0.2.0 - Production on Sat Jun 2 11:37:53 2018
   
4. 
   
5. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: EMREP (DBID=4188960434)
   
8. connected to recovery catalog database
   
9. RMAN-07540: Cleanup is required for the VPC user schema
   
10. 
    
11. RMAN> backup tablespace users;
    
12. 
    
13. Starting backup at 2018-06-02:11:38:00
    
14. allocated channel: ORA_DISK_1
    
15. channel ORA_DISK_1: SID=417 device type=DISK
    
16. channel ORA_DISK_1: starting full datafile backup set
    
17. channel ORA_DISK_1: specifying datafile(s) in backup set
    
18. input datafile file number=00004 name=/u01/app/oracle/oradata/emrep/users01.dbf
    
19. channel ORA_DISK_1: starting piece 1 at 2018-06-02:11:38:08
    
20. channel ORA_DISK_1: finished piece 1 at 2018-06-02:11:38:09
    
21. piece handle=/u01/app/oracle/fast_recovery_area/EMREP/backupset/2018_06_02/o1_mf_nnndf_TAG20180602T113807_fk44907x_.bkp tag=TAG20180602T113807 comment=NONE
    
22. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    
23. Finished backup at 2018-06-02:11:38:09
    
24. 
    
25. RMAN> exit
    
26. 
    
27. 
    
28. Recovery Manager complete.
    
29. exit[oracle@station90 ~]$ rman target / catalog u100/oracle_4U@rcat
    
30. 
    
31. Recovery Manager: Release 12.1.0.2.0 - Production on Sat Jun 2 11:38:25 2018
    
32. 
    
33. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
    
34. 
    
35. connected to target database: EMREP (DBID=4188960434)
    
36. connected to recovery catalog database
    
37. 
    
38. RMAN> list backup of tablespace users;
    
39. 
    
40. 
    
41. List of Backup Sets
    
42. ===================
    
43. 
    
44. 
    
45. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
46. ------- ---- -- ---------- ----------- ------------ -------------------
    
47. 307     Full    1.34M      DISK        00:00:01     2018-06-02:11:38:08
    
48.         BP Key: 308   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T113807
    
49.         Piece Name: /u01/app/oracle/fast_recovery_area/EMREP/backupset/2018_06_02/o1_mf_nnndf_TAG20180602T113807_fk44907x_.bkp
    
50.   List of Datafiles in backup set 307
    
51.   File LV Type Ckp SCN    Ckp Time            Name
    
52.   ---- -- ---- ---------- ------------------- ----
    
53.   4       Full 4985341    2018-06-02:11:38:08 /u01/app/oracle/oradata/emrep/users01.dbf
    
54. 
    
55. RMAN>
    
56. 
    

复制代码

1. [oracle@station87 ~]$ rman target / catalog v102/oracle_4U@rcat
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 2 11:36:44 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1359978017)
   
8. connected to recovery catalog database
   
9. 
   
10. RMAN> backup tablespace users;
    
11. 
    
12. Starting backup at 02-JUN-18
    
13. allocated channel: ORA_SBT_TAPE_1
    
14. channel ORA_SBT_TAPE_1: SID=77 device type=SBT_TAPE
    
15. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
16. allocated channel: ORA_SBT_TAPE_2
    
17. channel ORA_SBT_TAPE_2: SID=19 device type=SBT_TAPE
    
18. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
19. channel ORA_SBT_TAPE_1: starting full datafile backup set
    
20. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
21. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.832197065
    
22. channel ORA_SBT_TAPE_1: starting piece 1 at 02-JUN-18
    
23. channel ORA_SBT_TAPE_1: finished piece 1 at 02-JUN-18
    
24. piece handle=0pt4ecb4_1_1 tag=TAG20180602T113708 comment=API Version 2.0,MMS Version 10.3.0.2
    
25. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:55
    
26. Finished backup at 02-JUN-18
    
27. 
    
28. Starting Control File and SPFILE Autobackup at 02-JUN-18
    
29. piece handle=c-1359978017-20180602-04 comment=API Version 2.0,MMS Version 10.3.0.2
    
30. Finished Control File and SPFILE Autobackup at 02-JUN-18
    
31. 
    
32. RMAN> exit
    
33. 
    
34. 
    
35. Recovery Manager complete.
    
36. exit[oracle@station87 ~]$ rman target / catalog u100/oracle_4U@rcat
    
37. 
    
38. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 2 11:39:14 2018
    
39. 
    
40. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
41. 
    
42. connected to target database: ORCL (DBID=1359978017)
    
43. connected to recovery catalog database
    
44. 
    
45. RMAN> list backup of tablespace users;
    
46. 
    
47. 
    
48. List of Backup Sets
    
49. ===================
    
50. 
    
51. 
    
52. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
53. ------- ---- -- ---------- ----------- ------------ ---------------
    
54. 219     Full    3.31M      SBT_TAPE    00:00:46     02-JUN-18      
    
55.         BP Key: 227   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T104700
    
56.         Handle: 0lt4e9d4_1_1   Media: station87-000003
    
57.   List of Datafiles in backup set 219
    
58.   File LV Type Ckp SCN    Ckp Time  Name
    
59.   ---- -- ---- ---------- --------- ----
    
60.   4       Full 1068770    02-JUN-18 +DATA/orcl/datafile/users.259.832197065
    
61. 
    
62. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
63. ------- ---- -- ---------- ----------- ------------ ---------------
    
64. 221     Full    3.31M      SBT_TAPE    00:00:26     02-JUN-18      
    
65.         BP Key: 229   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T105056
    
66.         Handle: 0nt4e9kg_1_1   Media: station87-000003
    
67.   List of Datafiles in backup set 221
    
68.   File LV Type Ckp SCN    Ckp Time  Name
    
69.   ---- -- ---- ---------- --------- ----
    
70.   4       Full 1069050    02-JUN-18 +DATA/orcl/datafile/users.259.832197065
    
71. 
    
72. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
73. ------- ---- -- ---------- ----------- ------------ ---------------
    
74. 320     Full    3.31M      SBT_TAPE    00:00:46     02-JUN-18      
    
75.         BP Key: 323   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T113708
    
76.         Handle: 0pt4ecb4_1_1   Media: station87-000003
    
77.   List of Datafiles in backup set 320
    
78.   File LV Type Ckp SCN    Ckp Time  Name
    
79.   ---- -- ---- ---------- --------- ----
    
80.   4       Full 1072634    02-JUN-18 +DATA/orcl/datafile/users.259.832197065
    
81. 
    
82. RMAN>
    

复制代码

另外一种实现 虚拟专用catalog的做法是：


先创建三个catalog用户：

1. create user u200 identified by oracle_4U default tablespace rcat
   
2. quota unlimited on rcat;
   
3. 
   
4. grant recovery_catalog_owner to u200;
   
5. 
   
6. 
   
7. create user v201 identified by oracle_4U default tablespace rcat
   
8. quota unlimited on rcat;
   
9. 
   
10. grant recovery_catalog_owner to v201;
    
11. 
    
12. create user v202 identified by oracle_4U default tablespace rcat
    
13. quota unlimited on rcat;
    
14. 
    
15. grant recovery_catalog_owner to v202;
    

复制代码

1. [oracle@station90 ~]$ rman catalog u200/oracle_4U@rcat
   
2. 
   
3. Recovery Manager: Release 12.1.0.2.0 - Production on Sat Jun 2 11:44:48 2018
   
4. 
   
5. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to recovery catalog database
   
8. 
   
9. RMAN> create catalog;
   
10. 
    
11. recovery catalog created
    
12. 
    
13. RMAN> grant register database to v201;
    
14. 
    
15. Grant succeeded.
    
16. 
    
17. RMAN> grant register database to v202;
    
18. 
    
19. Grant succeeded.
    
20. 
    
21. RMAN>
    

复制代码

两个虚拟用户出动：

1. [oracle@station90 ~]$ rman catalog v201/oracle_4U@rcat
   
2. 
   
3. Recovery Manager: Release 12.1.0.2.0 - Production on Sat Jun 2 11:46:09 2018
   
4. 
   
5. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to recovery catalog database
   
8. RMAN-07540: Cleanup is required for the VPC user schema
   
9. 
   
10. RMAN> create virtual catalog;  
    
11. 
    
12. found eligible base catalog owned by U200
    
13. found ineligible base catalog owned by U100
    
14. found ineligible base catalog owned by U90
    
15. created virtual catalog against base catalog owned by U200
    
16. 
    
17. RMAN> exit
    
18. 
    
19. 
    
20. Recovery Manager complete.
    
21. [oracle@station90 ~]$ rman catalog v202/oracle_4U@rcat
    
22. 
    
23. Recovery Manager: Release 12.1.0.2.0 - Production on Sat Jun 2 11:46:38 2018
    
24. 
    
25. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
    
26. 
    
27. connected to recovery catalog database
    
28. RMAN-07540: Cleanup is required for the VPC user schema
    
29. 
    
30. RMAN> create virtual catalog;  
    
31. 
    
32. found ineligible base catalog owned by U90
    
33. found ineligible base catalog owned by U100
    
34. found eligible base catalog owned by U200
    
35. created virtual catalog against base catalog owned by U200
    
36. 
    
37. RMAN>
    

复制代码

V201去注册emrep：

1. [oracle@station90 ~]$ rman target / catalog v201/oracle_4U@rcat
   
2. 
   
3. Recovery Manager: Release 12.1.0.2.0 - Production on Sat Jun 2 11:47:47 2018
   
4. 
   
5. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: EMREP (DBID=4188960434)
   
8. connected to recovery catalog database
   
9. RMAN-07540: Cleanup is required for the VPC user schema
   
10. 
    
11. RMAN> register database;
    
12. 
    
13. database registered in recovery catalog
    
14. starting full resync of recovery catalog
    
15. full resync complete
    
16. 
    
17. RMAN> exit
    
18. 
    
19. 
    
20. Recovery Manager complete.
    
21. [oracle@station90 ~]$ rman target / catalog u200/oracle_4U@rcat
    
22. 
    
23. Recovery Manager: Release 12.1.0.2.0 - Production on Sat Jun 2 11:48:18 2018
    
24. 
    
25. Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
    
26. 
    
27. connected to target database: EMREP (DBID=4188960434)
    
28. connected to recovery catalog database
    
29. 
    
30. RMAN> list backup;
    
31. 
    
32. 
    
33. List of Backup Sets
    
34. ===================
    
35. 
    
36. 
    
37. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
38. ------- ---- -- ---------- ----------- ------------ -------------------
    
39. 84      Full    1.34M      DISK        00:00:01     2018-06-02:11:38:08
    
40.         BP Key: 85   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T113807
    
41.         Piece Name: /u01/app/oracle/fast_recovery_area/EMREP/backupset/2018_06_02/o1_mf_nnndf_TAG20180602T113807_fk44907x_.bkp
    
42.   List of Datafiles in backup set 84
    
43.   File LV Type Ckp SCN    Ckp Time            Name
    
44.   ---- -- ---- ---------- ------------------- ----
    
45.   4       Full 4985341    2018-06-02:11:38:08 /u01/app/oracle/oradata/emrep/users01.dbf
    
46. 
    
47. RMAN>
    

复制代码

V202去注册orcl：

1. [oracle@station87 ~]$ rman target / catalog v202/oracle_4U@rcat
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 2 11:48:42 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1359978017)
   
8. connected to recovery catalog database
   
9. 
   
10. RMAN> register database;
    
11. 
    
12. database registered in recovery catalog
    
13. starting full resync of recovery catalog
    
14. full resync complete
    
15. 
    
16. RMAN> exit
    
17. 
    
18. 
    
19. Recovery Manager complete.
    
20. [oracle@station87 ~]$ rman target / catalog u200/oracle_4U@rcat
    
21. 
    
22. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Jun 2 11:49:14 2018
    
23. 
    
24. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
25. 
    
26. connected to target database: ORCL (DBID=1359978017)
    
27. connected to recovery catalog database
    
28. 
    
29. RMAN> list backup;
    
30. 
    
31. 
    
32. List of Backup Sets
    
33. ===================
    
34. 
    
35. 
    
36. BS Key  Size
    
37. ------- ----------
    
38. 234     494.50K
    
39. 
    
40.   List of Archived Logs in backup set 234
    
41.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
    
42.   ---- ------- ---------- --------- ---------- ---------
    
43.   1    27      1066478    02-JUN-18 1066773    02-JUN-18
    
44. 
    
45.   Backup Set Copy #1 of backup set 234
    
46.   Device Type Elapsed Time Completion Time Compressed Tag
    
47.   ----------- ------------ --------------- ---------- ---
    
48.   DISK        00:00:01     02-JUN-18       NO         TAG20180602T102520
    
49. 
    
50.     List of Backup Pieces for backup set 234 Copy #1
    
51.     BP Key  Pc# Status      Piece Name
    
52.     ------- --- ----------- ----------
    
53.     243     1   AVAILABLE   /home/oracle/0ht4e84g_1_1
    
54. 
    
55.   Backup Set Copy #2 of backup set 234
    
56.   Device Type Elapsed Time Completion Time Compressed Tag
    
57.   ----------- ------------ --------------- ---------- ---
    
58.   DISK        00:00:01     02-JUN-18       NO         TAG20180602T102520
    
59. 
    
60.     List of Backup Pieces for backup set 234 Copy #2
    
61.     BP Key  Pc# Status      Piece Name
    
62.     ------- --- ----------- ----------
    
63.     246     1   AVAILABLE   /home/oracle/xxxx
    
64. 
    
65. BS Key  Size       Device Type Elapsed Time Completion Time
    
66. ------- ---------- ----------- ------------ ---------------
    
67. 235     261.00K    DISK        00:00:00     02-JUN-18      
    
68.         BP Key: 244   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T102541
    
69.         Piece Name: /home/oracle/0jt4e855_1_1
    
70. 
    
71.   List of Archived Logs in backup set 235
    
72.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
    
73.   ---- ------- ---------- --------- ---------- ---------
    
74.   1    28      1066773    02-JUN-18 1066782    02-JUN-18
    
75.   1    29      1066782    02-JUN-18 1067019    02-JUN-18
    
76.   1    30      1067019    02-JUN-18 1067073    02-JUN-18
    
77. 
    
78. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
79. ------- ---- -- ---------- ----------- ------------ ---------------
    
80. 236     Full    9.36M      DISK        00:00:01     02-JUN-18      
    
81.         BP Key: 245   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T102542
    
82.         Piece Name: +FRA/orcl/autobackup/2018_06_02/s_977739942.278.977739943
    
83.   SPFILE Included: Modification time: 02-JUN-18
    
84.   SPFILE db_unique_name: ORCL
    
85.   Control File Included: Ckp SCN: 1067084      Ckp time: 02-JUN-18
    
86. 
    
87. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
88. ------- ---- -- ---------- ----------- ------------ ---------------
    
89. 237     Full    3.31M      SBT_TAPE    00:00:46     02-JUN-18      
    
90.         BP Key: 247   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T104700
    
91.         Handle: 0lt4e9d4_1_1   Media: station87-000003
    
92.   List of Datafiles in backup set 237
    
93.   File LV Type Ckp SCN    Ckp Time  Name
    
94.   ---- -- ---- ---------- --------- ----
    
95.   4       Full 1068770    02-JUN-18 +DATA/orcl/datafile/users.259.832197065
    
96. 
    
97. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
    
98. ------- ---- -- ---------- ----------- ------------ ---------------
    
99. 238     Full    9.38M      SBT_TAPE    00:00:41     02-JUN-18      
    
100.         BP Key: 248   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T104750
     
101.         Handle: c-1359978017-20180602-02   Media: station87-000003
     
102.   SPFILE Included: Modification time: 02-JUN-18
     
103.   SPFILE db_unique_name: ORCL
     
104.   Control File Included: Ckp SCN: 1068808      Ckp time: 02-JUN-18
     
105. 
     
106. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
107. ------- ---- -- ---------- ----------- ------------ ---------------
     
108. 239     Full    3.31M      SBT_TAPE    00:00:26     02-JUN-18      
     
109.         BP Key: 249   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T105056
     
110.         Handle: 0nt4e9kg_1_1   Media: station87-000003
     
111.   List of Datafiles in backup set 239
     
112.   File LV Type Ckp SCN    Ckp Time  Name
     
113.   ---- -- ---- ---------- --------- ----
     
114.   4       Full 1069050    02-JUN-18 +DATA/orcl/datafile/users.259.832197065
     
115. 
     
116. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
117. ------- ---- -- ---------- ----------- ------------ ---------------
     
118. 240     Full    9.38M      SBT_TAPE    00:00:27     02-JUN-18      
     
119.         BP Key: 250   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T105132
     
120.         Handle: c-1359978017-20180602-03   Media: station87-000003
     
121.   SPFILE Included: Modification time: 02-JUN-18
     
122.   SPFILE db_unique_name: ORCL
     
123.   Control File Included: Ckp SCN: 1069085      Ckp time: 02-JUN-18
     
124. 
     
125. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
126. ------- ---- -- ---------- ----------- ------------ ---------------
     
127. 241     Full    3.31M      SBT_TAPE    00:00:46     02-JUN-18      
     
128.         BP Key: 251   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T113708
     
129.         Handle: 0pt4ecb4_1_1   Media: station87-000003
     
130.   List of Datafiles in backup set 241
     
131.   File LV Type Ckp SCN    Ckp Time  Name
     
132.   ---- -- ---- ---------- --------- ----
     
133.   4       Full 1072634    02-JUN-18 +DATA/orcl/datafile/users.259.832197065
     
134. 
     
135. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
     
136. ------- ---- -- ---------- ----------- ------------ ---------------
     
137. 242     Full    9.38M      SBT_TAPE    00:00:36     02-JUN-18      
     
138.         BP Key: 252   Status: AVAILABLE  Compressed: NO  Tag: TAG20180602T113806
     
139.         Handle: c-1359978017-20180602-04   Media: station87-000003
     
140.   SPFILE Included: Modification time: 02-JUN-18
     
141.   SPFILE db_unique_name: ORCL
     
142.   Control File Included: Ckp SCN: 1072682      Ckp time: 02-JUN-18
     
143. 
     
144. RMAN>
     

复制代码

一个备份集下面开多个备份片（控制单个备份片的大小）：

1. RMAN> run {
   
2. 2> allocate channel c1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)'  maxpiecesize 200M;                           
   
3. 3> backup tag '2T_SYSTEM_INCR0'  copies 1 incremental level 0  tablespace system;
   
4. 4> release channel c1;
   
5. 5> }
   

复制代码

磁盘份数备份：

1. RMAN> run {
   
2. 2> allocate channel c1 device type  disk format '/home/oracle/dir1/%U','/home/oracle/dir2/%U';
   
3. 3> backup tag '3D_USERS_INCR0' copies 2  incremental level 0 tablespace users force ;
   
4. 4> release channel c1;
   
5. 5> }
   
6. 
   
7. allocated channel: c1
   
8. channel c1: SID=8 device type=DISK
   
9. 
   
10. Starting backup at 2018-06-08:00:38:35
    
11. channel c1: starting incremental level 0 datafile backup set
    
12. channel c1: specifying datafile(s) in backup set
    
13. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.832197065
    
14. channel c1: starting piece 1 at 2018-06-08:00:38:35
    
15. channel c1: finished piece 1 at 2018-06-08:00:38:36 with 2 copies and tag 3D_USERS_INCR0
    
16. piece handle=/home/oracle/dir1/24t4t00b_1_1 comment=NONE
    
17. piece handle=/home/oracle/dir2/24t4t00b_1_2 comment=NONE
    
18. channel c1: backup set complete, elapsed time: 00:00:01
    
19. Finished backup at 2018-06-08:00:38:36
    
20. 
    
21. Starting Control File and SPFILE Autobackup at 2018-06-08:00:38:36
    
22. piece handle=+FRA/orcl/autobackup/2018_06_08/s_978223116.276.978223117 comment=NONE
    
23. Finished Control File and SPFILE Autobackup at 2018-06-08:00:38:39
    
24. 
    
25. released channel: c1
    
26. 
    
27. RMAN>
    

复制代码

永久排除某个表空间在全库备份之外：

1. RMAN> configure exclude for tablespace users;
   
2. 
   
3. Tablespace USERS will be excluded from future whole database backups
   
4. new RMAN configuration parameters are successfully stored
   
5. 
   
6. RMAN> show all;
   
7. 
   
8. RMAN configuration parameters for database with db_unique_name ORCL are:
   
9. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
   
10. CONFIGURE BACKUP OPTIMIZATION ON;
    
11. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
    
12. CONFIGURE CONTROLFILE AUTOBACKUP ON;
    
13. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    
14. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
    
15. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
    
16. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
    
17. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 2;
    
18. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
19. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
20. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
21. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
    
22. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
    
23. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    
24. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    
25. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    
26. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
    
27. CONFIGURE EXCLUDE FOR TABLESPACE 'USERS';
    
28. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    
29. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
    
30. 
    
31. RMAN>
    

复制代码

（顺便提下：在通道不够的时候，份数备份会pending等待资源，等上一轮释放，下一轮会执行：

）

取消exclude：

1. RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' clear;
   
2. 
   
3. old RMAN configuration parameters:
   
4. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 2;
   
5. RMAN configuration parameters are successfully reset to default value
   
6. 
   
7. RMAN> show all;
   
8. 
   
9. RMAN configuration parameters for database with db_unique_name ORCL are:
   
10. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
    
11. CONFIGURE BACKUP OPTIMIZATION ON;
    
12. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
    
13. CONFIGURE CONTROLFILE AUTOBACKUP ON;
    
14. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    
15. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
    
16. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
    
17. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
    
18. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
19. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
20. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
21. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
22. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
    
23. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
    
24. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    
25. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    
26. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    
27. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
    
28. CONFIGURE EXCLUDE FOR TABLESPACE 'USERS';
    
29. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    
30. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
    
31. 
    
32. RMAN> CONFIGURE EXCLUDE FOR TABLESPACE 'USERS' clear;
    
33. 
    
34. Tablespace USERS will be included in future whole database backups
    
35. old RMAN configuration parameters are successfully deleted
    
36. 
    
37. RMAN>
    
38. 
    

复制代码

压缩备份：
例子：SYSAUX表空间原有560M，不压缩备份436M（完成时间00:01:00），BASIC压缩86.5M（00:00:53）

1. [oracle@station87 ~]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Fri Jun 8 01:06:43 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: ORCL (DBID=1359978017)
   
8. 
   
9. RMAN> backup  tag '1T_SYSAUX_INCR0' incremental level 0 tablespace sysaux;
   
10. 
    
11. Starting backup at 2018-06-08:01:07:06
    
12. using target database control file instead of recovery catalog
    
13. allocated channel: ORA_SBT_TAPE_1
    
14. channel ORA_SBT_TAPE_1: SID=79 device type=SBT_TAPE
    
15. channel ORA_SBT_TAPE_1: Oracle Secure Backup
    
16. allocated channel: ORA_SBT_TAPE_2
    
17. channel ORA_SBT_TAPE_2: SID=138 device type=SBT_TAPE
    
18. channel ORA_SBT_TAPE_2: Oracle Secure Backup
    
19. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
    
20. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
21. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.832197065
    
22. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-08:01:07:17
    
23. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-08:01:08:22
    
24. piece handle=2ct4t1m5_1_1 tag=1T_SYSAUX_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
    
25. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:05
    
26. Finished backup at 2018-06-08:01:08:22
    
27. 
    
28. Starting Control File and SPFILE Autobackup at 2018-06-08:01:08:22
    
29. piece handle=c-1359978017-20180608-07 comment=API Version 2.0,MMS Version 10.3.0.2
    
30. Finished Control File and SPFILE Autobackup at 2018-06-08:01:09:07
    
31. 
    
32. RMAN> list backup;
    
33. 
    
34. 
    
35. List of Backup Sets
    
36. ===================
    
37. 
    
38. 
    
39. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
40. ------- ---- -- ---------- ----------- ------------ -------------------
    
41. 65      Incr 0  436.25M    SBT_TAPE    00:01:00     2018-06-08:01:08:17
    
42.         BP Key: 71   Status: AVAILABLE  Compressed: NO  Tag: 1T_SYSAUX_INCR0
    
43.         Handle: 2ct4t1m5_1_1   Media: station87-000008
    
44.   List of Datafiles in backup set 65
    
45.   File LV Type Ckp SCN    Ckp Time            Name
    
46.   ---- -- ---- ---------- ------------------- ----
    
47.   2    0  Incr 1155660    2018-06-08:01:07:17 +DATA/orcl/datafile/sysaux.257.832197065
    
48. 
    
49. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
    
50. ------- ---- -- ---------- ----------- ------------ -------------------
    
51. 66      Full    10.00M     SBT_TAPE    00:00:39     2018-06-08:01:09:01
    
52.         BP Key: 72   Status: AVAILABLE  Compressed: NO  Tag: TAG20180608T010822
    
53.         Handle: c-1359978017-20180608-07   Media: station87-000008
    
54.   SPFILE Included: Modification time: 2018-06-08:01:07:07
    
55.   SPFILE db_unique_name: ORCL
    
56.   Control File Included: Ckp SCN: 1155709      Ckp time: 2018-06-08:01:08:22
    
57. 
    
58. RMAN> show all;
    
59. 
    
60. RMAN configuration parameters for database with db_unique_name ORCL are:
    
61. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
    
62. CONFIGURE BACKUP OPTIMIZATION ON;
    
63. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
    
64. CONFIGURE CONTROLFILE AUTOBACKUP ON;
    
65. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    
66. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
    
67. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
    
68. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
    
69. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
70. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
71. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
72. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
73. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
    
74. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
    
75. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    
76. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    
77. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    
78. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
    
79. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    
80. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
    
81. 
    
82. RMAN> backup tag '2TC_SYSAUX_INCR0' as compressed backupset  incremental level 0 tablespace sysaux;   
    
83. 
    
84. Starting backup at 2018-06-08:01:12:06
    
85. using channel ORA_SBT_TAPE_1
    
86. using channel ORA_SBT_TAPE_2
    
87. channel ORA_SBT_TAPE_1: starting compressed incremental level 0 datafile backup set
    
88. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
89. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.832197065
    
90. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-08:01:12:07
    
91. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-08:01:13:02
    
92. piece handle=2et4t1v7_1_1 tag=2TC_SYSAUX_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
    
93. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:55
    
94. Finished backup at 2018-06-08:01:13:02
    
95. 
    
96. Starting Control File and SPFILE Autobackup at 2018-06-08:01:13:02
    
97. piece handle=c-1359978017-20180608-08 comment=API Version 2.0,MMS Version 10.3.0.2
    
98. Finished Control File and SPFILE Autobackup at 2018-06-08:01:13:47
    
99. 
    
100. RMAN> list backup tag '2TC_SYSAUX_INCR0';
     
101. 
     
102. 
     
103. List of Backup Sets
     
104. ===================
     
105. 
     
106. 
     
107. BS Key  Type LV Size       Device Type Elapsed Time Completion Time   
     
108. ------- ---- -- ---------- ----------- ------------ -------------------
     
109. 67      Incr 0  86.50M     SBT_TAPE    00:00:53     2018-06-08:01:13:00
     
110.         BP Key: 73   Status: AVAILABLE  Compressed: YES  Tag: 2TC_SYSAUX_INCR0
     
111.         Handle: 2et4t1v7_1_1   Media: station87-000008
     
112.   List of Datafiles in backup set 67
     
113.   File LV Type Ckp SCN    Ckp Time            Name
     
114.   ---- -- ---- ---------- ------------------- ----
     
115.   2    0  Incr 1155986    2018-06-08:01:12:07 +DATA/orcl/datafile/sysaux.257.832197065
     
116. 
     
117. RMAN>
     

复制代码

RMAN加密备份：
先做TDE：

1. SQL> select  * from v$encryption_wallet;
   
2. 
   
3. WRL_TYPE
   
4. --------------------
   
5. WRL_PARAMETER
   
6. --------------------------------------------------------------------------------
   
7. STATUS
   
8. ------------------
   
9. file
   
10. /u01/app/oracle/admin/orcl/wallet
    
11. CLOSED
    

复制代码

1. [oracle@station87 ~]$ ls -l /u01/app/oracle/admin/orcl/wallet/                                 
   
2. ls: /u01/app/oracle/admin/orcl/wallet/: No such file or directory
   
3. [oracle@station87 ~]$ mkdir -p /u01/app/oracle/admin/orcl/wallet/
   

复制代码

1. [oracle@station87 ~]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 8 01:34:55 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn / as sysdba
   
8. Connected.
   
9. SQL> alter system set encryption key identified by "oracle123";
   
10. 
    
11. System altered.
    
12. 
    
13. SQL> select  * from v$encryption_wallet;
    
14. 
    
15. WRL_TYPE
    
16. --------------------
    
17. WRL_PARAMETER
    
18. --------------------------------------------------------------------------------
    
19. STATUS
    
20. ------------------
    
21. file
    
22. /u01/app/oracle/admin/orcl/wallet
    
23. OPEN
    
24. 
    
25. 
    
26. SQL>
    

复制代码

1. [oracle@station87 ~]$ ls -l /u01/app/oracle/admin/orcl/wallet/
   
2. total 4
   
3. -rw-r--r-- 1 oracle asmadmin 1573 Jun  8 01:35 ewallet.p12
   

复制代码

1. SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 8 01:37:17 2018
   
2. 
   
3. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
4. 
   
5. SQL> conn / as sysdba
   
6. Connected.
   
7. SQL> alter system set encryption wallet close identified by "oracle123";
   
8. 
   
9. System altered.
   
10. 
    
11. SQL> alter system set encryption wallet open identified by "oracle123";
    
12. 
    
13. System altered.
    
14. 
    
15. SQL>
    

复制代码

1. RMAN> show all;
   
2. 
   
3. RMAN configuration parameters for database with db_unique_name ORCL are:
   
4. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
   
5. CONFIGURE BACKUP OPTIMIZATION ON;
   
6. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
   
7. CONFIGURE CONTROLFILE AUTOBACKUP ON;
   
8. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
   
9. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
   
10. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
    
11. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
    
12. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
13. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
14. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
15. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    
16. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
    
17. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station87)';
    
18. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    
19. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    
20. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    
21. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
    
22. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    
23. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
    
24. 
    
25. RMAN> CONFIGURE ENCRYPTION FOR DATABASE on;
    
26. 
    
27. new RMAN configuration parameters:
    
28. CONFIGURE ENCRYPTION FOR DATABASE ON;
    
29. new RMAN configuration parameters are successfully stored
    
30. 
    
31. RMAN>
    

复制代码

更换主密钥：




双重加密：

1. RMAN> set encryption on identified by "mysql1234" ;   
   
2. 
   
3. executing command: SET encryption
   
4. 
   
5. RMAN> backup tag '4TEDUAL_USERS_INCR0' incremental level 0 tablespace users;
   
6. 
   
7. Starting backup at 2018-06-08:02:03:40
   
8. using channel ORA_SBT_TAPE_1
   
9. using channel ORA_SBT_TAPE_2
   
10. channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
    
11. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
    
12. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.978227903
    
13. channel ORA_SBT_TAPE_1: starting piece 1 at 2018-06-08:02:03:40
    
14. channel ORA_SBT_TAPE_1: finished piece 1 at 2018-06-08:02:04:45
    
15. piece handle=2kt4t4vs_1_1 tag=4TEDUAL_USERS_INCR0 comment=API Version 2.0,MMS Version 10.3.0.2
    
16. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:05
    
17. Finished backup at 2018-06-08:02:04:45
    
18. 
    
19. Starting Control File and SPFILE Autobackup at 2018-06-08:02:04:45
    
20. 
    

复制代码

恢复时候，故意关掉TDE，只提供"mysql1234"：

1. RMAN> set decryption identified by "qwertyu","dsfydsfdsf","mysql1234";
   
2. 
   
3. executing command: SET decryption
   
4. 
   
5. RMAN> restore tablespace users;
   
6. 
   
7. Starting restore at 2018-06-08:02:10:36
   
8. using channel ORA_DISK_1
   
9. using channel ORA_DISK_2
   
10. using channel ORA_DISK_3
    
11. using channel ORA_DISK_4
    
12. using channel ORA_DISK_5
    
13. using channel ORA_DISK_6
    
14. using channel ORA_DISK_7
    
15. using channel ORA_DISK_8
    
16. using channel ORA_SBT_TAPE_1
    
17. using channel ORA_SBT_TAPE_2
    
18. 
    
19. channel ORA_SBT_TAPE_1: starting datafile backup set restore
    
20. channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
    
21. channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.259.978227903
    
22. channel ORA_SBT_TAPE_1: reading from backup piece 2kt4t4vs_1_1
    
23. channel ORA_SBT_TAPE_1: piece handle=2kt4t4vs_1_1 tag=4TEDUAL_USERS_INCR0
    
24. channel ORA_SBT_TAPE_1: restored backup piece 1
    
25. channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
    
26. Finished restore at 2018-06-08:02:11:22
    
27. 
    
28. RMAN>
    

复制代码