活动第28/29次（2018-06-16星期六上下午）

botang

FROM ACTIVE DATABASE实验：

1. 准备initdbclone1.ora：

1. db_name=dbclone1
   
2. db_domain=example.com

复制代码

2.准备orapwdbclone1：

1. orapwd file=orapwdbclone1   password=oracle_4U  entries=4

复制代码

3.启动auxiliary实例。（目的地实例）

先写/etc/oratab：

1. +ASM:/u01/app/oracle/product/11.2.0/grid:N
   
2. winorcl:/u01/app/oracle/product/11.2.0/dbhome_1:N               # line added by Agent
   
3. dbclone1:/u01/app/oracle/product/11.2.0/dbhome_1:N
   

复制代码

再. oraenv

4.在auxiliary实例的监听器上进行注册：
+ASM的listener.ora：

1. # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
   
2. # Generated by Oracle configuration tools.
   
3. 
   
4. SID_LIST_LISTENER =
   
5.   (SID_LIST =
   
6.     (SID_DESC =
   
7.       (GLOBAL_DBNAME = dbclone1.example.com)
   
8.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
   
9.       (SID_NAME = dbclone1)
   
10.     )
    
11.   )
    
12. 
    
13. LISTENER =
    
14.   (DESCRIPTION_LIST =
    
15.     (DESCRIPTION =
    
16.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    
17.     )
    
18.     (DESCRIPTION =
    
19.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
    
20.     )
    
21.   )
    
22. 
    
23. ADR_BASE_LISTENER = /u01/app/oracle
    
24. 
    
25. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
    

复制代码

5. 分发tnsnames.ora（源头、目的地和第三方控制台，第三方控制台不是必需的，可以用源头和目的地之中的任何一台代替第三方控制台）：

1. ORCL =
   
2.   (DESCRIPTION =
   
3.     (ADDRESS_LIST =
   
4.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.86)(PORT = 1521))
   
5.     )
   
6.     (CONNECT_DATA =
   
7.       (SERVER = DEDICATED)
   
8.       (SERVICE_NAME = orcl.example.com)
   
9.     )
   
10.   )
    
11. 
    
12. 
    
13. DBCLONE1 =
    
14.   (DESCRIPTION =
    
15.     (ADDRESS_LIST =
    
16.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
    
17.     )
    
18.     (CONNECT_DATA =
    
19.       (SERVER = DEDICATED)
    
20.       (SERVICE_NAME = dbclone1.example.com)
    
21.     )
    
22.   )
    

复制代码

6. 执行duplicate database脚本（代替了第7章中实验11a的操作，如果在本地恢复还是要用11a实验的做法）：

在目的地操作系统上建一下adump目录：

1. mkdir -p /u01/app/oracle/admin/dbclone1/adump

复制代码

1. run {
   
2. duplicate target database to dbclone1
   
3. from active database
   
4. nofilenamecheck
   
5. spfile
   
6. set
   
7. control_files='+DATA','+FRA'
   
8. set
   
9. db_file_name_convert='+DATA/orcl/','+DATA/dbclone1/'
   
10. set
    
11. log_file_name_convert='+DATA/orcl/','+DATA/dbclone1/','+FRA/orcl','+FRA/dbclone1/'
    
12. set
    
13. audit_file_dest='/u01/app/oracle/admin/dbclone1/adump';
    
14. }

复制代码

7. 具体执行命令：

1. [oracle@station90 ~]$ rman target sys/oracle_4U@orcl auxiliary sys/oracle_4U@dbclone1  cmdfile=dbclone1.rcv

复制代码

内存脚本的执行全过程（输出）：

1. Recovery Manager: Release 11.2.0.3.0 - Production on Sat Jun 16 10:52:18 2018
   
2. 
   
3. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
4. 
   
5. PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.01 in TARGET database is not current
   
6. PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.01 in TARGET database is not current
   
7. connected to target database: ORCL (DBID=1359978017)
   
8. PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.01 in AUXILIARY database is not current
   
9. PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.01 in AUXILIARY database is not current
   
10. connected to auxiliary database: DBCLONE1 (not mounted)
    
11. 
    
12. RMAN> exit
    
13. 
    
14. 
    
15. Recovery Manager complete.
    
16. [oracle@station90 ~]$ rman target sys/oracle_4U@orcl auxiliary sys/oracle_4U@dbclone1  cmdfile=dbclone1.rcv
    
17. 
    
18. Recovery Manager: Release 11.2.0.3.0 - Production on Sat Jun 16 10:52:53 2018
    
19. 
    
20. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
    
21. 
    
22. PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.01 in TARGET database is not current
    
23. PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.01 in TARGET database is not current
    
24. connected to target database: ORCL (DBID=1359978017)
    
25. PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.01 in AUXILIARY database is not current
    
26. PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.01 in AUXILIARY database is not current
    
27. connected to auxiliary database: DBCLONE1 (not mounted)
    
28. 
    
29. RMAN>     run {
    
30. 2>     duplicate target database to dbclone1
    
31. 3>     from active database
    
32. 4>     nofilenamecheck
    
33. 5>     spfile
    
34. 6>     set
    
35. 7>     control_files='+DATA','+FRA'
    
36. 8>     set
    
37. 9>     db_file_name_convert='+DATA/orcl/','+DATA/dbclone1/'
    
38. 10>     set
    
39. 11>     log_file_name_convert='+DATA/orcl/','+DATA/dbclone1/','+FRA/orcl','+FRA/dbclone1/'
    
40. 12>     set
    
41. 13>     audit_file_dest='/u01/app/oracle/admin/dbclone1/adump';
    
42. 14>     }
    
43. 15>
    
44. Starting Duplicate Db at 16-JUN-18
    
45. using target database control file instead of recovery catalog
    
46. allocated channel: ORA_AUX_DISK_1
    
47. channel ORA_AUX_DISK_1: SID=95 device type=DISK
    
48. allocated channel: ORA_AUX_DISK_2
    
49. channel ORA_AUX_DISK_2: SID=10 device type=DISK
    
50. allocated channel: ORA_AUX_DISK_3
    
51. channel ORA_AUX_DISK_3: SID=97 device type=DISK
    
52. allocated channel: ORA_AUX_DISK_4
    
53. channel ORA_AUX_DISK_4: SID=11 device type=DISK
    
54. allocated channel: ORA_AUX_DISK_5
    
55. channel ORA_AUX_DISK_5: SID=98 device type=DISK
    
56. allocated channel: ORA_AUX_DISK_6
    
57. channel ORA_AUX_DISK_6: SID=12 device type=DISK
    
58. allocated channel: ORA_AUX_DISK_7
    
59. channel ORA_AUX_DISK_7: SID=99 device type=DISK
    
60. allocated channel: ORA_AUX_DISK_8
    
61. channel ORA_AUX_DISK_8: SID=13 device type=DISK
    
62. allocated channel: ORA_AUX_SBT_TAPE_1
    
63. channel ORA_AUX_SBT_TAPE_1: SID=100 device type=SBT_TAPE
    
64. channel ORA_AUX_SBT_TAPE_1: Oracle Secure Backup
    
65. allocated channel: ORA_AUX_SBT_TAPE_2
    
66. channel ORA_AUX_SBT_TAPE_2: SID=14 device type=SBT_TAPE
    
67. channel ORA_AUX_SBT_TAPE_2: Oracle Secure Backup
    
68. 
    
69. contents of Memory Script:
    
70. {
    
71.    backup as copy reuse
    
72.    targetfile  '+DATA/orcl/spfileorcl.ora' auxiliary format
    
73. '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfiledbclone1.ora'   ;
    
74.    sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfiledbclone1.ora''";
    
75. }
    
76. executing Memory Script
    
77. 
    
78. Starting backup at 16-JUN-18
    
79. allocated channel: ORA_DISK_1
    
80. channel ORA_DISK_1: SID=75 device type=DISK
    
81. allocated channel: ORA_DISK_2
    
82. channel ORA_DISK_2: SID=138 device type=DISK
    
83. allocated channel: ORA_DISK_3
    
84. channel ORA_DISK_3: SID=195 device type=DISK
    
85. allocated channel: ORA_DISK_4
    
86. channel ORA_DISK_4: SID=11 device type=DISK
    
87. allocated channel: ORA_DISK_5
    
88. channel ORA_DISK_5: SID=71 device type=DISK
    
89. allocated channel: ORA_DISK_6
    
90. channel ORA_DISK_6: SID=140 device type=DISK
    
91. allocated channel: ORA_DISK_7
    
92. channel ORA_DISK_7: SID=200 device type=DISK
    
93. allocated channel: ORA_DISK_8
    
94. channel ORA_DISK_8: SID=12 device type=DISK
    
95. Finished backup at 16-JUN-18
    
96. 
    
97. sql statement: alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfiledbclone1.ora''
    
98. 
    
99. contents of Memory Script:
    
100. {
     
101.    sql clone "alter system set  db_name =
     
102. ''DBCLONE1'' comment=
     
103. ''duplicate'' scope=spfile";
     
104.    sql clone "alter system set  control_files =
     
105. ''+DATA'', ''+FRA'' comment=
     
106. '''' scope=spfile";
     
107.    sql clone "alter system set  db_file_name_convert =
     
108. ''+DATA/orcl/'', ''+DATA/dbclone1/'' comment=
     
109. '''' scope=spfile";
     
110.    sql clone "alter system set  log_file_name_convert =
     
111. ''+DATA/orcl/'', ''+DATA/dbclone1/'', ''+FRA/orcl'', ''+FRA/dbclone1/'' comment=
     
112. '''' scope=spfile";
     
113.    sql clone "alter system set  audit_file_dest =
     
114. ''/u01/app/oracle/admin/dbclone1/adump'' comment=
     
115. '''' scope=spfile";
     
116.    shutdown clone immediate;
     
117.    startup clone nomount;
     
118. }
     
119. executing Memory Script
     
120. 
     
121. sql statement: alter system set  db_name =  ''DBCLONE1'' comment= ''duplicate'' scope=spfile
     
122. 
     
123. sql statement: alter system set  control_files =  ''+DATA'', ''+FRA'' comment= '''' scope=spfile
     
124. 
     
125. sql statement: alter system set  db_file_name_convert =  ''+DATA/orcl/'', ''+DATA/dbclone1/'' comment= '''' scope=spfile
     
126. 
     
127. sql statement: alter system set  log_file_name_convert =  ''+DATA/orcl/'', ''+DATA/dbclone1/'', ''+FRA/orcl'', ''+FRA/dbclone1/'' comment= '''' scope=spfile
     
128. 
     
129. sql statement: alter system set  audit_file_dest =  ''/u01/app/oracle/admin/dbclone1/adump'' comment= '''' scope=spfile
     
130. 
     
131. Oracle instance shut down
     
132. 
     
133. connected to auxiliary database (not started)
     
134. Oracle instance started
     
135. 
     
136. Total System Global Area     820236288 bytes
     
137. 
     
138. Fixed Size                     1339628 bytes
     
139. Variable Size                482348820 bytes
     
140. Database Buffers             331350016 bytes
     
141. Redo Buffers                   5197824 bytes
     
142. 
     
143. contents of Memory Script:
     
144. {
     
145.    sql clone "alter system set  control_files =
     
146.   ''+DATA/dbclone1/controlfile/current.266.978979989'', ''+FRA/dbclone1/controlfile/current.320.978979991'' comment=
     
147. ''Set by RMAN'' scope=spfile";
     
148.    sql clone "alter system set  db_name =
     
149. ''ORCL'' comment=
     
150. ''Modified by RMAN duplicate'' scope=spfile";
     
151.    sql clone "alter system set  db_unique_name =
     
152. ''DBCLONE1'' comment=
     
153. ''Modified by RMAN duplicate'' scope=spfile";
     
154.    shutdown clone immediate;
     
155.    startup clone force nomount
     
156.    backup as copy current controlfile auxiliary format  '+DATA/dbclone1/controlfile/current.264.978979991';
     
157.    restore clone controlfile to  '+FRA/dbclone1/controlfile/current.258.978979991' from
     
158. '+DATA/dbclone1/controlfile/current.264.978979991';
     
159.    sql clone "alter system set  control_files =
     
160.   ''+DATA/dbclone1/controlfile/current.264.978979991'', ''+FRA/dbclone1/controlfile/current.258.978979991'' comment=
     
161. ''Set by RMAN'' scope=spfile";
     
162.    shutdown clone immediate;
     
163.    startup clone nomount;
     
164.    alter clone database mount;
     
165. }
     
166. executing Memory Script
     
167. 
     
168. sql statement: alter system set  control_files =   ''+DATA/dbclone1/controlfile/current.266.978979989'', ''+FRA/dbclone1/controlfile/current.320.978979991'' comment= ''Set by RMAN'' scope=spfile
     
169. 
     
170. sql statement: alter system set  db_name =  ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile
     
171. 
     
172. sql statement: alter system set  db_unique_name =  ''DBCLONE1'' comment= ''Modified by RMAN duplicate'' scope=spfile
     
173. 
     
174. Oracle instance shut down
     
175. 
     
176. Oracle instance started
     
177. 
     
178. Total System Global Area     820236288 bytes
     
179. 
     
180. Fixed Size                     1339628 bytes
     
181. Variable Size                482348820 bytes
     
182. Database Buffers             331350016 bytes
     
183. Redo Buffers                   5197824 bytes
     
184. 
     
185. Starting backup at 16-JUN-18
     
186. using channel ORA_DISK_1
     
187. using channel ORA_DISK_2
     
188. using channel ORA_DISK_3
     
189. using channel ORA_DISK_4
     
190. using channel ORA_DISK_5
     
191. using channel ORA_DISK_6
     
192. using channel ORA_DISK_7
     
193. using channel ORA_DISK_8
     
194. channel ORA_DISK_1: starting datafile copy
     
195. copying current control file
     
196. output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f tag=TAG20180616T105316 RECID=2 STAMP=978951197
     
197. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
     
198. Finished backup at 16-JUN-18
     
199. 
     
200. Starting restore at 16-JUN-18
     
201. allocated channel: ORA_AUX_DISK_1
     
202. channel ORA_AUX_DISK_1: SID=13 device type=DISK
     
203. allocated channel: ORA_AUX_DISK_2
     
204. channel ORA_AUX_DISK_2: SID=135 device type=DISK
     
205. allocated channel: ORA_AUX_DISK_3
     
206. channel ORA_AUX_DISK_3: SID=136 device type=DISK
     
207. allocated channel: ORA_AUX_DISK_4
     
208. channel ORA_AUX_DISK_4: SID=15 device type=DISK
     
209. allocated channel: ORA_AUX_DISK_5
     
210. channel ORA_AUX_DISK_5: SID=137 device type=DISK
     
211. allocated channel: ORA_AUX_DISK_6
     
212. channel ORA_AUX_DISK_6: SID=16 device type=DISK
     
213. allocated channel: ORA_AUX_DISK_7
     
214. channel ORA_AUX_DISK_7: SID=138 device type=DISK
     
215. allocated channel: ORA_AUX_DISK_8
     
216. channel ORA_AUX_DISK_8: SID=17 device type=DISK
     
217. allocated channel: ORA_AUX_SBT_TAPE_1
     
218. channel ORA_AUX_SBT_TAPE_1: SID=139 device type=SBT_TAPE
     
219. channel ORA_AUX_SBT_TAPE_1: Oracle Secure Backup
     
220. allocated channel: ORA_AUX_SBT_TAPE_2
     
221. channel ORA_AUX_SBT_TAPE_2: SID=18 device type=SBT_TAPE
     
222. channel ORA_AUX_SBT_TAPE_2: Oracle Secure Backup
     
223. 
     
224. channel ORA_AUX_DISK_2: skipped, AUTOBACKUP already found
     
225. channel ORA_AUX_DISK_3: skipped, AUTOBACKUP already found
     
226. channel ORA_AUX_DISK_4: skipped, AUTOBACKUP already found
     
227. channel ORA_AUX_DISK_5: skipped, AUTOBACKUP already found
     
228. channel ORA_AUX_DISK_6: skipped, AUTOBACKUP already found
     
229. channel ORA_AUX_DISK_7: skipped, AUTOBACKUP already found
     
230. channel ORA_AUX_DISK_8: skipped, AUTOBACKUP already found
     
231. channel ORA_AUX_SBT_TAPE_1: skipped, AUTOBACKUP already found
     
232. channel ORA_AUX_SBT_TAPE_2: skipped, AUTOBACKUP already found
     
233. channel ORA_AUX_DISK_1: copied control file copy
     
234. Finished restore at 16-JUN-18
     
235. 
     
236. sql statement: alter system set  control_files =   ''+DATA/dbclone1/controlfile/current.264.978979991'', ''+FRA/dbclone1/controlfile/current.258.978979991'' comment= ''Set by RMAN'' scope=spfile
     
237. 
     
238. Oracle instance shut down
     
239. 
     
240. connected to auxiliary database (not started)
     
241. Oracle instance started
     
242. 
     
243. Total System Global Area     820236288 bytes
     
244. 
     
245. Fixed Size                     1339628 bytes
     
246. Variable Size                482348820 bytes
     
247. Database Buffers             331350016 bytes
     
248. Redo Buffers                   5197824 bytes
     
249. 
     
250. database mounted
     
251. RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.
     
252. 
     
253. contents of Memory Script:
     
254. {
     
255.    set newname for datafile  1 to
     
256. "+data";
     
257.    set newname for datafile  2 to
     
258. "+data";
     
259.    set newname for datafile  3 to
     
260. "+data";
     
261.    set newname for datafile  4 to
     
262. "+data";
     
263.    set newname for datafile  5 to
     
264. "+data";
     
265.    backup as copy reuse
     
266.    datafile  1 auxiliary format
     
267. "+data"   datafile
     
268. 2 auxiliary format
     
269. "+data"   datafile
     
270. 3 auxiliary format
     
271. "+data"   datafile
     
272. 4 auxiliary format
     
273. "+data"   datafile
     
274. 5 auxiliary format
     
275. "+data"   ;
     
276.    sql 'alter system archive log current';
     
277. }
     
278. executing Memory Script
     
279. 
     
280. executing command: SET NEWNAME
     
281. 
     
282. executing command: SET NEWNAME
     
283. 
     
284. executing command: SET NEWNAME
     
285. 
     
286. executing command: SET NEWNAME
     
287. 
     
288. executing command: SET NEWNAME
     
289. 
     
290. Starting backup at 16-JUN-18
     
291. using channel ORA_DISK_1
     
292. using channel ORA_DISK_2
     
293. using channel ORA_DISK_3
     
294. using channel ORA_DISK_4
     
295. using channel ORA_DISK_5
     
296. using channel ORA_DISK_6
     
297. using channel ORA_DISK_7
     
298. using channel ORA_DISK_8
     
299. channel ORA_DISK_1: starting datafile copy
     
300. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.978643425
     
301. channel ORA_DISK_2: starting datafile copy
     
302. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.258.978643425
     
303. channel ORA_DISK_3: starting datafile copy
     
304. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.259.978643423
     
305. channel ORA_DISK_4: starting datafile copy
     
306. input datafile file number=00005 name=+DATA/orcl/datafile/example.257.978643425
     
307. channel ORA_DISK_5: starting datafile copy
     
308. input datafile file number=00004 name=+DATA/orcl/datafile/users.265.978645015
     
309. output file name=+DATA/dbclone1/datafile/users.259.978980031 tag=TAG20180616T105349
     
310. channel ORA_DISK_5: datafile copy complete, elapsed time: 00:00:15
     
311. output file name=+DATA/dbclone1/datafile/example.265.978980031 tag=TAG20180616T105349
     
312. channel ORA_DISK_4: datafile copy complete, elapsed time: 00:00:45
     
313. output file name=+DATA/dbclone1/datafile/undotbs1.267.978980031 tag=TAG20180616T105349
     
314. channel ORA_DISK_3: datafile copy complete, elapsed time: 00:01:25
     
315. output file name=+DATA/dbclone1/datafile/system.260.978980031 tag=TAG20180616T105349
     
316. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:09
     
317. output file name=+DATA/dbclone1/datafile/sysaux.268.978980031 tag=TAG20180616T105349
     
318. channel ORA_DISK_2: datafile copy complete, elapsed time: 00:02:09
     
319. Finished backup at 16-JUN-18
     
320. 
     
321. sql statement: alter system archive log current
     
322. 
     
323. contents of Memory Script:
     
324. {
     
325.    backup as copy reuse
     
326.    archivelog like  "+FRA/orcl/archivelog/2018_06_16/thread_1_seq_4.351.978951273" auxiliary format
     
327. "+FRA"   archivelog like
     
328. "+FRA/orcl/archivelog/2018_06_16/thread_1_seq_5.352.978951293" auxiliary format
     
329. "+FRA"   archivelog like
     
330. "+FRA/orcl/archivelog/2018_06_16/thread_1_seq_6.359.978951361" auxiliary format
     
331. "+FRA"   ;
     
332.    catalog clone start with  "+FRA";
     
333.    switch clone datafile all;
     
334. }
     
335. executing Memory Script
     
336. 
     
337. Starting backup at 16-JUN-18
     
338. using channel ORA_DISK_1
     
339. using channel ORA_DISK_2
     
340. using channel ORA_DISK_3
     
341. using channel ORA_DISK_4
     
342. using channel ORA_DISK_5
     
343. using channel ORA_DISK_6
     
344. using channel ORA_DISK_7
     
345. using channel ORA_DISK_8
     
346. channel ORA_DISK_1: starting archived log copy
     
347. input archived log thread=1 sequence=4 RECID=105 STAMP=978951276
     
348. channel ORA_DISK_2: starting archived log copy
     
349. input archived log thread=1 sequence=5 RECID=106 STAMP=978951296
     
350. channel ORA_DISK_3: starting archived log copy
     
351. input archived log thread=1 sequence=6 RECID=107 STAMP=978951361
     
352. output file name=+FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_4.266.978980163 RECID=0 STAMP=0
     
353. channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:07
     
354. output file name=+FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_5.296.978980163 RECID=0 STAMP=0
     
355. channel ORA_DISK_2: archived log copy complete, elapsed time: 00:00:07
     
356. output file name=+FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_6.293.978980163 RECID=0 STAMP=0
     
357. channel ORA_DISK_3: archived log copy complete, elapsed time: 00:00:07
     
358. Finished backup at 16-JUN-18
     
359. 
     
360. searching for all files that match the pattern +FRA
     
361. 
     
362. List of Files Unknown to the Database
     
363. =====================================
     
364. File Name: +fra/DBCLONE1/ARCHIVELOG/2018_06_16/thread_1_seq_4.266.978980163
     
365. File Name: +fra/DBCLONE1/ARCHIVELOG/2018_06_16/thread_1_seq_5.296.978980163
     
366. File Name: +fra/DBCLONE1/ARCHIVELOG/2018_06_16/thread_1_seq_6.293.978980163
     
367. File Name: +fra/DBCLONE1/CONTROLFILE/Current.320.978979991
     
368. cataloging files...
     
369. cataloging done
     
370. 
     
371. List of Cataloged Files
     
372. =======================
     
373. File Name: +fra/DBCLONE1/ARCHIVELOG/2018_06_16/thread_1_seq_4.266.978980163
     
374. File Name: +fra/DBCLONE1/ARCHIVELOG/2018_06_16/thread_1_seq_5.296.978980163
     
375. File Name: +fra/DBCLONE1/ARCHIVELOG/2018_06_16/thread_1_seq_6.293.978980163
     
376. 
     
377. List of Files Which Where Not Cataloged
     
378. =======================================
     
379. File Name: +fra/DBCLONE1/CONTROLFILE/Current.320.978979991
     
380.   RMAN-07517: Reason: The file header is corrupted
     
381. 
     
382. datafile 1 switched to datafile copy
     
383. input datafile copy RECID=2 STAMP=978980170 file name=+DATA/dbclone1/datafile/system.260.978980031
     
384. datafile 2 switched to datafile copy
     
385. input datafile copy RECID=3 STAMP=978980170 file name=+DATA/dbclone1/datafile/sysaux.268.978980031
     
386. datafile 3 switched to datafile copy
     
387. input datafile copy RECID=4 STAMP=978980170 file name=+DATA/dbclone1/datafile/undotbs1.267.978980031
     
388. datafile 4 switched to datafile copy
     
389. input datafile copy RECID=5 STAMP=978980170 file name=+DATA/dbclone1/datafile/users.259.978980031
     
390. datafile 5 switched to datafile copy
     
391. input datafile copy RECID=6 STAMP=978980170 file name=+DATA/dbclone1/datafile/example.265.978980031
     
392. 
     
393. contents of Memory Script:
     
394. {
     
395.    set until scn  1161526;
     
396.    recover
     
397.    clone database
     
398.     delete archivelog
     
399.    ;
     
400. }
     
401. executing Memory Script
     
402. 
     
403. executing command: SET until clause
     
404. 
     
405. Starting recover at 16-JUN-18
     
406. allocated channel: ORA_AUX_DISK_1
     
407. channel ORA_AUX_DISK_1: SID=135 device type=DISK
     
408. allocated channel: ORA_AUX_DISK_2
     
409. channel ORA_AUX_DISK_2: SID=15 device type=DISK
     
410. allocated channel: ORA_AUX_DISK_3
     
411. channel ORA_AUX_DISK_3: SID=14 device type=DISK
     
412. allocated channel: ORA_AUX_DISK_4
     
413. channel ORA_AUX_DISK_4: SID=137 device type=DISK
     
414. allocated channel: ORA_AUX_DISK_5
     
415. channel ORA_AUX_DISK_5: SID=138 device type=DISK
     
416. allocated channel: ORA_AUX_DISK_6
     
417. channel ORA_AUX_DISK_6: SID=139 device type=DISK
     
418. allocated channel: ORA_AUX_DISK_7
     
419. channel ORA_AUX_DISK_7: SID=18 device type=DISK
     
420. allocated channel: ORA_AUX_DISK_8
     
421. channel ORA_AUX_DISK_8: SID=140 device type=DISK
     
422. allocated channel: ORA_AUX_SBT_TAPE_1
     
423. channel ORA_AUX_SBT_TAPE_1: SID=19 device type=SBT_TAPE
     
424. channel ORA_AUX_SBT_TAPE_1: Oracle Secure Backup
     
425. allocated channel: ORA_AUX_SBT_TAPE_2
     
426. channel ORA_AUX_SBT_TAPE_2: SID=141 device type=SBT_TAPE
     
427. channel ORA_AUX_SBT_TAPE_2: Oracle Secure Backup
     
428. 
     
429. starting media recovery
     
430. 
     
431. archived log for thread 1 with sequence 4 is already on disk as file +FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_4.266.978980163
     
432. archived log for thread 1 with sequence 5 is already on disk as file +FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_5.296.978980163
     
433. archived log for thread 1 with sequence 6 is already on disk as file +FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_6.293.978980163
     
434. archived log file name=+FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_4.266.978980163 thread=1 sequence=4
     
435. archived log file name=+FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_5.296.978980163 thread=1 sequence=5
     
436. archived log file name=+FRA/dbclone1/archivelog/2018_06_16/thread_1_seq_6.293.978980163 thread=1 sequence=6
     
437. media recovery complete, elapsed time: 00:00:17
     
438. Finished recover at 16-JUN-18
     
439. Oracle instance started
     
440. 
     
441. Total System Global Area     820236288 bytes
     
442. 
     
443. Fixed Size                     1339628 bytes
     
444. Variable Size                482348820 bytes
     
445. Database Buffers             331350016 bytes
     
446. Redo Buffers                   5197824 bytes
     
447. 
     
448. contents of Memory Script:
     
449. {
     
450.    sql clone "alter system set  db_name =
     
451. ''DBCLONE1'' comment=
     
452. ''Reset to original value by RMAN'' scope=spfile";
     
453.    sql clone "alter system reset  db_unique_name scope=spfile";
     
454.    shutdown clone immediate;
     
455.    startup clone nomount;
     
456. }
     
457. executing Memory Script
     
458. 
     
459. sql statement: alter system set  db_name =  ''DBCLONE1'' comment= ''Reset to original value by RMAN'' scope=spfile
     
460. 
     
461. sql statement: alter system reset  db_unique_name scope=spfile
     
462. 
     
463. Oracle instance shut down
     
464. 
     
465. connected to auxiliary database (not started)
     
466. Oracle instance started
     
467. 
     
468. Total System Global Area     820236288 bytes
     
469. 
     
470. Fixed Size                     1339628 bytes
     
471. Variable Size                482348820 bytes
     
472. Database Buffers             331350016 bytes
     
473. Redo Buffers                   5197824 bytes
     
474. sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DBCLONE1" RESETLOGS ARCHIVELOG
     
475.   MAXLOGFILES     16
     
476.   MAXLOGMEMBERS      3
     
477.   MAXDATAFILES      100
     
478.   MAXINSTANCES     8
     
479.   MAXLOGHISTORY      292
     
480. LOGFILE
     
481.   GROUP   1 ( '+data', '+fra' ) SIZE 50 M  REUSE,
     
482.   GROUP   2 ( '+data', '+fra' ) SIZE 50 M  REUSE,
     
483.   GROUP   3 ( '+data', '+fra' ) SIZE 50 M  REUSE
     
484. DATAFILE
     
485.   '+DATA/dbclone1/datafile/system.260.978980031'
     
486. CHARACTER SET AL32UTF8
     
487. 
     
488. 
     
489. contents of Memory Script:
     
490. {
     
491.    set newname for tempfile  1 to
     
492. "+data";
     
493.    switch clone tempfile all;
     
494.    catalog clone datafilecopy  "+DATA/dbclone1/datafile/sysaux.268.978980031",
     
495. "+DATA/dbclone1/datafile/undotbs1.267.978980031",
     
496. "+DATA/dbclone1/datafile/users.259.978980031",
     
497. "+DATA/dbclone1/datafile/example.265.978980031";
     
498.    switch clone datafile all;
     
499. }
     
500. executing Memory Script
     
501. 
     
502. executing command: SET NEWNAME
     
503. 
     
504. renamed tempfile 1 to +data in control file
     
505. 
     
506. cataloged datafile copy
     
507. datafile copy file name=+DATA/dbclone1/datafile/sysaux.268.978980031 RECID=1 STAMP=978980209
     
508. cataloged datafile copy
     
509. datafile copy file name=+DATA/dbclone1/datafile/undotbs1.267.978980031 RECID=2 STAMP=978980209
     
510. cataloged datafile copy
     
511. datafile copy file name=+DATA/dbclone1/datafile/users.259.978980031 RECID=3 STAMP=978980209
     
512. cataloged datafile copy
     
513. datafile copy file name=+DATA/dbclone1/datafile/example.265.978980031 RECID=4 STAMP=978980209
     
514. 
     
515. datafile 2 switched to datafile copy
     
516. input datafile copy RECID=1 STAMP=978980209 file name=+DATA/dbclone1/datafile/sysaux.268.978980031
     
517. datafile 3 switched to datafile copy
     
518. input datafile copy RECID=2 STAMP=978980209 file name=+DATA/dbclone1/datafile/undotbs1.267.978980031
     
519. datafile 4 switched to datafile copy
     
520. input datafile copy RECID=3 STAMP=978980209 file name=+DATA/dbclone1/datafile/users.259.978980031
     
521. datafile 5 switched to datafile copy
     
522. input datafile copy RECID=4 STAMP=978980209 file name=+DATA/dbclone1/datafile/example.265.978980031
     
523. 
     
524. contents of Memory Script:
     
525. {
     
526.    Alter clone database open resetlogs;
     
527. }
     
528. executing Memory Script
     
529. 
     
530. database opened
     
531. Finished Duplicate Db at 16-JUN-18
     
532. 
     
533. Recovery Manager complete.
     
534. [oracle@station90 ~]$
     

复制代码

8. 在目的地数据库这边，注册：

1. [oracle@station87 ~]$ crs_stat -t
   
2. Name           Type           Target    State     Host        
   
3. ------------------------------------------------------------
   
4. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station87   
   
5. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station87   
   
6. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station87   
   
7. ora.asm        ora.asm.type   ONLINE    ONLINE    station87   
   
8. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station87   
   
9. ora.diskmon    ora....on.type ONLINE    ONLINE    station87   
   
10. [oracle@station87 ~]$ srvctl add database -d dbclone1 -o /u01/app/oracle/product/11.2.0/dbhome_1   
    
11. [oracle@station87 ~]$ crs_stat -t
    
12. Name           Type           Target    State     Host        
    
13. ------------------------------------------------------------
    
14. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station87   
    
15. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station87   
    
16. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station87   
    
17. ora.asm        ora.asm.type   ONLINE    ONLINE    station87   
    
18. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station87   
    
19. ora....one1.db ora....se.type OFFLINE   OFFLINE               
    
20. ora.diskmon    ora....on.type ONLINE    ONLINE    station87   
    
21. [oracle@station87 ~]$ srvctl start database -d dbclone1
    
22. [oracle@station87 ~]$ crs_stat -t
    
23. Name           Type           Target    State     Host        
    
24. ------------------------------------------------------------
    
25. ora.DATA.dg    ora....up.type ONLINE    ONLINE    station87   
    
26. ora.FRA.dg     ora....up.type ONLINE    ONLINE    station87   
    
27. ora....ER.lsnr ora....er.type ONLINE    ONLINE    station87   
    
28. ora.asm        ora.asm.type   ONLINE    ONLINE    station87   
    
29. ora.cssd       ora.cssd.type  ONLINE    ONLINE    station87   
    
30. ora....one1.db ora....se.type ONLINE    ONLINE    station87   
    
31. ora.diskmon    ora....on.type ONLINE    ONLINE    station87   
    
32. [oracle@station87 ~]$
    

复制代码

FROM ACTIVE DATABASE实验（源头是ASM目的地是文件系统）：

1. 准备initdbclone2.ora：

1. db_name=dbclone2
   
2. db_domain=example.com

复制代码

2.准备orapwdbclone2：

1. orapwd file=orapwdbclone2   password=oracle_4U  entries=4

复制代码

3.启动auxiliary实例。（目的地实例）

先写/etc/oratab：

1. +ASM:/u01/app/oracle/product/11.2.0/grid:N
   
2. winorcl:/u01/app/oracle/product/11.2.0/dbhome_1:N               # line added by Agent
   
3. dbclone1:/u01/app/oracle/product/11.2.0/dbhome_1:N
   
4. dbclone2:/u01/app/oracle/product/11.2.0/dbhome_1:N
   

复制代码

再. oraenv

4.在auxiliary实例的监听器上进行注册：
+ASM的listener.ora：

1. # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
   
2. # Generated by Oracle configuration tools.
   
3. 
   
4. SID_LIST_LISTENER =
   
5.   (SID_LIST =
   
6.     (SID_DESC =
   
7.       (GLOBAL_DBNAME = dbclone1.example.com)
   
8.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
   
9.       (SID_NAME = dbclone1)
   
10.     )
    
11.      (SID_DESC =
    
12.       (GLOBAL_DBNAME = dbclone2.example.com)
    
13.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    
14.       (SID_NAME = dbclone2)
    
15.      )
    
16.   )
    
17. 
    
18. LISTENER =
    
19.   (DESCRIPTION_LIST =
    
20.     (DESCRIPTION =
    
21.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    
22.     )
    
23.     (DESCRIPTION =
    
24.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
    
25.     )
    
26.   )
    
27. 
    
28. ADR_BASE_LISTENER = /u01/app/oracle
    
29. 
    
30. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
    

复制代码

5. 分发tnsnames.ora（源头、目的地和第三方控制台，第三方控制台不是必需的，可以用源头和目的地之中的任何一台代替第三方控制台）：

1. ORCL =
   
2.   (DESCRIPTION =
   
3.     (ADDRESS_LIST =
   
4.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.86)(PORT = 1521))
   
5.     )
   
6.     (CONNECT_DATA =
   
7.       (SERVER = DEDICATED)
   
8.       (SERVICE_NAME = orcl.example.com)
   
9.     )
   
10.   )
    
11. 
    
12. 
    
13. DBCLONE1 =
    
14.   (DESCRIPTION =
    
15.     (ADDRESS_LIST =
    
16.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
    
17.     )
    
18.     (CONNECT_DATA =
    
19.       (SERVER = DEDICATED)
    
20.       (SERVICE_NAME = dbclone1.example.com)
    
21.     )
    
22.   )
    
23. 
    
24. DBCLONE2 =
    
25.   (DESCRIPTION =
    
26.     (ADDRESS_LIST =
    
27.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
    
28.     )
    
29.     (CONNECT_DATA =
    
30.       (SERVER = DEDICATED)
    
31.       (SERVICE_NAME = dbclone2.example.com)
    
32.     )
    
33.   )
    

复制代码

6. 执行duplicate database脚本（代替了第7章中实验11a的操作，如果在本地恢复还是要用11a实验的做法）：

在目的地操作系统上建一下adump目录：

1. mkdir -p /u01/app/oracle/admin/dbclone2/adump
   
2. mkdir -p /u01/app/oracle/oradata/dbclone2
   
3. mkdir -p /u01/app/oracle/fast_recovery_area
   

复制代码

顺便测试一下：选一部份表空间，不选另外一部分表空间：

1. SQL> conn / as sysdba
   
2. Connected.
   
3. SQL> select  tablespacE_name from dba_tablespaces;
   
4. 
   
5. TABLESPACE_NAME
   
6. ------------------------------
   
7. SYSTEM
   
8. SYSAUX
   
9. UNDOTBS1
   
10. TEMP
    
11. USERS
    
12. EXAMPLE
    
13. 
    
14. 6 rows selected.
    
15. 
    
16. SQL> create tablespace tbs1 datafile size 5M   ;
    
17. 
    
18. Tablespace created.
    
19. 
    
20. SQL> create tablespace tbs2 datafile size 5M   ;
    
21. 
    
22. Tablespace created.
    
23. 
    
24. SQL> create table t1(a number)  tablespace  tbs1;
    
25. 
    
26. Table created.
    
27. 
    
28. SQL> insert into t1 values(1)  ;
    
29. 
    
30. 1 row created.
    
31. 
    
32. SQL> commit;
    
33. 
    
34. Commit complete.
    
35. 
    
36. SQL> create table hr.t2(a number)  tablespace  tbs2;
    
37. 
    
38. Table created.
    
39. 
    
40. SQL> insert into hr.t2 values (1) ;
    
41. 
    
42. 1 row created.
    
43. 
    
44. SQL> commit;
    
45. 
    
46. Commit complete.
    
47. 
    
48. SQL>
    

复制代码

对排除的表空间一定要做“自包含 集检查”：

1. SQL> exec dbms_tts.TRANSPORT_SET_CHECK('tbs1,tbs2');
   
2. 
   
3. PL/SQL procedure successfully completed.
   
4. 
   
5. 
   
6. SQL> select * from transport_set_violations;
   
7. 
   
8. VIOLATIONS
   
9. --------------------------------------------------------------------------------
   
10. ORA-39917: SYS owned object T1 in tablespace TBS1 not allowed in pluggable set
    

复制代码

处理办法都是“移走”：

1. SQL> alter table T1  move tablespace system;
   
2. 
   
3. Table altered.
   

复制代码

1. run{
   
2. duplicate target database to dbclone2
   
3. from active database
   
4. nofilenamecheck
   
5. skip tablespace 'TBS1','TBS2'
   
6. spfile
   
7. set
   
8. control_files='/u01/app/oracle/oradata/dbclone2/control01.ctl','/u01/app/oracle/oradata/dbclone2/control02.ctl','/u01/app/oracle/oradata/dbclone2/control03.ctl'
   
9. set
   
10. db_file_name_convert='+DATA/orcl/datafile/example.257.978643425','/u01/app/oracle/oradata/dbclone2/example01.dbf','+DATA/orcl/datafile/users.265.978645015','/u01/app/oracle/oradata/dbclone2/users01.dbf','+DATA/orcl/datafile/undotbs1.259.978643423','/u01/app/oracle/oradata/dbclone2/undotbs01.dbf','+DATA/orcl/datafile/sysaux.258.978643425','/u01/app/oracle/oradata/dbclone2/sysaux01.dbf','+DATA/orcl/datafile/system.256.978643425','/u01/app/oracle/oradata/dbclone2/system01.dbf'
    
11. set
    
12. log_file_name_convert='+DATA/orcl/onlinelog/group_1.261.978643689','/u01/app/oracle/oradata/dbclone2/redo01a.log','+FRA/orcl/onlinelog/group_1.257.978643689','/u01/app/oracle/oradata/dbclone2/redo01b.log','+DATA/orcl/onlinelog/group_3.263.978643691','/u01/app/oracle/oradata/dbclone2/redo03a.log','+FRA/orcl/onlinelog/group_3.259.978643691','/u01/app/oracle/oradata/dbclone2/redo03b.log','+DATA/orcl/onlinelog/group_2.262.978643689','/u01/app/oracle/oradata/dbclone2/redo02a.log','+FRA/orcl/onlinelog/group_2.258.978643691','/u01/app/oracle/oradata/dbclone2/redo02b.log'
    
13. set
    
14. audit_file_dest='/u01/app/oracle/admin/dbclone2/adump'
    
15. set
    
16. db_create_file_dest=''
    
17. set
    
18. db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
    
19. set
    
20. memory_target='2G'
    
21. ;
    
22. }

复制代码

1. rman target sys/oracle_4U@orcl auxiliary sys/oracle_4U@dbclone2 cmdfile=dbclone2.rcv

复制代码

BACKUP LOCATION实验：

1. 准备initdbclone3.ora：

1. db_name=dbclone3
   
2. db_domain=example.com

复制代码

2.准备orapwdbclone3：

1. orapwd file=orapwdbclone3   password=oracle_4U  entries=4

复制代码

3.启动auxiliary实例。（目的地实例）

先写/etc/oratab：

1. +ASM:/u01/app/oracle/product/11.2.0/grid:N
   
2. winorcl:/u01/app/oracle/product/11.2.0/dbhome_1:N               # line added by Agent
   
3. dbclone1:/u01/app/oracle/product/11.2.0/dbhome_1:N
   
4. dbclone2:/u01/app/oracle/product/11.2.0/dbhome_1:N
   
5. dbclone3:/u01/app/oracle/product/11.2.0/dbhome_1:N
   

复制代码

再. oraenv

4.在auxiliary实例的监听器上进行注册：
+ASM的listener.ora：

1. # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
   
2. # Generated by Oracle configuration tools.
   
3. 
   
4. SID_LIST_LISTENER =
   
5.   (SID_LIST =
   
6.      (SID_DESC =
   
7.       (GLOBAL_DBNAME = dbclone1.example.com)
   
8.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
   
9.       (SID_NAME = dbclone1)
   
10.     )
    
11.      (SID_DESC =
    
12.       (GLOBAL_DBNAME = dbclone2.example.com)
    
13.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    
14.       (SID_NAME = dbclone2)
    
15.      )
    
16.      (SID_DESC =
    
17.       (GLOBAL_DBNAME = dbclone3.example.com)
    
18.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
    
19.       (SID_NAME = dbclone3)
    
20.      )
    
21.   )
    
22. 
    
23. LISTENER =
    
24.   (DESCRIPTION_LIST =
    
25.     (DESCRIPTION =
    
26.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    
27.     )
    
28.     (DESCRIPTION =
    
29.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
    
30.     )
    
31.   )
    
32. 
    
33. ADR_BASE_LISTENER = /u01/app/oracle
    
34. 
    
35. ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
    

复制代码

5. 分发tnsnames.ora（源头、目的地和第三方控制台，第三方控制台不是必需的，可以用源头和目的地之中的任何一台代替第三方控制台）：

1. ORCL =
   
2.   (DESCRIPTION =
   
3.     (ADDRESS_LIST =
   
4.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.86)(PORT = 1521))
   
5.     )
   
6.     (CONNECT_DATA =
   
7.       (SERVER = DEDICATED)
   
8.       (SERVICE_NAME = orcl.example.com)
   
9.     )
   
10.   )
    
11. 
    
12. 
    
13. DBCLONE1 =
    
14.   (DESCRIPTION =
    
15.     (ADDRESS_LIST =
    
16.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
    
17.     )
    
18.     (CONNECT_DATA =
    
19.       (SERVER = DEDICATED)
    
20.       (SERVICE_NAME = dbclone1.example.com)
    
21.     )
    
22.   )
    
23. 
    
24. DBCLONE2 =
    
25.   (DESCRIPTION =
    
26.     (ADDRESS_LIST =
    
27.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
    
28.     )
    
29.     (CONNECT_DATA =
    
30.       (SERVER = DEDICATED)
    
31.       (SERVICE_NAME = dbclone2.example.com)
    
32.     )
    
33.   )
    
34. 
    
35. DBCLONE3 =
    
36.   (DESCRIPTION =
    
37.     (ADDRESS_LIST =
    
38.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.87)(PORT = 1521))
    
39.     )
    
40.     (CONNECT_DATA =
    
41.       (SERVER = DEDICATED)
    
42.       (SERVICE_NAME = dbclone3.example.com)
    
43.     )
    
44.   )
    

复制代码

6. 执行duplicate database脚本（代替了第7章中实验11a的操作，如果在本地恢复还是要用11a实验的做法）：

在目的地操作系统上建一下adump目录：

1. mkdir -p /u01/app/oracle/admin/dbclone3/adump

复制代码

7. 在源头和目的地机器上都建一个相同的目录：

1. mkdir /home/oracle/backup

复制代码

8. 在源头数据库上做备份（源头备份做完后，可以关闭）：run {

1. allocate channel  c1 device type disk format '/home/oracle/backup/%U';
   
2. allocate channel  c2 device type disk format '/home/oracle/backup/%U';
   
3. allocate channel  c3 device type disk format '/home/oracle/backup/%U';
   
4. allocate channel  c4 device type disk format '/home/oracle/backup/%U';
   
5. allocate channel  c5 device type disk format '/home/oracle/backup/%U';
   
6. allocate channel  c6 device type disk format '/home/oracle/backup/%U';
   
7. allocate channel  c7 device type disk format '/home/oracle/backup/%U';
   
8. allocate channel  c8 device type disk format '/home/oracle/backup/%U';
   
9. backup database plus archivelog force;
   
10. backup spfile;
    
11. backup current controlfile;
    
12. }

复制代码

以上脚本结束后，把源头/home/oracle/backup/*传送到目的地/home/oracle/backup/

1. [oracle@station86 backup]$ scp * station87:/home/oracle/backup/
   
2. The authenticity of host 'station87 (192.168.0.87)' can't be established.
   
3. RSA key fingerprint is 3c:21:7a:9c:cd:d9:41:16:75:08:fe:16:4d:37:54:5b.
   
4. Are you sure you want to continue connecting (yes/no)? yes
   
5. Warning: Permanently added 'station87,192.168.0.87' (RSA) to the list of known hosts.
   
6. oracle@station87's password:
   
7. 2et5jl2p_1_1                                                                                        100%   21MB  21.3MB/s   00:00   
   
8. 2ft5jl2p_1_1                                                                                        100%   43MB  21.7MB/s   00:02   
   
9. 2gt5jl2q_1_1                                                                                        100%   46MB  45.9MB/s   00:01   
   
10. 2ht5jl2r_1_1                                                                             

复制代码

顺便试一下新语法，老的语法供参考和显式分配通道：

1. run{
   
2. duplicate target database to mydb
   
3. backup location '/home/oracle/backup'
   
4. nofilenamecheck
   
5. spfile
   
6. set
   
7. control_files='/u01/app/oracle/oradata/mydb/control01.ctl','/u01/app/oracle/oradata/db11g/control02.ctl','/u01/app/oracle/oradata/db11g/control03.ctl'
   
8. set
   
9. db_file_name_convert='+DATA/orcl/datafile/example.258.880451611','/u01/app/oracle/oradata/db11g/example01.dbf','+DATA/orcl/datafile/users.259.880451615','/u01/app/oracle/oradata/db11g/users01.dbf','+DATA/orcl/datafile/undotbs1.256.880451607','/u01/app/oracle/oradata/db11g/undotbs01.dbf','+DATA/orcl/datafile/sysaux.257.880451605','/u01/app/oracle/oradata/db11g/sysaux01.dbf','+DATA/orcl/datafile/system.265.880451605','/u01/app/oracle/oradata/db11g/system01.dbf'
   
10. set
    
11. log_file_name_convert='+DATA/orcl/onlinelog/group_1.270.880453135','/u01/app/oracle/oradata/db11g/redo01a.log','+FRA/orcl/onlinelog/group_1.276.880453137','/u01/app/oracle/oradata/db11g/redo01b.log','+DATA/orcl/onlinelog/group_3.272.880453141','/u01/app/oracle/oradata/db11g/redo03a.log','+FRA/orcl/onlinelog/group_3.274.880453141','/u01/app/oracle/oradata/db11g/redo03b.log','+DATA/orcl/onlinelog/group_2.271.880453137','/u01/app/oracle/oradata/db11g/redo02a.log','+FRA/orcl/onlinelog/group_2.275.880453139','/u01/app/oracle/oradata/db11g/redo02b.log'
    
12. set
    
13. audit_file_dest='/u01/app/oracle/admin/mydb/adump'
    
14. set
    
15. db_create_file_dest=''
    
16. set
    
17. db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
    
18. }

复制代码

新的语法：

在目的地机器上创建/u01/app/oracle/oradata/dbclone3

1. run {
   
2. allocate  auxiliary channel c1 device type disk;
   
3. allocate  auxiliary channel c2 device type disk;
   
4. allocate  auxiliary channel c3 device type disk;
   
5. allocate  auxiliary channel c4 device type disk;
   
6. allocate  auxiliary channel c5 device type disk;
   
7. allocate  auxiliary channel c6 device type disk;
   
8. allocate  auxiliary channel c7 device type disk;
   
9. allocate  auxiliary channel c8 device type disk;
   
10. duplicate database to dbclone3
    
11. backup location '/home/oracle/backup'
    
12. nofilenamecheck  
    
13. db_file_name_convert '+DATA/orcl/datafile/example.257.978643425','/u01/app/oracle/oradata/dbclone3/example01.dbf','+DATA/orcl/datafile/users.265.978645015','/u01/app/oracle/oradata/dbclone3/users01.dbf','+DATA/orcl/datafile/undotbs1.259.978643423','/u01/app/oracle/oradata/dbclone3/undotbs01.dbf','+DATA/orcl/datafile/sysaux.258.978643425','/u01/app/oracle/oradata/dbclone3/sysaux01.dbf','+DATA/orcl/datafile/system.256.978643425','/u01/app/oracle/oradata/dbclone3/system01.dbf'
    
14. logfile
    
15. group 1 ('/u01/app/oracle/oradata/dbclone3/redo01a.log','/u01/app/oracle/oradata/dbclone3/redo01b.log') size 50M,
    
16. group 2 ('/u01/app/oracle/oradata/dbclone3/redo02a.log','/u01/app/oracle/oradata/dbclone3/redo02b.log') size 50M,
    
17. group 3 ('/u01/app/oracle/oradata/dbclone3/redo03a.log','/u01/app/oracle/oradata/dbclone3/redo03b.log') size 50M
    
18. spfile
    
19. set
    
20. control_files='/u01/app/oracle/oradata/dbclone3/control01.ctl','/u01/app/oracle/oradata/dbclone3/control02.ctl','/u01/app/oracle/oradata/dbclone3/control03.ctl'
    
21. set
    
22. audit_file_dest='/u01/app/oracle/admin/dbclone3/adump'
    
23. set
    
24. db_create_file_dest=''
    
25. set
    
26. db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
    
27. ;
    
28. }
    

复制代码

在1Z0-052第18章/1Z0-053第9章之前，数据库里没有物理和逻辑坏块：
physical-block11.2.0.1.sh.zip (645 Bytes, 下载次数: 547)

2018-6-16 16:14 上传

点击文件名下载附件
physical-block.sh.zip (639 Bytes, 下载次数: 539)

2018-6-16 16:14 上传

点击文件名下载附件

1. select  department_id , rowid,  substr(rowid,10,6) , dbms_rowid.rowid_block_number(rowid)  from departments;

复制代码

RMAN备份的同时负责发现以下三个视图：

1. select * from v$database_block_corruption;
   
2. 
   
3. select * from v$copy_corruption;
   
4. 
   
5. select  * from v$backup_corruption;

复制代码

1. create tablespace tbslogical datafile size 10M  nologging;
   
2. 
   
3. create table hr.tlogical ( a varchar2(30), b number  )  
   
4. tablespace tbslogical;
   
5. 
   
6. create index hr.ilogical_a on hr.tlogical (a) ;
   
7. 
   
8. create index hr.ilogical_b on hr.tlogical(b);
   
9. 
   
10. insert into hr.tlogical values('backare',32285);
    
11. 
    
12. commit;

复制代码

制造逻辑坏块的过程：

1. create tablespace tbslogical datafile size 10M  nologging;
   
2. 
   
3. create table hr.tlogical ( a varchar2(30), b number  )  
   
4. tablespace tbslogical;
   
5. 
   
6. create index hr.ilogical_a on hr.tlogical (a) ;
   
7. 
   
8. create index hr.ilogical_b on hr.tlogical(b);
   
9. 
   
10. insert into hr.tlogical values('backare',32285);
    
11. 
    
12. commit;

复制代码

1. SQL> select  * from hr.tlogical ;
   
2. 
   
3. A                                        B
   
4. ------------------------------ ----------
   
5. backare                             32285
   
6. 
   
7. SQL> insert /*+ append */ into hr.tlogical   select  * from hr.tlogical ;
   
8. 
   
9. 1 row created.
   
10. 
    
11. SQL> select  * from hr.tlogical ;
    
12. select        * from hr.tlogical
    
13.                   *
    
14. ERROR at line 1:
    
15. ORA-12838: cannot read/modify an object after modifying it in parallel
    
16. 
    
17. 
    
18. SQL> commit;
    
19. 
    
20. Commit complete.
    
21. 
    
22. SQL> select a, b , dbms_rowid.rowid_block_number(rowid) from tlogical;
    
23. select a, b , dbms_rowid.rowid_block_number(rowid) from tlogical
    
24.                                                         *
    
25. ERROR at line 1:
    
26. ORA-00942: table or view does not exist
    
27. 
    
28. 
    
29. SQL> select a, b , dbms_rowid.rowid_block_number(rowid) from hr.tlogical;
    
30. 
    
31. A                                        B DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
    
32. ------------------------------ ---------- ------------------------------------
    
33. backare                             32285                                   135
    
34. backare                             32285                                   136
    
35. 
    
36. SQL> alter database datafile 6 offline;
    
37. 
    
38. Database altered.
    
39. 
    
40. SQL> alter database datafile 6 online;
    
41. alter database datafile 6 online
    
42. *
    
43. ERROR at line 1:
    
44. ORA-01113: file 6 needs media recovery
    
45. ORA-01110: data file 6: '+DATA/orcl/datafile/tbslogical.268.978972513'
    
46. 
    
47. 
    
48. SQL> alter database create datafile 6 as new;
    
49. 
    
50. Database altered.
    
51. 
    
52. SQL> recover datafile 6;
    
53. ORA-00279: change 1887708 generated at 06/16/2018 16:33:52 needed for thread 1
    
54. ORA-00289: suggestion :
    
55. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_94.337.978971647
    
56. ORA-00280: change 1887708 for thread 1 is in sequence #94
    
57. 
    
58. 
    
59. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
    
60. auto
    
61. ORA-00279: change 1890411 generated at 06/16/2018 16:34:06 needed for thread 1
    
62. ORA-00289: suggestion :
    
63. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_95.339.978972203
    
64. ORA-00280: change 1890411 for thread 1 is in sequence #95
    
65. 
    
66. 
    
67. ORA-00279: change 1897905 generated at 06/16/2018 16:34:27 needed for thread 1
    
68. ORA-00289: suggestion :
    
69. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_96.338.978973541
    
70. ORA-00280: change 1897905 for thread 1 is in sequence #96
    
71. 
    
72. 
    
73. ORA-00279: change 1906255 generated at 06/16/2018 16:35:03 needed for thread 1
    
74. ORA-00289: suggestion :
    
75. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_97.340.978972205
    
76. ORA-00280: change 1906255 for thread 1 is in sequence #97
    
77. 
    
78. 
    
79. ORA-00279: change 1933151 generated at 06/16/2018 16:43:23 needed for thread 1
    
80. ORA-00289: suggestion :
    
81. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_98.341.978972277
    
82. ORA-00280: change 1933151 for thread 1 is in sequence #98
    
83. 
    
84. 
    
85. ORA-00279: change 1943929 generated at 06/16/2018 16:44:37 needed for thread 1
    
86. ORA-00289: suggestion :
    
87. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_99.342.978972311
    
88. ORA-00280: change 1943929 for thread 1 is in sequence #99
    
89. 
    
90. 
    
91. ORA-00279: change 1961134 generated at 06/16/2018 16:45:10 needed for thread 1
    
92. ORA-00289: suggestion :
    
93. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_100.343.978972319
    
94. ORA-00280: change 1961134 for thread 1 is in sequence #100
    
95. 
    
96. 
    
97. ORA-00279: change 1965454 generated at 06/16/2018 16:45:18 needed for thread 1
    
98. ORA-00289: suggestion :
    
99. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_101.344.978972327
    
100. ORA-00280: change 1965454 for thread 1 is in sequence #101
     
101. 
     
102. 
     
103. ORA-00279: change 1970102 generated at 06/16/2018 16:45:26 needed for thread 1
     
104. ORA-00289: suggestion :
     
105. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_102.345.978972333
     
106. ORA-00280: change 1970102 for thread 1 is in sequence #102
     
107. 
     
108. 
     
109. ORA-00279: change 1974963 generated at 06/16/2018 16:45:33 needed for thread 1
     
110. ORA-00289: suggestion :
     
111. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_103.346.978972343
     
112. ORA-00280: change 1974963 for thread 1 is in sequence #103
     
113. 
     
114. 
     
115. ORA-00279: change 1990668 generated at 06/16/2018 16:45:43 needed for thread 1
     
116. ORA-00289: suggestion :
     
117. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_104.347.978972431
     
118. ORA-00280: change 1990668 for thread 1 is in sequence #104
     
119. 
     
120. 
     
121. ORA-00279: change 2005567 generated at 06/16/2018 16:47:09 needed for thread 1
     
122. ORA-00289: suggestion :
     
123. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_105.348.978972483
     
124. ORA-00280: change 2005567 for thread 1 is in sequence #105
     
125. 
     
126. 
     
127. ORA-00279: change 2024814 generated at 06/16/2018 16:48:02 needed for thread 1
     
128. ORA-00289: suggestion :
     
129. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_106.349.978972493
     
130. ORA-00280: change 2024814 for thread 1 is in sequence #106
     
131. 
     
132. 
     
133. ORA-00279: change 2028975 generated at 06/16/2018 16:48:13 needed for thread 1
     
134. ORA-00289: suggestion :
     
135. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_107.350.978972519
     
136. ORA-00280: change 2028975 for thread 1 is in sequence #107
     
137. 
     
138. 
     
139. ORA-00279: change 2033778 generated at 06/16/2018 16:48:39 needed for thread 1
     
140. ORA-00289: suggestion :
     
141. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_108.351.978972537
     
142. ORA-00280: change 2033778 for thread 1 is in sequence #108
     
143. 
     
144. 
     
145. ORA-00279: change 2036872 generated at 06/16/2018 16:48:56 needed for thread 1
     
146. ORA-00289: suggestion :
     
147. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_109.352.978972561
     
148. ORA-00280: change 2036872 for thread 1 is in sequence #109
     
149. 
     
150. 
     
151. ORA-00279: change 2044292 generated at 06/16/2018 16:49:21 needed for thread 1
     
152. ORA-00289: suggestion :
     
153. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_110.353.978972591
     
154. ORA-00280: change 2044292 for thread 1 is in sequence #110
     
155. 
     
156. 
     
157. ORA-00279: change 2051545 generated at 06/16/2018 16:49:51 needed for thread 1
     
158. ORA-00289: suggestion :
     
159. +FRA/orcl/archivelog/2018_06_16/thread_1_seq_111.354.978972609
     
160. ORA-00280: change 2051545 for thread 1 is in sequence #111
     
161. 
     
162. 
     
163. Log applied.
     
164. Media recovery complete.
     
165. SQL> alter database datafile 6 online;
     
166. 
     
167. Database altered.
     
168. 
     
169. SQL> select a, b , dbms_rowid.rowid_block_number(rowid) from hr.tlogical;
     
170. ERROR:
     
171. ORA-01578: ORACLE data block corrupted (file # 6, block # 136)
     
172. ORA-01110: data file 6: '+DATA/orcl/datafile/tbslogical.267.978972737'
     
173. ORA-26040: Data block was loaded using the NOLOGGING option
     
174. 
     
175. 
     
176. 
     
177. no rows selected
     
178. 
     
179. SQL>
     

复制代码

让RMAN去发现，并填充这3个corruption视图：

1. RMAN> backup tablespace tbslogical ;
   
2. 
   
3. Starting backup at 16-JUN-18
   
4. using channel ORA_SBT_TAPE_1
   
5. using channel ORA_SBT_TAPE_2
   
6. channel ORA_SBT_TAPE_1: starting full datafile backup set
   
7. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
   
8. input datafile file number=00006 name=+DATA/orcl/datafile/tbslogical.267.978972737
   
9. channel ORA_SBT_TAPE_1: starting piece 1 at 16-JUN-18
   
10. channel ORA_SBT_TAPE_1: finished piece 1 at 16-JUN-18
    
11. piece handle=1bt5js7i_1_1 tag=TAG20180616T165514 comment=API Version 2.0,MMS Version 10.4.0.4
    
12. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
    
13. Finished backup at 16-JUN-18
    
14. 
    
15. Starting Control File and SPFILE Autobackup at 16-JUN-18
    
16. piece handle=c-1343950367-20180616-02 comment=API Version 2.0,MMS Version 10.4.0.4
    
17. Finished Control File and SPFILE Autobackup at 16-JUN-18
    
18. 
    
19. RMAN>
    

复制代码

ADR也会反映事故：






关于MOS的视频：

游客，本帖隐藏的内容需要积分高于 10 才可浏览，您当前积分为 0