第23次活动：2017-10-11（星期三晚上7:00-9:30）

botang

ASM-FILE SYSTEM+SKIP TBS1

1. select  name from v$datafile;
   
2. 
   
3. select  member from v$logfile;
   
4. 
   
5. begin
   
6.    dbms_tts.transport_set_check('USERS');
   
7. end;
   
8. 
   
9. select  * from  transport_set_violations;
   
10. 
    
11. select  tablespace_name from dba_Tablespaces;
    
12. 
    
13. create tablespace tbs1 datafile size 10M ;
    
14. 
    
15. create table hr.emp2 tablespace tbs1 as select  * from hr.employees;

复制代码

1.     run{
   
2. allocate channel c1 device type disk;
   
3. allocate channel c2 device type disk;
   
4. allocate channel c3 device type disk;
   
5. allocate channel c4 device type disk;
   
6. allocate channel c5 device type disk;
   
7. allocate channel c6 device type disk;
   
8. allocate channel c7 device type disk;
   
9. allocate channel c8 device type disk;
   
10. allocate auxiliary channel c9 device type disk;
    
11. allocate auxiliary channel c10 device type disk;
    
12. allocate auxiliary channel c11 device type disk;
    
13. allocate auxiliary channel c12 device type disk;
    
14. allocate auxiliary channel c13 device type disk;
    
15. allocate auxiliary channel c14 device type disk;
    
16. allocate auxiliary channel c15 device type disk;
    
17. allocate auxiliary channel c16 device type disk;
    
18.     duplicate target database to mydb
    
19.     from active database
    
20.     nofilenamecheck
    
21.     skip tablespace tbs1
    
22.     spfile
    
23.     set
    
24.     control_files='/u01/app/oracle/oradata/mydb/control01.ctl','/u01/app/oracle/oradata/mydb/control02.ctl','/u01/app/oracle/oradata/mydb/control03.ctl'
    
25.     set
    
26.     db_file_name_convert='+DATA/orcl/datafile/users.259.816169553','/u01/app/oracle/oradata/mydb/users01.dbf','+DATA/orcl/datafile/undotbs1.258.816169553','/u01/app/oracle/oradata/mydb/undotbs01.dbf','+DATA/orcl/datafile/sysaux.257.816169553','/u01/app/oracle/oradata/mydb/sysaux01.dbf','+DATA/orcl/datafile/system.256.816169553','/u01/app/oracle/oradata/mydb/system01.dbf','+DATA/orcl/datafile/example.265.816169651','/u01/app/oracle/oradata/mydb/example01.dbf'
    
27.     set
    
28.     log_file_name_convert='+DATA/orcl/onlinelog/group_1.261.816169635','/u01/app/oracle/oradata/mydb/redo01a.log','+FRA/orcl/onlinelog/group_1.257.816169637','/u01/app/oracle/oradata/mydb/redo01b.log','+DATA/orcl/onlinelog/group_3.263.816169641','/u01/app/oracle/oradata/mydb/redo03a.log','+FRA/orcl/onlinelog/group_3.259.816169641','/u01/app/oracle/oradata/mydb/redo03b.log','+DATA/orcl/onlinelog/group_2.262.816169639','/u01/app/oracle/oradata/mydb/redo02a.log','+FRA/orcl/onlinelog/group_2.258.816169639','/u01/app/oracle/oradata/mydb/redo02b.log'
    
29.     set
    
30.     audit_file_dest='/u01/app/oracle/admin/mydb/adump'
    
31.     set
    
32.     db_create_file_dest=''
    
33.     set
    
34.     db_recovery_file_dest='/u01/app/oracle/flash_recovery_area';
    
35.     }

复制代码

BACKUP LOCATION备份端语法：

1. --源头把备份优化关掉，或用force语法
   
2. 
   
3. run {
   
4. allocate channel  c1 device type disk format '/home/oracle/backup/%U';
   
5. allocate channel  c2 device type disk format '/home/oracle/backup/%U';
   
6. allocate channel  c3 device type disk format '/home/oracle/backup/%U';
   
7. allocate channel  c4 device type disk format '/home/oracle/backup/%U';
   
8. allocate channel  c5 device type disk format '/home/oracle/backup/%U';
   
9. allocate channel  c6 device type disk format '/home/oracle/backup/%U';
   
10. allocate channel  c7 device type disk format '/home/oracle/backup/%U';
    
11. allocate channel  c8 device type disk format '/home/oracle/backup/%U';
    
12. backup database plus archivelog force;
    
13. backup spfile;
    
14. backup current controlfile;
    
15. }
    

复制代码

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 target database to new11g
    
11.     backup location '/home/oracle/backup'
    
12.     nofilenamecheck
    
13.     skip tablespace tbs1
    
14.     spfile
    
15.     set
    
16.     control_files='/u01/app/oracle/oradata/new11g/control01.ctl','/u01/app/oracle/oradata/new11g/control02.ctl','/u01/app/oracle/oradata/new11g/control03.ctl'
    
17.     set
    
18.     db_file_name_convert='+DATA/orcl/datafile/','/u01/app/oracle/oradata/new11g/'
    
19.     set
    
20.     log_file_name_convert='+DATA/orcl/onlinelog/','/u01/app/oracle/oradata/new11g/','+FRA/orcl/onlinelog/','/u01/app/oracle/oradata/new11g/'
    
21.     set
    
22.     audit_file_dest='/u01/app/oracle/admin/new11g/adump'
    
23.     set
    
24.     db_create_file_dest=''
    
25.     set
    
26.     db_recovery_file_dest='/u01/app/oracle/flash_recovery_area';
    
27.     }

复制代码

用到“%b”语法：

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.     SET NEWNAME FOR DATABASE TO '/u01/app/oracle/oradata/yourdb/%b';
    
11.     duplicate target database to yourdb
    
12.     backup location '/home/oracle/backup'
    
13.     nofilenamecheck
    
14.     skip tablespace example
    
15.     LOGFILE
    
16.     GROUP 1 ('/u01/app/oracle/oradata/yourdb/redo01a.log',
    
17.     '/u01/app/oracle/oradata/yourdb/redo01b.log') SIZE 50M REUSE,
    
18.     GROUP 2 ('/u01/app/oracle/oradata/yourdb/redo02a.log',
    
19.     '/u01/app/oracle/oradata/yourdb/redo02b.log') SIZE 50M REUSE,
    
20.     GROUP 3 ('/u01/app/oracle/oradata/yourdb/redo03a.log',
    
21.     '/u01/app/oracle/oradata/yourdb/redo03b.log') SIZE 50M REUSE
    
22.     spfile
    
23.     set
    
24.     control_files='/u01/app/oracle/oradata/yourdb/control01.ctl','/u01/app/oracle/oradata/yourdb/control02.ctl','/u01/app/oracle/oradata/yourdb/control03.ctl'
    
25.     set
    
26.     audit_file_dest='/u01/app/oracle/admin/yourdb/adump'
    
27.     set
    
28.     db_create_file_dest=''
    
29.     set
    
30.     db_recovery_file_dest='/u01/app/oracle/flash_recovery_area';
    
31. 
    
32.     }

复制代码

部分输出：

1. 13>     nofilenamecheck
   
2. 14>     skip tablespace example
   
3. 15>     LOGFILE
   
4. 16>     GROUP 1 ('/u01/app/oracle/oradata/yourdb/redo01a.log',
   
5. 17>     '/u01/app/oracle/oradata/yourdb/redo01b.log') SIZE 50M REUSE,
   
6. 18>     GROUP 2 ('/u01/app/oracle/oradata/yourdb/redo02a.log',
   
7. 19>     '/u01/app/oracle/oradata/yourdb/redo02b.log') SIZE 50M REUSE,
   
8. 20>     GROUP 3 ('/u01/app/oracle/oradata/yourdb/redo03a.log',
   
9. 21>     '/u01/app/oracle/oradata/yourdb/redo03b.log') SIZE 50M REUSE
   
10. 22>     spfile
    
11. 23>     set
    
12. 24>     control_files='/u01/app/oracle/oradata/yourdb/control01.ctl','/u01/app/oracle/oradata/yourdb/control02.ctl','/u01/app/oracle/oradata/yourdb/control03.ctl'
    
13. 25>     set
    
14. 26>     audit_file_dest='/u01/app/oracle/admin/yourdb/adump'
    
15. 27>     set
    
16. 28>     db_create_file_dest=''
    
17. 29>     set
    
18. 30>     db_recovery_file_dest='/u01/app/oracle/flash_recovery_area';
    
19. 31>
    
20. 32>     }
    
21. 33>
    
22. allocated channel: c1
    
23. channel c1: SID=429 device type=DISK
    
24. 
    
25. allocated channel: c2
    
26. channel c2: SID=5 device type=DISK
    
27. 
    
28. allocated channel: c3
    
29. channel c3: SID=146 device type=DISK
    
30. 
    
31. allocated channel: c4
    
32. channel c4: SID=288 device type=DISK
    
33. 
    
34. allocated channel: c5
    
35. channel c5: SID=430 device type=DISK
    
36. 
    
37. allocated channel: c6
    
38. channel c6: SID=6 device type=DISK
    
39. 
    
40. allocated channel: c7
    
41. channel c7: SID=147 device type=DISK
    
42. 
    
43. allocated channel: c8
    
44. channel c8: SID=289 device type=DISK
    
45. 
    
46. executing command: SET NEWNAME
    
47. 
    
48. Starting Duplicate Db at 11-OCT-17
    
49. 
    
50. contents of Memory Script:
    
51. {
    
52.    restore clone spfile to  '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileyourdb.ora' from
    
53. '/home/oracle/backup/2ksgp467_1_1';
    
54.    sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileyourdb.ora''";
    
55. }
    
56. executing Memory Script
    
57. 
    
58. Starting restore at 11-OCT-17
    
59. 
    
60. channel c2: skipped, AUTOBACKUP already found
    
61. channel c3: skipped, AUTOBACKUP already found
    
62. channel c4: skipped, AUTOBACKUP already found
    
63. channel c5: skipped, AUTOBACKUP already found
    
64. channel c6: skipped, AUTOBACKUP already found
    
65. channel c7: skipped, AUTOBACKUP already found
    
66. channel c8: skipped, AUTOBACKUP already found
    
67. channel c1: restoring spfile from AUTOBACKUP /home/oracle/backup/2ksgp467_1_1
    
68. channel c1: SPFILE restore from AUTOBACKUP complete
    
69. Finished restore at 11-OCT-17
    
70. 
    
71. sql statement: alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileyourdb.ora''
    
72. 
    
73. contents of Memory Script:
    
74. {
    
75.    sql clone "alter system set  db_name =
    
76. ''YOURDB'' comment=
    
77. ''duplicate'' scope=spfile";
    
78.    sql clone "alter system set  control_files =
    
79. ''/u01/app/oracle/oradata/yourdb/control01.ctl'', ''/u01/app/oracle/oradata/yourdb/control02.ctl'', ''/u01/app/oracle/oradata/yourdb/control03.ctl'' comment=
    
80. '''' scope=spfile";
    
81.    sql clone "alter system set  audit_file_dest =
    
82. ''/u01/app/oracle/admin/yourdb/adump'' comment=
    
83. '''' scope=spfile";
    
84.    sql clone "alter system set  db_create_file_dest =
    
85. '''' comment=
    
86. '''' scope=spfile";
    
87.    sql clone "alter system set  db_recovery_file_dest =
    
88. ''/u01/app/oracle/flash_recovery_area'' comment=
    
89. '''' scope=spfile";
    
90.    shutdown clone immediate;
    
91.    startup clone nomount;
    
92. }
    
93. executing Memory Script
    
94. 
    
95. sql statement: alter system set  db_name =  ''YOURDB'' comment= ''duplicate'' scope=spfile
    
96. 
    
97. sql statement: alter system set  control_files =  ''/u01/app/oracle/oradata/yourdb/control01.ctl'', ''/u01/app/oracle/oradata/yourdb/control02.ctl'', ''/u01/app/oracle/oradata/yourdb/control03.ctl'' comment= '''' scope=spfile
    
98. 
    
99. sql statement: alter system set  audit_file_dest =  ''/u01/app/oracle/admin/yourdb/adump'' comment= '''' scope=spfile
    
100. 
     
101. sql statement: alter system set  db_create_file_dest =  '''' comment= '''' scope=spfile
     
102. 
     
103. sql statement: alter system set  db_recovery_file_dest =  ''/u01/app/oracle/flash_recovery_area'' comment= '''' scope=spfile
     
104. 
     
105. Oracle instance shut down
     
106. 
     
107. connected to auxiliary database (not started)
     
108. Oracle instance started
     
109. 
     
110. Total System Global Area    1068937216 bytes
     
111. 
     
112. Fixed Size                     2235208 bytes
     
113. Variable Size                616563896 bytes
     
114. Database Buffers             444596224 bytes
     
115. Redo Buffers                   5541888 bytes
     
116. allocated channel: c1
     
117. channel c1: SID=63 device type=DISK
     
118. allocated channel: c2
     
119. channel c2: SID=129 device type=DISK
     
120. allocated channel: c3
     
121. channel c3: SID=192 device type=DISK
     
122. allocated channel: c4
     
123. channel c4: SID=6 device type=DISK
     
124. allocated channel: c5
     
125. channel c5: SID=67 device type=DISK
     
126. allocated channel: c6
     
127. channel c6: SID=130 device type=DISK
     
128. allocated channel: c7
     
129. channel c7: SID=193 device type=DISK
     
130. allocated channel: c8
     
131. channel c8: SID=7 device type=DISK
     
132. 
     
133. contents of Memory Script:
     
134. {
     
135.    sql clone "alter system set  db_name =
     
136. ''ORCL'' comment=
     
137. ''Modified by RMAN duplicate'' scope=spfile";
     
138.    sql clone "alter system set  db_unique_name =
     
139. ''YOURDB'' comment=
     
140. ''Modified by RMAN duplicate'' scope=spfile";
     
141.    shutdown clone immediate;
     
142.    startup clone force nomount
     
143.    restore clone primary controlfile from  '/home/oracle/backup/2lsgp468_1_1';
     
144.    alter clone database mount;
     
145. }
     
146. executing Memory Script
     
147. 
     
148. sql statement: alter system set  db_name =  ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile
     
149. 
     
150. sql statement: alter system set  db_unique_name =  ''YOURDB'' comment= ''Modified by RMAN duplicate'' scope=spfile
     
151. 
     
152. Oracle instance shut down
     
153. 
     
154. Oracle instance started
     
155. 
     
156. Total System Global Area    1068937216 bytes
     
157. 
     
158. Fixed Size                     2235208 bytes
     
159. Variable Size                616563896 bytes
     
160. Database Buffers             444596224 bytes
     
161. Redo Buffers                   5541888 bytes
     
162. allocated channel: c1
     
163. channel c1: SID=63 device type=DISK
     
164. allocated channel: c2
     
165. channel c2: SID=129 device type=DISK
     
166. allocated channel: c3
     
167. channel c3: SID=192 device type=DISK
     
168. allocated channel: c4
     
169. channel c4: SID=6 device type=DISK
     
170. allocated channel: c5
     
171. channel c5: SID=67 device type=DISK
     
172. allocated channel: c6
     
173. channel c6: SID=130 device type=DISK
     
174. allocated channel: c7
     
175. channel c7: SID=193 device type=DISK
     
176. allocated channel: c8
     
177. channel c8: SID=7 device type=DISK
     
178. 
     
179. Starting restore at 11-OCT-17
     
180. 
     
181. channel c2: skipped, AUTOBACKUP already found
     
182. channel c3: skipped, AUTOBACKUP already found
     
183. channel c4: skipped, AUTOBACKUP already found
     
184. channel c5: skipped, AUTOBACKUP already found
     
185. channel c6: skipped, AUTOBACKUP already found
     
186. channel c7: skipped, AUTOBACKUP already found
     
187. channel c8: skipped, AUTOBACKUP already found
     
188. channel c1: restoring control file
     
189. channel c1: restore complete, elapsed time: 00:00:08
     
190. output file name=/u01/app/oracle/oradata/yourdb/control01.ctl
     
191. output file name=/u01/app/oracle/oradata/yourdb/control02.ctl
     
192. output file name=/u01/app/oracle/oradata/yourdb/control03.ctl
     
193. Finished restore at 11-OCT-17
     
194. 
     
195. database mounted
     
196. Not connected to TARGET or TARGET not open, cannot verify that subset of tablespaces is self-contained
     
197. Not connected to TARGET, cannot verify that set of tablespaces being duplicated does not have SYS objects
     
198. Datafile 5 skipped by request
     
199. 
     
200. contents of Memory Script:
     
201. {
     
202.    set until scn  2145082;
     
203.    set newname for datafile  1 to
     
204. "/u01/app/oracle/oradata/yourdb/system.256.816169553";
     
205.    set newname for datafile  2 to
     
206. "/u01/app/oracle/oradata/yourdb/sysaux.257.816169553";
     
207.    set newname for datafile  3 to
     
208. "/u01/app/oracle/oradata/yourdb/undotbs1.258.816169553";
     
209.    set newname for datafile  4 to
     
210. "/u01/app/oracle/oradata/yourdb/users.259.816169553";
     
211.    set newname for datafile  6 to
     
212. "/u01/app/oracle/oradata/yourdb/tbs1.267.957123085";
     
213.    restore
     
214.    clone database
     
215.    skip forever tablespace  "EXAMPLE"   ;
     
216. }
     
217. executing Memory Script
     
218. 
     
219. executing command: SET until clause
     
220. 
     
221. executing command: SET NEWNAME
     
222. 
     
223. executing command: SET NEWNAME
     
224. 
     
225. executing command: SET NEWNAME
     
226. 
     
227. executing command: SET NEWNAME
     
228. 
     
229. executing command: SET NEWNAME
     
230. 
     
231. Starting restore at 11-OCT-17
     
232. 
     
233. channel c1: starting datafile backup set restore
     
234. channel c1: specifying datafile(s) to restore from backup set
     
235. channel c1: restoring datafile 00002 to /u01/app/oracle/oradata/yourdb/sysaux.257.816169553
     
236. channel c1: reading from backup piece /home/oracle/backup/2fsgp45t_1_1
     
237. channel c2: starting datafile backup set restore
     
238. channel c2: specifying datafile(s) to restore from backup set
     
239. channel c2: restoring datafile 00003 to /u01/app/oracle/oradata/yourdb/undotbs1.258.816169553
     
240. channel c2: reading from backup piece /home/oracle/backup/2esgp45t_1_1
     
241. channel c3: starting datafile backup set restore
     
242. channel c3: specifying datafile(s) to restore from backup set
     
243. channel c3: restoring datafile 00004 to /u01/app/oracle/oradata/yourdb/users.259.816169553
     
244. channel c3: reading from backup piece /home/oracle/backup/2isgp45v_1_1
     
245. channel c4: starting datafile backup set restore
     
246. channel c4: specifying datafile(s) to restore from backup set
     
247. channel c4: restoring datafile 00006 to /u01/app/oracle/oradata/yourdb/tbs1.267.957123085
     
248. channel c4: reading from backup piece /home/oracle/backup/2hsgp45u_1_1
     
249. channel c5: starting datafile backup set restore
     
250. channel c5: specifying datafile(s) to restore from backup set
     
251. channel c5: restoring datafile 00001 to /u01/app/oracle/oradata/yourdb/system.256.816169553
     
252. channel c5: reading from backup piece /home/oracle/backup/2dsgp45t_1_1
     
253. channel c3: piece handle=/home/oracle/backup/2isgp45v_1_1 tag=TAG20171011T195957
     
254. channel c3: restored backup piece 1
     
255. channel c3: restore complete, elapsed time: 00:00:01
     
256. channel c4: piece handle=/home/oracle/backup/2hsgp45u_1_1 tag=TAG20171011T195957
     
257. channel c4: restored backup piece 1
     
258. channel c4: restore complete, elapsed time: 00:00:01
     
259. channel c1: piece handle=/home/oracle/backup/2fsgp45t_1_1 tag=TAG20171011T195957
     
260. channel c1: restored backup piece 1
     
261. channel c1: restore complete, elapsed time: 00:00:07
     
262. channel c2: piece handle=/home/oracle/backup/2esgp45t_1_1 tag=TAG20171011T195957
     
263. channel c2: restored backup piece 1
     
264. channel c2: restore complete, elapsed time: 00:00:15
     
265. channel c5: piece handle=/home/oracle/backup/2dsgp45t_1_1 tag=TAG20171011T195957
     
266. channel c5: restored backup piece 1
     
267. channel c5: restore complete, elapsed time: 00:00:15
     
268. Finished restore at 11-OCT-17
     
269. 
     
270. contents of Memory Script:
     
271. {
     
272.    switch clone datafile all;
     
273. }
     
274. executing Memory Script
     
275. 
     
276. datafile 1 switched to datafile copy
     
277. input datafile copy RECID=6 STAMP=957127094 file name=/u01/app/oracle/oradata/yourdb/system.256.816169553
     
278. datafile 2 switched to datafile copy
     
279. input datafile copy RECID=7 STAMP=957127095 file name=/u01/app/oracle/oradata/yourdb/sysaux.257.816169553
     
280. datafile 3 switched to datafile copy
     
281. input datafile copy RECID=8 STAMP=957127095 file name=/u01/app/oracle/oradata/yourdb/undotbs1.258.816169553
     
282. datafile 4 switched to datafile copy
     
283. input datafile copy RECID=9 STAMP=957127095 file name=/u01/app/oracle/oradata/yourdb/users.259.816169553
     
284. datafile 6 switched to datafile copy
     
285. input datafile copy RECID=10 STAMP=957127096 file name=/u01/app/oracle/oradata/yourdb/tbs1.267.957123085
     
286. 
     
287. contents of Memory Script:
     
288. {
     
289.    set until scn  2145082;
     
290.    recover
     
291.    clone database
     
292.    skip forever tablespace  "EXAMPLE"    delete archivelog
     
293.    ;
     
294. }
     
295. executing Memory Script
     
296. 
     
297. executing command: SET until clause
     
298. 
     
299. Starting recover at 11-OCT-17
     
300. 
     
301. Executing: alter database datafile 5 offline drop
     
302. starting media recovery
     
303. 
     
304. channel c1: starting archived log restore to default destination
     
305. channel c1: restoring archived log
     
306. archived log thread=1 sequence=117
     
307. channel c1: reading from backup piece /home/oracle/backup/2jsgp465_1_1
     
308. channel c1: piece handle=/home/oracle/backup/2jsgp465_1_1 tag=TAG20171011T200005
     
309. channel c1: restored backup piece 1
     
310. channel c1: restore complete, elapsed time: 00:00:01
     
311. archived log file name=/u01/app/oracle/flash_recovery_area/YOURDB/archivelog/2017_10_11/o1_mf_1_117_dxw45t7b_.arc thread=1 sequence=117
     
312. channel clone_default: deleting archived log(s)
     
313. archived log file name=/u01/app/oracle/flash_recovery_area/YOURDB/archivelog/2017_10_11/o1_mf_1_117_dxw45t7b_.arc RECID=1 STAMP=957127098
     
314. media recovery complete, elapsed time: 00:00:00
     
315. Finished recover at 11-OCT-17
     
316. Oracle instance started
     
317. 
     
318. Total System Global Area    1068937216 bytes
     
319. 
     
320. Fixed Size                     2235208 bytes
     
321. Variable Size                620758200 bytes
     
322. Database Buffers             440401920 bytes
     
323. Redo Buffers                   5541888 bytes
     
324. 
     
325. contents of Memory Script:
     
326. {
     
327.    sql clone "alter system set  db_name =
     
328. ''YOURDB'' comment=
     
329. ''Reset to original value by RMAN'' scope=spfile";
     
330.    sql clone "alter system reset  db_unique_name scope=spfile";
     
331.    shutdown clone immediate;
     
332.    startup clone nomount;
     
333. }
     
334. executing Memory Script
     
335. 
     
336. sql statement: alter system set  db_name =  ''YOURDB'' comment= ''Reset to original value by RMAN'' scope=spfile
     
337. 
     
338. sql statement: alter system reset  db_unique_name scope=spfile
     
339. 
     
340. Oracle instance shut down
     
341. 
     
342. connected to auxiliary database (not started)
     
343. Oracle instance started
     
344. 
     
345. Total System Global Area    1068937216 bytes
     
346. 
     
347. Fixed Size                     2235208 bytes
     
348. Variable Size                620758200 bytes
     
349. Database Buffers             440401920 bytes
     
350. Redo Buffers                   5541888 bytes
     
351. allocated channel: c1
     
352. channel c1: SID=63 device type=DISK
     
353. allocated channel: c2
     
354. channel c2: SID=129 device type=DISK
     
355. allocated channel: c3
     
356. channel c3: SID=192 device type=DISK
     
357. allocated channel: c4
     
358. channel c4: SID=6 device type=DISK
     
359. allocated channel: c5
     
360. channel c5: SID=67 device type=DISK
     
361. allocated channel: c6
     
362. channel c6: SID=130 device type=DISK
     
363. allocated channel: c7
     
364. channel c7: SID=193 device type=DISK
     
365. allocated channel: c8
     
366. channel c8: SID=7 device type=DISK
     
367. sql statement: CREATE CONTROLFILE REUSE SET DATABASE "YOURDB" RESETLOGS ARCHIVELOG
     
368.   MAXLOGFILES     16
     
369.   MAXLOGMEMBERS      3
     
370.   MAXDATAFILES      100
     
371.   MAXINSTANCES     8
     
372.   MAXLOGHISTORY      292
     
373. LOGFILE
     
374.   GROUP   1 ( '/u01/app/oracle/oradata/yourdb/redo01a.log', '/u01/app/oracle/oradata/yourdb/redo01b.log' ) SIZE 50 M  REUSE,
     
375.   GROUP   2 ( '/u01/app/oracle/oradata/yourdb/redo02a.log', '/u01/app/oracle/oradata/yourdb/redo02b.log' ) SIZE 50 M  REUSE,
     
376.   GROUP   3 ( '/u01/app/oracle/oradata/yourdb/redo03a.log', '/u01/app/oracle/oradata/yourdb/redo03b.log' ) SIZE 50 M  REUSE
     
377. DATAFILE
     
378.   '/u01/app/oracle/oradata/yourdb/system.256.816169553'
     
379. CHARACTER SET AL32UTF8
     
380. 
     
381. 
     
382. contents of Memory Script:
     
383. {
     
384.    set newname for tempfile  1 to
     
385. "/u01/app/oracle/oradata/yourdb/temp.264.816169645";
     
386.    switch clone tempfile all;
     
387.    catalog clone datafilecopy  "/u01/app/oracle/oradata/yourdb/sysaux.257.816169553",
     
388. "/u01/app/oracle/oradata/yourdb/undotbs1.258.816169553",
     
389. "/u01/app/oracle/oradata/yourdb/users.259.816169553",
     
390. "/u01/app/oracle/oradata/yourdb/tbs1.267.957123085";
     
391.    switch clone datafile all;
     
392. }
     
393. executing Memory Script
     
394. 
     
395. executing command: SET NEWNAME
     
396. 
     
397. renamed tempfile 1 to /u01/app/oracle/oradata/yourdb/temp.264.816169645 in control file
     
398. 
     
399. cataloged datafile copy
     
400. datafile copy file name=/u01/app/oracle/oradata/yourdb/sysaux.257.816169553 RECID=1 STAMP=957127125
     
401. cataloged datafile copy
     
402. datafile copy file name=/u01/app/oracle/oradata/yourdb/undotbs1.258.816169553 RECID=2 STAMP=957127125
     
403. cataloged datafile copy
     
404. datafile copy file name=/u01/app/oracle/oradata/yourdb/users.259.816169553 RECID=3 STAMP=957127126
     
405. cataloged datafile copy
     
406. datafile copy file name=/u01/app/oracle/oradata/yourdb/tbs1.267.957123085 RECID=4 STAMP=957127126
     
407. 
     
408. datafile 2 switched to datafile copy
     
409. input datafile copy RECID=1 STAMP=957127125 file name=/u01/app/oracle/oradata/yourdb/sysaux.257.816169553
     
410. datafile 3 switched to datafile copy
     
411. input datafile copy RECID=2 STAMP=957127125 file name=/u01/app/oracle/oradata/yourdb/undotbs1.258.816169553
     
412. datafile 4 switched to datafile copy
     
413. input datafile copy RECID=3 STAMP=957127126 file name=/u01/app/oracle/oradata/yourdb/users.259.816169553
     
414. datafile 6 switched to datafile copy
     
415. input datafile copy RECID=4 STAMP=957127126 file name=/u01/app/oracle/oradata/yourdb/tbs1.267.957123085
     
416. Reenabling controlfile options for auxiliary database
     
417. Executing: alter database enable block change tracking using file '+FRA/orcl/changetracking/ctf.260.829329115'
     
418. ORACLE error from auxiliary database: ORA-19751: could not create the change tracking file
     
419. ORA-19750: change tracking file: '+FRA/orcl/changetracking/ctf.260.829329115'
     
420. ORA-17502: ksfdcre:4 Failed to create file +FRA/orcl/changetracking/ctf.260.829329115
     
421. ORA-15046: ASM file name '+FRA/orcl/changetracking/ctf.260.829329115' is not in single-file creation form
     
422. 
     
423. Ignoring error, reattempt command after duplicate finishes
     
424. 
     
425. contents of Memory Script:
     
426. {
     
427.    Alter clone database open resetlogs;
     
428. }
     
429. executing Memory Script
     
430. 
     
431. database opened
     
432. Dropping offline and skipped tablespaces
     
433. Executing: drop tablespace "EXAMPLE" including contents cascade constraints
     
434. released channel: c1
     
435. released channel: c2
     
436. released channel: c3
     
437. released channel: c4
     
438. released channel: c5
     
439. released channel: c6
     
440. released channel: c7
     
441. released channel: c8
     
442. RMAN-00571: ===========================================================
     
443. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
     
444. RMAN-00571: ===========================================================
     
445. RMAN-03002: failure of Duplicate Db command at 10/11/2017 20:38:56
     
446. RMAN-05501: aborting duplication of target database
     
447. RMAN-06136: ORACLE error from auxiliary database: ORA-29857: domain indexes and/or secondary objects exist in the tablespace
     
448. 
     
449. Recovery Manager complete.
     
450. [oracle@station30 ~]$ sqlplus /nolog
     
451. 
     
452. SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 11 20:39:15 2017
     
453. 
     
454. Copyright (c) 1982, 2011, Oracle.  All rights reserved.
     
455. 
     
456. SQL> conn / as sysdba
     
457. Connected.
     
458. SQL> select  open_mode from v$database;
     
459. 
     
460. OPEN_MODE
     
461. --------------------
     
462. READ WRITE
     
463. 
     
464. SQL> select  tablespace_name from dba_tablespaces;
     
465. 
     
466. TABLESPACE_NAME
     
467. ------------------------------
     
468. SYSTEM
     
469. SYSAUX
     
470. UNDOTBS1
     
471. TEMP
     
472. USERS
     
473. EXAMPLE
     
474. TBS1
     
475. 
     
476. 7 rows selected.
     
477. 
     
478. SQL>
     

复制代码

RMAN调优：

1. SELECT s.sid, p.spid, s.client_info
   
2.   FROM v$process p, v$session s
   
3.    WHERE p.addr = s.paddr
   
4.    AND CLIENT_INFO LIKE '%id=botang%';
   
5. 
   
6. 
   
7. ----
   
8. SELECT s.sid, p.spid, s.client_info
   
9.   FROM v$process p, v$session s
   
10.    WHERE p.addr = s.paddr
    
11.     and program like '%rman%';
    
12.    
    
13. ---
    
14. 
    
15. select * from v$backup_sync_io;
    
16. 
    
17. select  * from v$backup_async_io ;
    
18. 
    
19. -----
    
20. 
    
21. SELECT OPNAME, CONTEXT, SOFAR, TOTALWORK,
    
22.     ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
    
23.    FROM V$SESSION_LONGOPS
    
24.    WHERE OPNAME LIKE 'RMAN%'
    
25.    AND TOTALWORK != 0
    
26.   AND SOFAR <> TOTALWORK;
    
27. 
    
28. 
    
29.    

复制代码

1. RMAN> run {
   
2. 2> set command id to 'botang';
   
3. 3> allocate channel c1 device type sbt;
   
4. 4> allocate channel c2 device type sbt;
   
5. 5> backup   tag 'MY4'  duration  00:06 minimize load     (datafile 1 channel c1 ) ( datafile 2,3,4,5,6 channel c2 )   ;
   
6. 6> }
   
7. 
   
8. executing command: SET COMMAND ID
   
9. 
   
10. allocated channel: c1
    
11. channel c1: SID=200 device type=SBT_TAPE
    
12. channel c1: Oracle Secure Backup
    
13. 
    
14. allocated channel: c2
    
15. channel c2: SID=16 device type=SBT_TAPE
    
16. channel c2: Oracle Secure Backup
    
17. 
    
18. Starting backup at 11-OCT-17
    
19. channel c1: starting full datafile backup set
    
20. channel c1: specifying datafile(s) in backup set
    
21. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
    
22. channel c1: starting piece 1 at 11-OCT-17
    
23. channel c2: starting full datafile backup set
    
24. channel c2: specifying datafile(s) in backup set
    
25. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
    
26. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
    
27. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
    
28. input datafile file number=00006 name=+DATA/orcl/datafile/tbs1.267.957123085
    
29. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
    
30. channel c2: starting piece 1 at 11-OCT-17
    
31. 
    

复制代码