课程第19次（2018-07-19星期四）

botang

1. [oracle@station87 ~]$ rman target /
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jul 19 19:18:28 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to target database: UTFORCL (DBID=454057935)
   
8. 
   
9. RMAN> list incarnation of database;
   
10. 
    
11. using target database control file instead of recovery catalog
    
12. 
    
13. List of Database Incarnations
    
14. DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
    
15. ------- ------- -------- ---------------- --- ---------- ----------
    
16. 1       1       UTFORCL  454057935        PARENT  940976     2013-06-29:23:35:45
    
17. 2       2       UTFORCL  454057935        CURRENT 1037166    2018-07-17:21:42:43
    
18. 
    
19. RMAN> exit
    

复制代码

1. [oracle@station87 dbs]$ nid  target=sys/oracle_4U  DBNAME=myorcl
   
2. 
   
3. DBNEWID: Release 11.2.0.1.0 - Production on Thu Jul 19 19:24:26 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. Connected to database UTFORCL (DBID=454057935)
   
8. 
   
9. NID-00121: Database should not be open
   
10. 
    
11. 
    
12. Change of database name failed during validation - database is intact.
    
13. DBNEWID - Completed with validation errors.
    
14. 
    

复制代码

1. [oracle@station87 dbs]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 19 19:24:32 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
   
6. 
   
7. SQL> conn / as sysdba
   
8. Connected.
   
9. SQL> shutdown immediate
   
10. Database closed.
    
11. Database dismounted.
    
12. ORACLE instance shut down.
    
13. SQL> startup mount
    
14. ORACLE instance started.
    
15. 
    
16. Total System Global Area  857903104 bytes
    
17. Fixed Size                    1339880 bytes
    
18. Variable Size                  566234648 bytes
    
19. Database Buffers          285212672 bytes
    
20. Redo Buffers                    5115904 bytes
    
21. Database mounted.
    

复制代码

1. [oracle@station87 dbs]$ nid  target=sys/oracle_4U  DBNAME=myorcl
   
2. 
   
3. DBNEWID: Release 11.2.0.1.0 - Production on Thu Jul 19 19:27:01 2018
   
4. 
   
5. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. Connected to database UTFORCL (DBID=454057935)
   
8. 
   
9. Connected to server version 11.2.0
   
10. 
    
11. Control Files in database:
    
12.     /u01/app/oracle/oradata/utforcl/control01.ctl
    
13.     /u01/app/oracle/oradata/utforcl/control02.ctl
    
14.     /u01/app/oracle/oradata/utforcl/control03.ctl
    
15. 
    
16. Change database ID and database name UTFORCL to MYORCL? (Y/[N]) => Y
    
17. 
    
18. Proceeding with operation
    
19. Changing database ID from 454057935 to 402450949
    
20. Changing database name from UTFORCL to MYORCL
    
21.     Control File /u01/app/oracle/oradata/utforcl/control01.ctl - modified
    
22.     Control File /u01/app/oracle/oradata/utforcl/control02.ctl - modified
    
23.     Control File /u01/app/oracle/oradata/utforcl/control03.ctl - modified
    
24.     Datafile /u01/app/oracle/oradata/utforcl/system01.db - dbid changed, wrote new name
    
25.     Datafile /u01/app/oracle/oradata/utforcl/sysaux01.db - dbid changed, wrote new name
    
26.     Datafile /u01/app/oracle/oradata/utforcl/undotbs1.db - dbid changed, wrote new name
    
27.     Datafile /u01/app/oracle/oradata/utforcl/users01.db - dbid changed, wrote new name
    
28.     Datafile /u01/app/oracle/oradata/utforcl/example01.db - dbid changed, wrote new name
    
29.     Datafile /u01/app/oracle/oradata/utforcl/tbsutf8_11g.db - dbid changed, wrote new name
    
30.     Datafile /u01/app/oracle/oradata/utforcl/temp01.db - dbid changed, wrote new name
    
31.     Control File /u01/app/oracle/oradata/utforcl/control01.ctl - dbid changed, wrote new name
    
32.     Control File /u01/app/oracle/oradata/utforcl/control02.ctl - dbid changed, wrote new name
    
33.     Control File /u01/app/oracle/oradata/utforcl/control03.ctl - dbid changed, wrote new name
    
34.     Instance shut down
    
35. 
    
36. Database name changed to MYORCL.
    
37. Modify parameter file and generate a new password file before restarting.
    
38. Database ID for database MYORCL changed to 402450949.
    
39. All previous backups and archived redo logs for this database are unusable.
    
40. Database is not aware of previous backups and archived logs in Recovery Area.
    
41. Database has been shutdown, open database with RESETLOGS option.
    
42. Succesfully changed database name and ID.
    
43. DBNEWID - Completed succesfully.
    
44. 
    
45. [oracle@station87 dbs]$
    

复制代码

准备新的spfile和orapw文件，
[oracle@station87 oracle]$ cd admin/
[oracle@station87 admin]$ ls
+ASM  utforcl
[oracle@station87 admin]$ mkdir -p myorcl/adump
[oracle@station87 admin]$

启动myorcl实例：

1. [oracle@station87 dbs]$ ps aux | grep ora_smon
   
2. oracle    8380  0.0  0.0   4220   628 pts/1    S+   19:28   0:00 grep ora_smon
   
3. [oracle@station87 dbs]$ ls
   
4. 1.txt  hc_utforcl.dat  init.ora  initutforcl.ora  lkUTFORCL  orapwutforcl  peshm_utforcl_0  spfileutforcl.ora
   
5. [oracle@station87 dbs]$ . oraenv
   
6. ORACLE_SID = [utforcl] ?
   
7. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
   
8. [oracle@station87 dbs]$ sqlplus /nolog
   
9. 
   
10. SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 19 19:28:43 2018
    
11. 
    
12. Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
13. 
    
14. SQL> conn / as sysdba
    
15. Connected to an idle instance.
    
16. SQL> create pfile from spfile;
    
17. 
    
18. File created.
    
19. 
    
20. SQL> exit
    
21. Disconnected
    
22. [oracle@station87 dbs]$ ls
    
23. 1.txt  hc_utforcl.dat  init.ora  initutforcl.ora  lkUTFORCL  orapwutforcl  peshm_utforcl_0  spfileutforcl.ora
    
24. [oracle@station87 dbs]$ mv initutforcl.ora  initmyorcl.ora
    
25. [oracle@station87 dbs]$ ls
    
26. 1.txt  hc_utforcl.dat  initmyorcl.ora  init.ora  lkUTFORCL  orapwutforcl  peshm_utforcl_0  spfileutforcl.ora
    
27. [oracle@station87 dbs]$ rm -f spfileutforcl.ora
    
28. [oracle@station87 dbs]$ ls
    
29. 1.txt  hc_utforcl.dat  initmyorcl.ora  init.ora  lkUTFORCL  orapwutforcl  peshm_utforcl_0
    
30. [oracle@station87 dbs]$ mv orapwutforcl orapwmyorcl
    
31. [oracle@station87 dbs]$ ls
    
32. 1.txt  hc_utforcl.dat  initmyorcl.ora  init.ora  lkUTFORCL  orapwmyorcl  peshm_utforcl_0
    
33. [oracle@station87 dbs]$ vim initmyorcl.ora
    
34. [oracle@station87 dbs][        DISCUZ_CODE_65        ]nbsp;
    

复制代码

改一下/etc/oratab：

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

复制代码

克隆的过程中，一定要注意：
1. auxiliary instance一定要带@连接。
2. auxiliary instance一定要静态注册监听器。
----------------------------------------------------------------------------
在克隆之前，先确保以下rman命令会成功：

1. [oracle@station87 admin]$ rman target  sys/oracle_4U@orcl auxiliary sys/oracle_4U@clonedb
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jul 19 20:21:40 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 auxiliary database: CLONEDB (not mounted)
   
9. 
   
10. RMAN>
    

复制代码

注意一下，由于 OMF文件名写死的问题，块跟踪在克隆之前，要先停掉。

1. [oracle@station87 ~]$ rman target  sys/oracle_4U@orcl auxiliary sys/oracle_4U@clonedb
   
2. 
   
3. Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jul 19 20:31:31 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 auxiliary database: CLONEDB (not mounted)
   
9. 
   
10. RMAN> run  {
    
11. 2> allocate channel c1 device type disk;
    
12. 3> allocate channel c2 device type disk;
    
13. 4> allocate channel c3 device type disk;
    
14. 5> allocate channel c4 device type disk;
    
15. 6> allocate channel c5 device type disk;
    
16. 7> allocate channel c6 device type disk;
    
17. 8> allocate channel c7 device type disk;
    
18. 9> allocate channel c8 device type disk;
    
19. 10> allocate auxiliary channel c9 device type disk;
    
20. 11> allocate auxiliary channel c10 device type disk;
    
21. 12> allocate auxiliary channel c11 device type disk;
    
22. 13> allocate auxiliary channel c12 device type disk;
    
23. 14> allocate auxiliary channel c13 device type disk;
    
24. 15> allocate auxiliary channel c14 device type disk;
    
25. 16> allocate auxiliary channel c15 device type disk;
    
26. 17> allocate auxiliary channel c16 device type disk;
    
27. 18> duplicate target database to clonedb
    
28. 19> from active database
    
29. 20> nofilenamecheck
    
30. 21> spfile
    
31. 22> set
    
32. 23> control_files='+DATA','+FRA'
    
33. 24> set
    
34. 25> db_file_name_convert='+DATA/orcl/','+DATA/clonedb/'
    
35. 26> set
    
36. 27> log_file_name_convert='+DATA/orcl','+DATA/clonedb/'
    
37. 28> set
    
38. 29> audit_file_dest='/u01/app/oracle/admin/clonedb/adump';
    
39. 30> }
    
40. 
    
41. using target database control file instead of recovery catalog
    
42. allocated channel: c1
    
43. channel c1: SID=143 device type=DISK
    
44. 
    
45. allocated channel: c2
    
46. channel c2: SID=14 device type=DISK
    
47. 
    
48. allocated channel: c3
    
49. channel c3: SID=54 device type=DISK
    
50. 
    
51. allocated channel: c4
    
52. channel c4: SID=12 device type=DISK
    
53. 
    
54. allocated channel: c5
    
55. channel c5: SID=55 device type=DISK
    
56. 
    
57. allocated channel: c6
    
58. channel c6: SID=99 device type=DISK
    
59. 
    
60. allocated channel: c7
    
61. channel c7: SID=141 device type=DISK
    
62. 
    
63. allocated channel: c8
    
64. channel c8: SID=10 device type=DISK
    
65. 
    
66. allocated channel: c9
    
67. channel c9: SID=47 device type=DISK
    
68. 
    
69. allocated channel: c10
    
70. channel c10: SID=5 device type=DISK
    
71. 
    
72. allocated channel: c11
    
73. channel c11: SID=48 device type=DISK
    
74. 
    
75. allocated channel: c12
    
76. channel c12: SID=92 device type=DISK
    
77. 
    
78. allocated channel: c13
    
79. channel c13: SID=136 device type=DISK
    
80. 
    
81. allocated channel: c14
    
82. channel c14: SID=6 device type=DISK
    
83. 
    
84. allocated channel: c15
    
85. channel c15: SID=49 device type=DISK
    
86. 
    
87. allocated channel: c16
    
88. channel c16: SID=93 device type=DISK
    
89. 
    
90. Starting Duplicate Db at 2018-07-19:20:33:54
    
91. 
    
92. contents of Memory Script:
    
93. {
    
94.    backup as copy reuse
    
95.    targetfile  '+DATA/orcl/spfileorcl.ora' auxiliary format
    
96. '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileclonedb.ora'   ;
    
97.    sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileclonedb.ora''";
    
98. }
    
99. executing Memory Script
    
100. 
     
101. Starting backup at 2018-07-19:20:33:54
     
102. Finished backup at 2018-07-19:20:33:55
     
103. 
     
104. sql statement: alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileclonedb.ora''
     
105. 
     
106. contents of Memory Script:
     
107. {
     
108.    sql clone "alter system set  db_name =
     
109. ''CLONEDB'' comment=
     
110. ''duplicate'' scope=spfile";
     
111.    sql clone "alter system set  control_files =
     
112. ''+DATA'', ''+FRA'' comment=
     
113. '''' scope=spfile";
     
114.    sql clone "alter system set  db_file_name_convert =
     
115. ''+DATA/orcl/'', ''+DATA/clonedb/'' comment=
     
116. '''' scope=spfile";
     
117.    sql clone "alter system set  log_file_name_convert =
     
118. ''+DATA/orcl'', ''+DATA/clonedb/'' comment=
     
119. '''' scope=spfile";
     
120.    sql clone "alter system set  audit_file_dest =
     
121. ''/u01/app/oracle/admin/clonedb/adump'' comment=
     
122. '''' scope=spfile";
     
123.    shutdown clone immediate;
     
124.    startup clone nomount;
     
125. }
     
126. executing Memory Script
     
127. 
     
128. sql statement: alter system set  db_name =  ''CLONEDB'' comment= ''duplicate'' scope=spfile
     
129. 
     
130. sql statement: alter system set  control_files =  ''+DATA'', ''+FRA'' comment= '''' scope=spfile
     
131. 
     
132. sql statement: alter system set  db_file_name_convert =  ''+DATA/orcl/'', ''+DATA/clonedb/'' comment= '''' scope=spfile
     
133. 
     
134. sql statement: alter system set  log_file_name_convert =  ''+DATA/orcl'', ''+DATA/clonedb/'' comment= '''' scope=spfile
     
135. 
     
136. sql statement: alter system set  audit_file_dest =  ''/u01/app/oracle/admin/clonedb/adump'' comment= '''' scope=spfile
     
137. 
     
138. Oracle instance shut down
     
139. 
     
140. connected to auxiliary database (not started)
     
141. Oracle instance started
     
142. 
     
143. Total System Global Area    1046224896 bytes
     
144. 
     
145. Fixed Size                     1341140 bytes
     
146. Variable Size                603982124 bytes
     
147. Database Buffers             436207616 bytes
     
148. Redo Buffers                   4694016 bytes
     
149. allocated channel: c9
     
150. channel c9: SID=92 device type=DISK
     
151. allocated channel: c10
     
152. channel c10: SID=130 device type=DISK
     
153. allocated channel: c11
     
154. channel c11: SID=6 device type=DISK
     
155. allocated channel: c12
     
156. channel c12: SID=50 device type=DISK
     
157. allocated channel: c13
     
158. channel c13: SID=93 device type=DISK
     
159. allocated channel: c14
     
160. channel c14: SID=137 device type=DISK
     
161. allocated channel: c15
     
162. channel c15: SID=7 device type=DISK
     
163. allocated channel: c16
     
164. channel c16: SID=51 device type=DISK
     
165. 
     
166. contents of Memory Script:
     
167. {
     
168.    sql clone "alter system set  control_files =
     
169.   ''+DATA/clonedb/controlfile/current.269.981923651'', ''+FRA/clonedb/controlfile/current.358.981923651'' comment=
     
170. ''Set by RMAN'' scope=spfile";
     
171.    sql clone "alter system set  db_name =
     
172. ''ORCL'' comment=
     
173. ''Modified by RMAN duplicate'' scope=spfile";
     
174.    sql clone "alter system set  db_unique_name =
     
175. ''CLONEDB'' comment=
     
176. ''Modified by RMAN duplicate'' scope=spfile";
     
177.    shutdown clone immediate;
     
178.    startup clone force nomount
     
179.    backup as copy current controlfile auxiliary format  '+DATA/clonedb/controlfile/current.261.981923651';
     
180.    restore clone controlfile to  '+FRA/clonedb/controlfile/current.349.981923651' from
     
181. '+DATA/clonedb/controlfile/current.261.981923651';
     
182.    sql clone "alter system set  control_files =
     
183.   ''+DATA/clonedb/controlfile/current.261.981923651'', ''+FRA/clonedb/controlfile/current.349.981923651'' comment=
     
184. ''Set by RMAN'' scope=spfile";
     
185.    shutdown clone immediate;
     
186.    startup clone nomount;
     
187.    alter clone database mount;
     
188. }
     
189. executing Memory Script
     
190. 
     
191. sql statement: alter system set  control_files =   ''+DATA/clonedb/controlfile/current.269.981923651'', ''+FRA/clonedb/controlfile/current.358.981923651'' comment= ''Set by RMAN'' scope=spfile
     
192. 
     
193. sql statement: alter system set  db_name =  ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile
     
194. 
     
195. sql statement: alter system set  db_unique_name =  ''CLONEDB'' comment= ''Modified by RMAN duplicate'' scope=spfile
     
196. 
     
197. Oracle instance shut down
     
198. 
     
199. Oracle instance started
     
200. 
     
201. Total System Global Area    1046224896 bytes
     
202. 
     
203. Fixed Size                     1341140 bytes
     
204. Variable Size                603982124 bytes
     
205. Database Buffers             436207616 bytes
     
206. Redo Buffers                   4694016 bytes
     
207. allocated channel: c9
     
208. channel c9: SID=92 device type=DISK
     
209. allocated channel: c10
     
210. channel c10: SID=136 device type=DISK
     
211. allocated channel: c11
     
212. channel c11: SID=6 device type=DISK
     
213. allocated channel: c12
     
214. channel c12: SID=50 device type=DISK
     
215. allocated channel: c13
     
216. channel c13: SID=93 device type=DISK
     
217. allocated channel: c14
     
218. channel c14: SID=137 device type=DISK
     
219. allocated channel: c15
     
220. channel c15: SID=7 device type=DISK
     
221. allocated channel: c16
     
222. channel c16: SID=51 device type=DISK
     
223. 
     
224. Starting backup at 2018-07-19:20:34:23
     
225. channel c1: starting datafile copy
     
226. copying current control file
     
227. output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f tag=TAG20180719T203422 RECID=38 STAMP=981923663
     
228. channel c1: datafile copy complete, elapsed time: 00:00:01
     
229. Finished backup at 2018-07-19:20:34:24
     
230. 
     
231. Starting restore at 2018-07-19:20:34:24
     
232. 
     
233. channel c10: skipped, AUTOBACKUP already found
     
234. channel c11: skipped, AUTOBACKUP already found
     
235. channel c12: skipped, AUTOBACKUP already found
     
236. channel c13: skipped, AUTOBACKUP already found
     
237. channel c14: skipped, AUTOBACKUP already found
     
238. channel c15: skipped, AUTOBACKUP already found
     
239. channel c16: skipped, AUTOBACKUP already found
     
240. channel c9: copied control file copy
     
241. Finished restore at 2018-07-19:20:34:33
     
242. 
     
243. sql statement: alter system set  control_files =   ''+DATA/clonedb/controlfile/current.261.981923651'', ''+FRA/clonedb/controlfile/current.349.981923651'' comment= ''Set by RMAN'' scope=spfile
     
244. 
     
245. Oracle instance shut down
     
246. 
     
247. connected to auxiliary database (not started)
     
248. Oracle instance started
     
249. 
     
250. Total System Global Area    1046224896 bytes
     
251. 
     
252. Fixed Size                     1341140 bytes
     
253. Variable Size                603982124 bytes
     
254. Database Buffers             436207616 bytes
     
255. Redo Buffers                   4694016 bytes
     
256. allocated channel: c9
     
257. channel c9: SID=49 device type=DISK
     
258. allocated channel: c10
     
259. channel c10: SID=136 device type=DISK
     
260. allocated channel: c11
     
261. channel c11: SID=6 device type=DISK
     
262. allocated channel: c12
     
263. channel c12: SID=50 device type=DISK
     
264. allocated channel: c13
     
265. channel c13: SID=137 device type=DISK
     
266. allocated channel: c14
     
267. channel c14: SID=93 device type=DISK
     
268. allocated channel: c15
     
269. channel c15: SID=7 device type=DISK
     
270. allocated channel: c16
     
271. channel c16: SID=51 device type=DISK
     
272. 
     
273. database mounted
     
274. RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.
     
275. datafile 4 not processed because file is OFFLINE IMMEDIATE
     
276. 
     
277. contents of Memory Script:
     
278. {
     
279.    set newname for datafile  1 to
     
280. "+data";
     
281.    set newname for datafile  2 to
     
282. "+data";
     
283.    set newname for datafile  3 to
     
284. "+data";
     
285.    set newname for datafile  5 to
     
286. "+data";
     
287.    set newname for datafile  6 to
     
288. "+data";
     
289.    set newname for datafile  7 to
     
290. "+data";
     
291.    backup as copy reuse
     
292.    datafile  1 auxiliary format
     
293. "+data"   datafile
     
294. 2 auxiliary format
     
295. "+data"   datafile
     
296. 3 auxiliary format
     
297. "+data"   datafile
     
298. 5 auxiliary format
     
299. "+data"   datafile
     
300. 6 auxiliary format
     
301. "+data"   datafile
     
302. 7 auxiliary format
     
303. "+data"   ;
     
304.    sql 'alter system archive log current';
     
305. }
     
306. executing Memory Script
     
307. 
     
308. executing command: SET NEWNAME
     
309. 
     
310. executing command: SET NEWNAME
     
311. 
     
312. executing command: SET NEWNAME
     
313. 
     
314. executing command: SET NEWNAME
     
315. 
     
316. executing command: SET NEWNAME
     
317. 
     
318. executing command: SET NEWNAME
     
319. 
     
320. Starting backup at 2018-07-19:20:35:00
     
321. channel c1: starting datafile copy
     
322. input datafile file number=00001 name=+DATA/orcl/datafile/system.268.979853699
     
323. channel c2: starting datafile copy
     
324. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.267.979847755
     
325. channel c3: starting datafile copy
     
326. input datafile file number=00005 name=+DATA/orcl/datafile/example.259.979847765
     
327. channel c4: starting datafile copy
     
328. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.979847755
     
329. channel c5: starting datafile copy
     
330. input datafile file number=00006 name=+DATA/orcl/datafile/tbs1.256.979847755
     
331. channel c6: starting datafile copy
     
332. input datafile file number=00007 name=+DATA/orcl/datafile/tbs2.257.979847755
     
333. output file name=+DATA/clonedb/datafile/system.262.981923705 tag=TAG20180719T203459
     
334. channel c1: datafile copy complete, elapsed time: 00:00:33
     
335. output file name=+DATA/clonedb/datafile/tbs1.257.981923731 tag=TAG20180719T203459
     
336. channel c5: datafile copy complete, elapsed time: 00:00:18
     
337. output file name=+DATA/clonedb/datafile/sysaux.259.981923707 tag=TAG20180719T203459
     
338. channel c2: datafile copy complete, elapsed time: 00:00:40
     
339. output file name=+DATA/clonedb/datafile/undotbs1.265.981923731 tag=TAG20180719T203459
     
340. channel c4: datafile copy complete, elapsed time: 00:00:42
     
341. output file name=+DATA/clonedb/datafile/tbs2.258.981923743 tag=TAG20180719T203459
     
342. channel c6: datafile copy complete, elapsed time: 00:00:16
     
343. output file name=+DATA/clonedb/datafile/example.256.981923747 tag=TAG20180719T203459
     
344. channel c3: datafile copy complete, elapsed time: 00:00:54
     
345. Finished backup at 2018-07-19:20:35:58
     
346. 
     
347. sql statement: alter system archive log current
     
348. 
     
349. contents of Memory Script:
     
350. {
     
351.    backup as copy reuse
     
352.    archivelog like  "+FRA/orcl/archivelog/2018_07_19/thread_1_seq_95.342.981923641" auxiliary format
     
353. "+FRA"   archivelog like
     
354. "/home/oracle/1_95_978645051.dbf" auxiliary format
     
355. "+FRA"   archivelog like
     
356. "+FRA/orcl/archivelog/2018_07_19/thread_1_seq_96.346.981923655" auxiliary format
     
357. "+FRA"   archivelog like
     
358. "/home/oracle/1_96_978645051.dbf" auxiliary format
     
359. "+FRA"   archivelog like
     
360. "+FRA/orcl/archivelog/2018_07_19/thread_1_seq_97.313.981923683" auxiliary format
     
361. "+FRA"   archivelog like
     
362. "/home/oracle/1_97_978645051.dbf" auxiliary format
     
363. "+FRA"   archivelog like
     
364. "+FRA/orcl/archivelog/2018_07_19/thread_1_seq_98.315.981923705" auxiliary format
     
365. "+FRA"   archivelog like
     
366. "/home/oracle/1_98_978645051.dbf" auxiliary format
     
367. "+FRA"   archivelog like
     
368. "+FRA/orcl/archivelog/2018_07_19/thread_1_seq_99.345.981923753" auxiliary format
     
369. "+FRA"   archivelog like
     
370. "/home/oracle/1_99_978645051.dbf" auxiliary format
     
371. "+FRA"   archivelog like
     
372. "+FRA/orcl/archivelog/2018_07_19/thread_1_seq_100.304.981923765" auxiliary format
     
373. "+FRA"   archivelog like
     
374. "/home/oracle/1_100_978645051.dbf" auxiliary format
     
375. "+FRA"   ;
     
376.    catalog clone recovery area;
     
377.    switch clone datafile all;
     
378. }
     
379. executing Memory Script
     
380. 
     
381. Starting backup at 2018-07-19:20:36:10
     
382. channel c1: starting archived log copy
     
383. input archived log thread=1 sequence=95 RECID=119 STAMP=981923647
     
384. channel c2: starting archived log copy
     
385. input archived log thread=1 sequence=95 RECID=120 STAMP=981923647
     
386. channel c3: starting archived log copy
     
387. input archived log thread=1 sequence=96 RECID=121 STAMP=981923659
     
388. channel c4: starting archived log copy
     
389. input archived log thread=1 sequence=96 RECID=122 STAMP=981923659
     
390. channel c5: starting archived log copy
     
391. input archived log thread=1 sequence=97 RECID=123 STAMP=981923691
     
392. channel c6: starting archived log copy
     
393. input archived log thread=1 sequence=97 RECID=124 STAMP=981923691
     
394. channel c7: starting archived log copy
     
395. input archived log thread=1 sequence=98 RECID=125 STAMP=981923721
     
396. channel c8: starting archived log copy
     
397. input archived log thread=1 sequence=98 RECID=126 STAMP=981923722
     
398. output file name=+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_95.350.981923771 RECID=0 STAMP=0
     
399. channel c1: archived log copy complete, elapsed time: 00:00:01
     
400. channel c1: starting archived log copy
     
401. input archived log thread=1 sequence=99 RECID=127 STAMP=981923764
     
402. output file name=+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_95.320.981923771 RECID=0 STAMP=0
     
403. channel c2: archived log copy complete, elapsed time: 00:00:01
     
404. channel c2: starting archived log copy
     
405. input archived log thread=1 sequence=99 RECID=128 STAMP=981923764
     
406. output file name=+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_96.294.981923771 RECID=0 STAMP=0
     
407. channel c3: archived log copy complete, elapsed time: 00:00:05
     
408. channel c3: starting archived log copy
     
409. input archived log thread=1 sequence=100 RECID=129 STAMP=981923769
     
410. output file name=+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_96.328.981923771 RECID=0 STAMP=0
     
411. channel c4: archived log copy complete, elapsed time: 00:00:07
     
412. channel c4: starting archived log copy
     
413. input archived log thread=1 sequence=100 RECID=130 STAMP=981923769
     
414. output file name=+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_99.355.981923773 RECID=0 STAMP=0
     
415. channel c1: archived log copy complete, elapsed time: 00:00:08
     
416. output file name=+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_99.330.981923773 RECID=0 STAMP=0
     
417. channel c2: archived log copy complete, elapsed time: 00:00:07
     
418. output file name=+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_100.338.981923779 RECID=0 STAMP=0
     
419. channel c3: archived log copy complete, elapsed time: 00:00:02
     
420. output file name=+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_97.336.981923771 RECID=0 STAMP=0
     
421. channel c5: archived log copy complete, elapsed time: 00:00:09
     
422. output file name=+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_97.259.981923773 RECID=0 STAMP=0
     
423. channel c6: archived log copy complete, elapsed time: 00:00:09
     
424. output file name=+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_98.257.981923773 RECID=0 STAMP=0
     
425. channel c7: archived log copy complete, elapsed time: 00:00:08
     
426. output file name=+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_98.286.981923773 RECID=0 STAMP=0
     
427. channel c8: archived log copy complete, elapsed time: 00:00:08
     
428. output file name=+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_100.343.981923781 RECID=0 STAMP=0
     
429. channel c4: archived log copy complete, elapsed time: 00:00:01
     
430. Finished backup at 2018-07-19:20:36:21
     
431. 
     
432. searching for all files in the recovery area
     
433. 
     
434. List of Files Unknown to the Database
     
435. =====================================
     
436. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_95.350.981923771
     
437. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_95.320.981923771
     
438. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_96.294.981923771
     
439. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_96.328.981923771
     
440. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_97.336.981923771
     
441. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_97.259.981923773
     
442. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_98.257.981923773
     
443. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_98.286.981923773
     
444. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_99.355.981923773
     
445. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_99.330.981923773
     
446. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_100.338.981923779
     
447. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_100.343.981923781
     
448. File Name: +fra/CLONEDB/CONTROLFILE/Current.358.981923651
     
449. cataloging files...
     
450. cataloging done
     
451. 
     
452. List of Cataloged Files
     
453. =======================
     
454. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_95.350.981923771
     
455. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_95.320.981923771
     
456. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_96.294.981923771
     
457. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_96.328.981923771
     
458. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_97.336.981923771
     
459. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_97.259.981923773
     
460. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_98.257.981923773
     
461. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_98.286.981923773
     
462. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_99.355.981923773
     
463. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_99.330.981923773
     
464. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_100.338.981923779
     
465. File Name: +fra/CLONEDB/ARCHIVELOG/2018_07_19/thread_1_seq_100.343.981923781
     
466. 
     
467. List of Files Which Where Not Cataloged
     
468. =======================================
     
469. File Name: +fra/CLONEDB/CONTROLFILE/Current.358.981923651
     
470.   RMAN-07517: Reason: The file header is corrupted
     
471. 
     
472. datafile 1 switched to datafile copy
     
473. input datafile copy RECID=38 STAMP=981923789 file name=+DATA/clonedb/datafile/system.262.981923705
     
474. datafile 2 switched to datafile copy
     
475. input datafile copy RECID=39 STAMP=981923789 file name=+DATA/clonedb/datafile/sysaux.259.981923707
     
476. datafile 3 switched to datafile copy
     
477. input datafile copy RECID=40 STAMP=981923789 file name=+DATA/clonedb/datafile/undotbs1.265.981923731
     
478. datafile 5 switched to datafile copy
     
479. input datafile copy RECID=41 STAMP=981923789 file name=+DATA/clonedb/datafile/example.256.981923747
     
480. datafile 6 switched to datafile copy
     
481. input datafile copy RECID=42 STAMP=981923789 file name=+DATA/clonedb/datafile/tbs1.257.981923731
     
482. datafile 7 switched to datafile copy
     
483. input datafile copy RECID=43 STAMP=981923789 file name=+DATA/clonedb/datafile/tbs2.258.981923743
     
484. 
     
485. contents of Memory Script:
     
486. {
     
487.    set until scn  1618281;
     
488.    recover
     
489.    clone database
     
490.    skip forever tablespace  "USERS"    delete archivelog
     
491.    ;
     
492. }
     
493. executing Memory Script
     
494. 
     
495. executing command: SET until clause
     
496. 
     
497. Starting recover at 2018-07-19:20:36:30
     
498. 
     
499. Executing: alter database datafile 4 offline drop
     
500. starting media recovery
     
501. 
     
502. archived log for thread 1 with sequence 97 is already on disk as file +FRA/clonedb/archivelog/2018_07_19/thread_1_seq_97.336.981923771
     
503. archived log for thread 1 with sequence 98 is already on disk as file +FRA/clonedb/archivelog/2018_07_19/thread_1_seq_98.257.981923773
     
504. archived log for thread 1 with sequence 99 is already on disk as file +FRA/clonedb/archivelog/2018_07_19/thread_1_seq_99.355.981923773
     
505. archived log for thread 1 with sequence 100 is already on disk as file +FRA/clonedb/archivelog/2018_07_19/thread_1_seq_100.338.981923779
     
506. archived log file name=+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_97.336.981923771 thread=1 sequence=97
     
507. archived log file name=+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_98.257.981923773 thread=1 sequence=98
     
508. archived log file name=+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_99.355.981923773 thread=1 sequence=99
     
509. ORA-00279: change 1617151 generated at 07/19/2018 20:35:00 needed for thread 1
     
510. ORA-00289: suggestion :
     
511. +FRA/clonedb/archivelog/2018_07_19/thread_1_seq_99.330.981923773
     
512. ORA-00280: change 1617151 for thread 1 is in sequence #99
     
513. 
     
514. 
     
515. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
     
516. 
     
517. ORA-00279: change 1617592 generated at 07/19/2018 20:35:49 needed for thread 1
     
518. ORA-00289: suggestion :
     
519. +FRA/clonedb/archivelog/2018_07_19/thread_1_seq_100.343.981923781
     
520. ORA-00280: change 1617592 for thread 1 is in sequence #100
     
521. ORA-00278: log file
     
522. '+FRA/clonedb/archivelog/2018_07_19/thread_1_seq_99.330.981923773' no longer
     
523. needed for this recovery
     
524. alter database open resetlogs;
     
525. released channel: c1
     
526. released channel: c2
     
527. released channel: c3
     
528. released channel: c4
     
529. released channel: c5
     
530. released channel: c6
     
531. released channel: c7
     
532. released channel: c8
     
533. released channel: c9
     
534. released channel: c10
     
535. released channel: c11
     
536. released channel: c12
     
537. released channel: c13
     
538. released channel: c14
     
539. released channel: c15
     
540. released channel: c16
     
541. 
     
542. RMAN>
     

复制代码

-------------------------------------------------------冷克隆：

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. }
    

复制代码

把station86上的/home/oracle/backup/完整scp -rp到station87的/home/oracle/backup/

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 mydb
    
11. backup location '/home/oracle/backup'
    
12. nofilenamecheck
    
13. spfile
    
14. set
    
15. control_files='/u01/app/oracle/oradata/mydb/control01.ctl','/u01/app/oracle/oradata/mydb/control02.ctl','/u01/app/oracle/oradata/mydb/control03.ctl'
    
16. set
    
17. db_file_name_convert='+DATA/orcl/datafile/example.258.880451611','/u01/app/oracle/oradata/mydb/example01.dbf','+DATA/orcl/datafile/users.259.880451615','/u01/app/oracle/oradata/mydb/users01.dbf','+DATA/orcl/datafile/undotbs1.256.880451607','/u01/app/oracle/oradata/mydb/undotbs01.dbf','+DATA/orcl/datafile/sysaux.257.880451605','/u01/app/oracle/oradata/mydb/sysaux01.dbf','+DATA/orcl/datafile/system.265.880451605','/u01/app/oracle/oradata/mydb/system01.dbf'
    
18. set
    
19. log_file_name_convert='+DATA/orcl/onlinelog/group_1.270.880453135','/u01/app/oracle/oradata/mydb/redo01a.log','+FRA/orcl/onlinelog/group_1.276.880453137','/u01/app/oracle/oradata/mydb/redo01b.log','+DATA/orcl/onlinelog/group_3.272.880453141','/u01/app/oracle/oradata/mydb/redo03a.log','+FRA/orcl/onlinelog/group_3.274.880453141','/u01/app/oracle/oradata/mydb/redo03b.log','+DATA/orcl/onlinelog/group_2.271.880453137','/u01/app/oracle/oradata/mydb/redo02a.log','+FRA/orcl/onlinelog/group_2.275.880453139','/u01/app/oracle/oradata/mydb/redo02b.log'
    
20. set
    
21. audit_file_dest='/u01/app/oracle/admin/mydb/adump'
    
22. set
    
23. db_create_file_dest=''
    
24. set
    
25. db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
    
26. }

复制代码

物理坏块和逻辑坏块，其中物理坏块的制造脚本：
physical-block11.2.0.1.sh (1.23 KB, 下载次数: 373)

2018-7-19 21:17 上传

点击文件名下载附件          physical-block.sh (1.25 KB, 下载次数: 341)

2018-7-19 21:18 上传

点击文件名下载附件


物理坏块现象：

1. SQL> conn hr/oracle_4U
   
2. Connected.
   
3. SQL> select  * from departments;
   
4. select        * from departments
   
5.                *
   
6. ERROR at line 1:
   
7. ORA-01578: ORACLE data block corrupted (file # 5, block # 175)
   
8. ORA-01110: data file 5: '+DATA/orcl/datafile/example.265.981927565'
   
9. 
   
10. 
    

复制代码