克隆数据库

botang

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. allocate   channel a1 device type disk;
    
11. allocate   channel a2 device type disk;
    
12. allocate   channel a3 device type disk;
    
13. allocate   channel a4 device type disk;
    
14. allocate   channel a5 device type disk;
    
15. allocate   channel a6 device type disk;
    
16. allocate   channel a7 device type disk;
    
17. allocate   channel a8 device type disk;
    
18. 
    
19. duplicate target database to clone1
    
20. from active database
    
21. nofilenamecheck
    
22. skip tablespace tbstrans2
    
23. spfile
    
24. set
    
25. memory_target='700M'
    
26. set
    
27. control_files='+DATA','+FRA'
    
28. set
    
29. db_file_name_convert='+DATA/orcl','+DATA/clone1'
    
30. set
    
31. log_file_name_convert='+DATA/orcl','+DATA/clone1','+FRA/orcl','+FRA/clone1'
    
32. set
    
33. audit_file_dest='/u01/app/oracle/admin/clone1/adump';
    
34. }

复制代码

1. [oracle@station76 admin]$ pwd
   
2. /u01/app/oracle/product/11.2.0/dbhome_1/network/admin
   
3. [oracle@station76 admin]$ cd ..
   
4. [oracle@station76 network]$ ls
   
5. admin  doc  install  jlib  lib  log  mesg  tools  trace
   
6. [oracle@station76 network]$ cd ..
   
7. [oracle@station76 dbhome_1]$ ls
   
8. apex         crs        demo         install        jlib     nls         oraInst.loc  racg          sqlplus                     usm
   
9. assistants   csmig      diagnostics  instantclient  ldap     oc4j        ord          rdbms         srvm                        utl
   
10. bin          css        dv           inventory      lib      odbc        oui          relnotes      station76.example.com_orcl  wwg
    
11. ccr          ctx        emcli        j2ee           log      olap        owb          root.sh       suptools                    xdk
    
12. cdata        cv         EMStage      javavm         md       OPatch      owm          scheduler     sysman
    
13. cfgtoollogs  dbs        has          jdbc           mesg     OPatch.ori  perl         slax          timingframework
    
14. clone        dc_ocm     hs           jdev           mgw      opmn        plsql        sqldeveloper  ucp
    
15. config       deinstall  ide          jdk            network  oracore     precomp      sqlj          uix
    
16. [oracle@station76 dbhome_1]$ cd dbs
    
17. [oracle@station76 dbs]$ ls
    
18. hc_apple.dat   hc_mydb2.dat  hc_rcat.dat  initorcl.ora  lkMYDB2  lkRCAT     orapworcl  snapcf_orcl.f  spfilercat.ora
    
19. hc_dbtest.dat  hc_orcl.dat   init.ora     lkinstdbtest  lkORCL   lkWINORCL  orapwrcat  snapcf_rcat.f
    
20. [oracle@station76 dbs]$ vim initclone1.ora
    
21. db_name=clone1
    
22. db_domain=example.com
    
23. ~
    
24. ~
    
25. ~
    
26. ~
    
27. ~
    
28. ~
    
29. ~
    
30. ~
    
31. ~
    
32. ~
    
33. ~
    
34. ~
    
35. ~
    
36. ~
    
37. ~
    
38. ~
    
39. ~
    
40. ~
    
41. ~
    
42. ~
    
43. ~
    
44. ~
    
45. ~
    
46. ~
    
47. ~
    
48. ~
    
49. ~
    
50. ~
    
51. ~
    
52. ~
    
53. ~
    
54. ~
    
55. ~
    
56. ~
    
57. "initclone1.ora" [New] 2L, 37C written                                                                             
    
58. [oracle@station76 dbs]$ vim initclone2.ora
    
59. db_name=clone2
    
60. db_domain=example.com
    
61. ~
    
62. ~
    
63. ~
    
64. ~
    
65. ~
    
66. ~
    
67. ~
    
68. ~
    
69. ~
    
70. ~
    
71. ~
    
72. ~
    
73. ~
    
74. ~
    
75. ~
    
76. ~
    
77. ~
    
78. ~
    
79. ~
    
80. ~
    
81. ~
    
82. ~
    
83. ~
    
84. ~
    
85. ~
    
86. ~
    
87. ~
    
88. ~
    
89. ~
    
90. ~
    
91. ~
    
92. ~
    
93. ~
    
94. ~
    
95. "initclone2.ora" [New] 2L, 37C written                                                                             
    
96. [oracle@station76 dbs]$ orapwd file=orapwclone1  password=oracle_4U  
    
97. [oracle@station76 dbs]$ orapwd file=orapwclone2  password=oracle_4U  
    
98. [oracle@station76 dbs]$ cd /u01/app/
    
99. [oracle@station76 app]$ ls
    
100. oracle  oraInventory
     
101. [oracle@station76 app]$ cd oracle
     
102. [oracle@station76 oracle]$ ls
     
103. admin        cfgtoollogs  Clusterware  dirlin              flash_recovery_area  product    wallet
     
104. botangdir01  checkpoints  diag         fast_recovery_area  oradata              station76
     
105. [oracle@station76 oracle]$ cd admin/
     
106. [oracle@station76 admin]$ ls
     
107. +ASM  clone1  dbtest  mydb2  orcl  rcat
     
108. [oracle@station76 admin]$ cd clone1/
     
109. [oracle@station76 clone1]$ ls
     
110. adump
     
111. [oracle@station76 clone1]$ cd ..
     
112. [oracle@station76 admin]$ ls
     
113. +ASM  clone1  dbtest  mydb2  orcl  rcat
     
114. [oracle@station76 admin]$ mkdir -p  clone2/adump
     
115. [oracle@station76 admin]$ exit
     
116. logout
     
117. [root@station76 ~]# vim /etc/oratab
     
118. #Backup file is  /u01/app/oracle/product/11.2.0/grid/srvm/admin/oratab.bak.station76 line added by Agent
     
119. #
     
120. 
     
121. 
     
122. 
     
123. # This file is used by ORACLE utilities.  It is created by root.sh
     
124. # and updated by either Database Configuration Assistant while creating
     
125. # a database or ASM Configuration Assistant while creating ASM instance.
     
126. 
     
127. # A colon, ':', is used as the field terminator.  A new line terminates
     
128. # the entry.  Lines beginning with a pound sign, '#', are comments.
     
129. #
     
130. # Entries are of the form:
     
131. #   $ORACLE_SID:$ORACLE_HOME:<N|Y>:
     
132. #
     
133. # The first and second fields are the system identifier and home
     
134. # directory of the database respectively.  The third filed indicates
     
135. # to the dbstart utility that the database should , "Y", or should not,
     
136. # "N", be brought up at system boot time.
     
137. #
     
138. # Multiple entries with the same $ORACLE_SID are not allowed.
     
139. #
     
140. #
     
141. +ASM:/u01/app/oracle/product/11.2.0/grid:N
     
142. rcat:/u01/app/oracle/product/11.2.0/dbhome_1:N          # line added by Agent
     
143. orcl:/u01/app/oracle/product/11.2.0/dbhome_1:N          # line added by Agent
     
144. clone1:/u01/app/oracle/product/11.2.0/dbhome_1:N                # line added by Agent
     
145. clone2:/u01/app/oracle/product/11.2.0/dbhome_1:N                # line added by Agent
     
146. ~
     
147. ~
     
148. ~
     
149. ~
     
150. ~
     
151. ~
     
152. ~
     
153. ~
     
154. "/etc/oratab" 28L, 1173C written                                                                                   
     
155. [root@station76 ~]# su - oracle
     
156. [oracle@station76 ~]$ . oraenv
     
157. ORACLE_SID = [orcl] ? clone1
     
158. The Oracle base remains unchanged with value /u01/app/oracle
     
159. [oracle@station76 ~]$ sqlplus /nolog
     
160. 
     
161. SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 26 04:15:30 2019
     
162. 
     
163. Copyright (c) 1982, 2013, Oracle.  All rights reserved.
     
164. 
     
165. SQL> conn / as sysdba
     
166. Connected to an idle instance.
     
167. SQL> startup
     
168. ORACLE instance started.
     
169. 
     
170. Total System Global Area  263090176 bytes
     
171. Fixed Size                  2252256 bytes
     
172. Variable Size             205521440 bytes
     
173. Database Buffers           50331648 bytes
     
174. Redo Buffers                4984832 bytes
     
175. ORA-00205: error in identifying control file, check alert log for more info
     
176. 
     
177. 
     
178. SQL> exit
     
179. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
     
180. With the Partitioning, OLAP, Data Mining and Real Application Testing options
     
181. [oracle@station76 ~]$ rman target sys/oracle_4U@orcl  auxiliary sys/oracle_4U@clone1
     
182. 
     
183. Recovery Manager: Release 11.2.0.4.0 - Production on Thu Dec 26 04:16:20 2019
     
184. 
     
185. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
     
186. 
     
187. connected to target database: ORCL (DBID=1554722616)
     
188. connected to auxiliary database: CLONE1 (not mounted)
     
189. 
     
190. RMAN>

复制代码

用备份冷克隆：
先备份：

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

复制代码

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 clone2
    
11. backup location '/home/oracle/clone1'
    
12. nofilenamecheck
    
13. skip tablespace tbstrans2
    
14. db_file_name_convert '+DATA/orcl','+DATA/clone2'
    
15. logfile
    
16. group 1 ('+DATA','+FRA') size 50M,
    
17. group 2 ('+DATA','+FRA') size 50M,
    
18. group 3 ('+DATA','+FRA') size 50M
    
19. spfile
    
20. parameter_value_convert '+DATA/orcl','+DATA/clone2','+FRA/orcl','+FRA/clone2','/u01/app/oracle/admin/orcl/adump','/u01/app/oracle/admin/clone2/adump'
    
21. set
    
22. control_files='+DATA','+FRA'
    
23. set
    
24. memory_target='700M';
    
25. }

复制代码

1. [oracle@station76 ~]$ rman auxiliary sys/oracle_4U@clone2 cmdfile=/home/oracle/clone2.rcv
   
2. 
   
3. Recovery Manager: Release 11.2.0.4.0 - Production on Thu Dec 26 10:10:27 2019
   
4. 
   
5. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. connected to auxiliary database: CLONE2 (not mounted)
   
8. 
   
9. RMAN> run {
   
10. 2> allocate  auxiliary channel c1 device type disk;
    
11. 3> allocate  auxiliary channel c2 device type disk;
    
12. 4> allocate  auxiliary channel c3 device type disk;
    
13. 5> allocate  auxiliary channel c4 device type disk;
    
14. 6> allocate  auxiliary channel c5 device type disk;
    
15. 7> allocate  auxiliary channel c6 device type disk;
    
16. 8> allocate  auxiliary channel c7 device type disk;
    
17. 9> allocate  auxiliary channel c8 device type disk;
    
18. 10> duplicate database to clone2
    
19. 11> backup location '/home/oracle/clone1'
    
20. 12> nofilenamecheck  
    
21. 13> skip tablespace tbstrans2
    
22. 14> db_file_name_convert '+DATA/orcl','+DATA/clone2'
    
23. 15> logfile
    
24. 16> group 1 ('+DATA','+FRA') size 50M,
    
25. 17> group 2 ('+DATA','+FRA') size 50M,
    
26. 18> group 3 ('+DATA','+FRA') size 50M
    
27. 19> spfile
    
28. 20> parameter_value_convert '+DATA/orcl','+DATA/clone2','+FRA/orcl','+FRA/clone2','/u01/app/oracle/admin/orcl/adump','/u01/app/oracle/admin/clone2/adump'
    
29. 21> set
    
30. 22> control_files='+DATA','+FRA'
    
31. 23> set  
    
32. 24> memory_target='700M';
    
33. 25> }
    
34. 26>
    
35. allocated channel: c1
    
36. channel c1: SID=429 device type=DISK
    
37. 
    
38. allocated channel: c2
    
39. channel c2: SID=5 device type=DISK
    
40. 
    
41. allocated channel: c3
    
42. channel c3: SID=146 device type=DISK
    
43. 
    
44. allocated channel: c4
    
45. channel c4: SID=288 device type=DISK
    
46. 
    
47. allocated channel: c5
    
48. channel c5: SID=430 device type=DISK
    
49. 
    
50. allocated channel: c6
    
51. channel c6: SID=6 device type=DISK
    
52. 
    
53. allocated channel: c7
    
54. channel c7: SID=147 device type=DISK
    
55. 
    
56. allocated channel: c8
    
57. channel c8: SID=289 device type=DISK
    
58. 
    
59. Starting Duplicate Db at 2019-12-26:10:10:50
    
60. 
    
61. contents of Memory Script:
    
62. {
    
63.    restore clone spfile to  '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileclone2.ora' from
    
64. '/home/oracle/clone1/4iukc5nj_1_1';
    
65.    sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileclone2.ora''";
    
66. }
    
67. executing Memory Script
    
68. 
    
69. Starting restore at 2019-12-26:10:10:51
    
70. 
    
71. channel c2: skipped, AUTOBACKUP already found
    
72. channel c3: skipped, AUTOBACKUP already found
    
73. channel c4: skipped, AUTOBACKUP already found
    
74. channel c5: skipped, AUTOBACKUP already found
    
75. channel c6: skipped, AUTOBACKUP already found
    
76. channel c7: skipped, AUTOBACKUP already found
    
77. channel c8: skipped, AUTOBACKUP already found
    
78. channel c1: restoring spfile from AUTOBACKUP /home/oracle/clone1/4iukc5nj_1_1
    
79. channel c1: SPFILE restore from AUTOBACKUP complete
    
80. Finished restore at 2019-12-26:10:11:03
    
81. 
    
82. sql statement: alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileclone2.ora''
    
83. 
    
84. contents of Memory Script:
    
85. {
    
86.    sql clone "alter system set  db_name =
    
87. ''CLONE2'' comment=
    
88. ''duplicate'' scope=spfile";
    
89.    sql clone "alter system set  control_files =
    
90. ''+DATA'', ''+FRA'' comment=
    
91. '''' scope=spfile";
    
92.    sql clone "alter system set  memory_target =
    
93. 700M comment=
    
94. '''' scope=spfile";
    
95.    shutdown clone immediate;
    
96.    startup clone nomount;
    
97. }
    
98. executing Memory Script
    
99. 
    
100. sql statement: alter system set  db_name =  ''CLONE2'' comment= ''duplicate'' scope=spfile
     
101. 
     
102. sql statement: alter system set  control_files =  ''+DATA'', ''+FRA'' comment= '''' scope=spfile
     
103. 
     
104. sql statement: alter system set  memory_target =  700M comment= '''' scope=spfile
     
105. 
     
106. Oracle instance shut down
     
107. 
     
108. connected to auxiliary database (not started)
     
109. Oracle instance started
     
110. 
     
111. Total System Global Area     730714112 bytes
     
112. 
     
113. Fixed Size                     2256832 bytes
     
114. Variable Size                486539328 bytes
     
115. Database Buffers             234881024 bytes
     
116. Redo Buffers                   7036928 bytes
     
117. allocated channel: c1
     
118. channel c1: SID=68 device type=DISK
     
119. allocated channel: c2
     
120. channel c2: SID=131 device type=DISK
     
121. allocated channel: c3
     
122. channel c3: SID=192 device type=DISK
     
123. allocated channel: c4
     
124. channel c4: SID=8 device type=DISK
     
125. allocated channel: c5
     
126. channel c5: SID=69 device type=DISK
     
127. allocated channel: c6
     
128. channel c6: SID=132 device type=DISK
     
129. allocated channel: c7
     
130. channel c7: SID=193 device type=DISK
     
131. allocated channel: c8
     
132. channel c8: SID=9 device type=DISK
     
133. 
     
134. contents of Memory Script:
     
135. {
     
136.    sql clone "alter system set  control_files =
     
137.   ''+DATA/clone2/controlfile/current.276.1028023901'', ''+FRA/clone2/controlfile/current.479.1028023903'' comment=
     
138. ''Set by RMAN'' scope=spfile";
     
139.    sql clone "alter system set  db_name =
     
140. ''ORCL'' comment=
     
141. ''Modified by RMAN duplicate'' scope=spfile";
     
142.    sql clone "alter system set  db_unique_name =
     
143. ''CLONE2'' comment=
     
144. ''Modified by RMAN duplicate'' scope=spfile";
     
145.    shutdown clone immediate;
     
146.    startup clone force nomount
     
147.    restore clone primary controlfile from  '/home/oracle/clone1/4jukc5nk_1_1';
     
148.    alter clone database mount;
     
149. }
     
150. executing Memory Script
     
151. 
     
152. sql statement: alter system set  control_files =   ''+DATA/clone2/controlfile/current.276.1028023901'', ''+FRA/clone2/controlfile/current.479.1028023903'' comment= ''Set by RMAN'' scope=spfile
     
153. 
     
154. sql statement: alter system set  db_name =  ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile
     
155. 
     
156. sql statement: alter system set  db_unique_name =  ''CLONE2'' comment= ''Modified by RMAN duplicate'' scope=spfile
     
157. 
     
158. Oracle instance shut down
     
159. 
     
160. Oracle instance started
     
161. 
     
162. Total System Global Area     730714112 bytes
     
163. 
     
164. Fixed Size                     2256832 bytes
     
165. Variable Size                486539328 bytes
     
166. Database Buffers             234881024 bytes
     
167. Redo Buffers                   7036928 bytes
     
168. allocated channel: c1
     
169. channel c1: SID=68 device type=DISK
     
170. allocated channel: c2
     
171. channel c2: SID=131 device type=DISK
     
172. allocated channel: c3
     
173. channel c3: SID=192 device type=DISK
     
174. allocated channel: c4
     
175. channel c4: SID=8 device type=DISK
     
176. allocated channel: c5
     
177. channel c5: SID=69 device type=DISK
     
178. allocated channel: c6
     
179. channel c6: SID=132 device type=DISK
     
180. allocated channel: c7
     
181. channel c7: SID=193 device type=DISK
     
182. allocated channel: c8
     
183. channel c8: SID=9 device type=DISK
     
184. 
     
185. Starting restore at 2019-12-26:10:12:27
     
186. 
     
187. channel c2: skipped, AUTOBACKUP already found
     
188. channel c3: skipped, AUTOBACKUP already found
     
189. channel c4: skipped, AUTOBACKUP already found
     
190. channel c5: skipped, AUTOBACKUP already found
     
191. channel c6: skipped, AUTOBACKUP already found
     
192. channel c7: skipped, AUTOBACKUP already found
     
193. channel c8: skipped, AUTOBACKUP already found
     
194. channel c1: restoring control file
     
195. channel c1: restore complete, elapsed time: 00:00:11
     
196. output file name=+DATA/clone2/controlfile/current.276.1028023901
     
197. output file name=+FRA/clone2/controlfile/current.479.1028023903
     
198. Finished restore at 2019-12-26:10:12:45
     
199. 
     
200. database mounted
     
201. Not connected to TARGET or TARGET not open, cannot verify that subset of tablespaces is self-contained
     
202. Not connected to TARGET, cannot verify that set of tablespaces being duplicated does not have SYS objects
     
203. Datafile 6 skipped by request
     
204. RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.
     
205. 
     
206. contents of Memory Script:
     
207. {
     
208.    set until scn  1623324;
     
209.    set newname for datafile  1 to
     
210. "+data";
     
211.    set newname for datafile  2 to
     
212. "+data";
     
213.    set newname for datafile  3 to
     
214. "+data";
     
215.    set newname for datafile  4 to
     
216. "+data";
     
217.    set newname for datafile  5 to
     
218. "+data";
     
219.    restore
     
220.    clone database
     
221.    skip forever tablespace  "TBSTRANS2"   ;
     
222. }
     
223. executing Memory Script
     
224. 
     
225. executing command: SET until clause
     
226. 
     
227. executing command: SET NEWNAME
     
228. 
     
229. executing command: SET NEWNAME
     
230. 
     
231. executing command: SET NEWNAME
     
232. 
     
233. executing command: SET NEWNAME
     
234. 
     
235. executing command: SET NEWNAME
     
236. 
     
237. Starting restore at 2019-12-26:10:12:57
     
238. 
     
239. channel c1: starting datafile backup set restore
     
240. channel c1: specifying datafile(s) to restore from backup set
     
241. channel c1: restoring datafile 00005 to +data
     
242. channel c1: reading from backup piece /home/oracle/clone1/4cukc5mt_1_1
     
243. channel c2: starting datafile backup set restore
     
244. channel c2: specifying datafile(s) to restore from backup set
     
245. channel c2: restoring datafile 00001 to +data
     
246. channel c2: reading from backup piece /home/oracle/clone1/49ukc5ms_1_1
     
247. channel c3: starting datafile backup set restore
     
248. channel c3: specifying datafile(s) to restore from backup set
     
249. channel c3: restoring datafile 00002 to +data
     
250. channel c3: reading from backup piece /home/oracle/clone1/4aukc5ms_1_1
     
251. channel c4: starting datafile backup set restore
     
252. channel c4: specifying datafile(s) to restore from backup set
     
253. channel c4: restoring datafile 00003 to +data
     
254. channel c4: reading from backup piece /home/oracle/clone1/4bukc5ms_1_1
     
255. channel c5: starting datafile backup set restore
     
256. channel c5: specifying datafile(s) to restore from backup set
     
257. channel c5: restoring datafile 00004 to +data
     
258. channel c5: reading from backup piece /home/oracle/clone1/4fukc5mu_1_1
     
259. channel c1: piece handle=/home/oracle/clone1/4cukc5mt_1_1 tag=TAG20191226T043226
     
260. channel c1: restored backup piece 1
     
261. channel c1: restore complete, elapsed time: 00:00:02
     
262. channel c5: piece handle=/home/oracle/clone1/4fukc5mu_1_1 tag=TAG20191226T043226
     
263. channel c5: restored backup piece 1
     
264. channel c5: restore complete, elapsed time: 00:00:01
     
265. channel c4: piece handle=/home/oracle/clone1/4bukc5ms_1_1 tag=TAG20191226T043226
     
266. channel c4: restored backup piece 1
     
267. channel c4: restore complete, elapsed time: 00:00:04
     
268. channel c2: piece handle=/home/oracle/clone1/49ukc5ms_1_1 tag=TAG20191226T043226
     
269. channel c2: restored backup piece 1
     
270. channel c2: restore complete, elapsed time: 00:00:17
     
271. channel c3: piece handle=/home/oracle/clone1/4aukc5ms_1_1 tag=TAG20191226T043226
     
272. channel c3: restored backup piece 1
     
273. channel c3: restore complete, elapsed time: 00:00:17
     
274. Finished restore at 2019-12-26:10:13:18
     
275. 
     
276. contents of Memory Script:
     
277. {
     
278.    switch clone datafile all;
     
279. }
     
280. executing Memory Script
     
281. 
     
282. datafile 1 switched to datafile copy
     
283. input datafile copy RECID=6 STAMP=1028023998 file name=+DATA/clone2/datafile/system.278.1028023981
     
284. datafile 2 switched to datafile copy
     
285. input datafile copy RECID=7 STAMP=1028023998 file name=+DATA/clone2/datafile/sysaux.256.1028023983
     
286. datafile 3 switched to datafile copy
     
287. input datafile copy RECID=8 STAMP=1028023999 file name=+DATA/clone2/datafile/undotbs1.272.1028023983
     
288. datafile 4 switched to datafile copy
     
289. input datafile copy RECID=9 STAMP=1028023999 file name=+DATA/clone2/datafile/users.284.1028023983
     
290. datafile 5 switched to datafile copy
     
291. input datafile copy RECID=10 STAMP=1028023999 file name=+DATA/clone2/datafile/tbstrans1.275.1028023981
     
292. 
     
293. contents of Memory Script:
     
294. {
     
295.    set until scn  1623324;
     
296.    recover
     
297.    clone database
     
298.    skip forever tablespace  "TBSTRANS2"    delete archivelog
     
299.    ;
     
300. }
     
301. executing Memory Script
     
302. 
     
303. executing command: SET until clause
     
304. 
     
305. Starting recover at 2019-12-26:10:13:21
     
306. 
     
307. Executing: alter database datafile 6 offline drop
     
308. starting media recovery
     
309. 
     
310. channel c1: starting archived log restore to default destination
     
311. channel c1: restoring archived log
     
312. archived log thread=1 sequence=30
     
313. channel c1: reading from backup piece /home/oracle/clone1/4hukc5nh_1_1
     
314. channel c1: piece handle=/home/oracle/clone1/4hukc5nh_1_1 tag=TAG20191226T043248
     
315. channel c1: restored backup piece 1
     
316. channel c1: restore complete, elapsed time: 00:00:01
     
317. archived log file name=+FRA/clone2/archivelog/2019_12_26/thread_1_seq_30.478.1028024009 thread=1 sequence=30
     
318. channel clone_default: deleting archived log(s)
     
319. archived log file name=+FRA/clone2/archivelog/2019_12_26/thread_1_seq_30.478.1028024009 RECID=1 STAMP=1028024009
     
320. media recovery complete, elapsed time: 00:00:02
     
321. Finished recover at 2019-12-26:10:13:32
     
322. Oracle instance started
     
323. 
     
324. Total System Global Area     730714112 bytes
     
325. 
     
326. Fixed Size                     2256832 bytes
     
327. Variable Size                486539328 bytes
     
328. Database Buffers             234881024 bytes
     
329. Redo Buffers                   7036928 bytes
     
330. 
     
331. contents of Memory Script:
     
332. {
     
333.    sql clone "alter system set  db_name =
     
334. ''CLONE2'' comment=
     
335. ''Reset to original value by RMAN'' scope=spfile";
     
336.    sql clone "alter system reset  db_unique_name scope=spfile";
     
337.    shutdown clone immediate;
     
338.    startup clone nomount;
     
339. }
     
340. executing Memory Script
     
341. 
     
342. sql statement: alter system set  db_name =  ''CLONE2'' comment= ''Reset to original value by RMAN'' scope=spfile
     
343. 
     
344. sql statement: alter system reset  db_unique_name scope=spfile
     
345. 
     
346. Oracle instance shut down
     
347. 
     
348. connected to auxiliary database (not started)
     
349. Oracle instance started
     
350. 
     
351. Total System Global Area     730714112 bytes
     
352. 
     
353. Fixed Size                     2256832 bytes
     
354. Variable Size                486539328 bytes
     
355. Database Buffers             234881024 bytes
     
356. Redo Buffers                   7036928 bytes
     
357. allocated channel: c1
     
358. channel c1: SID=70 device type=DISK
     
359. allocated channel: c2
     
360. channel c2: SID=131 device type=DISK
     
361. allocated channel: c3
     
362. channel c3: SID=192 device type=DISK
     
363. allocated channel: c4
     
364. channel c4: SID=6 device type=DISK
     
365. allocated channel: c5
     
366. channel c5: SID=71 device type=DISK
     
367. allocated channel: c6
     
368. channel c6: SID=132 device type=DISK
     
369. allocated channel: c7
     
370. channel c7: SID=193 device type=DISK
     
371. allocated channel: c8
     
372. channel c8: SID=7 device type=DISK
     
373. sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CLONE2" RESETLOGS ARCHIVELOG
     
374.   MAXLOGFILES     16
     
375.   MAXLOGMEMBERS      3
     
376.   MAXDATAFILES      100
     
377.   MAXINSTANCES     8
     
378.   MAXLOGHISTORY      292
     
379. LOGFILE
     
380.   GROUP   1 ( '+DATA', '+FRA' ) SIZE 50 M ,
     
381.   GROUP   2 ( '+DATA', '+FRA' ) SIZE 50 M ,
     
382.   GROUP   3 ( '+DATA', '+FRA' ) SIZE 50 M
     
383. DATAFILE
     
384.   '+DATA/clone2/datafile/system.278.1028023981'
     
385. CHARACTER SET AL32UTF8
     
386. 
     
387. 
     
388. contents of Memory Script:
     
389. {
     
390.    set newname for tempfile  1 to
     
391. "+data";
     
392.    switch clone tempfile all;
     
393.    catalog clone datafilecopy  "+DATA/clone2/datafile/sysaux.256.1028023983",
     
394. "+DATA/clone2/datafile/undotbs1.272.1028023983",
     
395. "+DATA/clone2/datafile/users.284.1028023983",
     
396. "+DATA/clone2/datafile/tbstrans1.275.1028023981";
     
397.    switch clone datafile all;
     
398. }
     
399. executing Memory Script
     
400. 
     
401. executing command: SET NEWNAME
     
402. 
     
403. renamed tempfile 1 to +data in control file
     
404. 
     
405. cataloged datafile copy
     
406. datafile copy file name=+DATA/clone2/datafile/sysaux.256.1028023983 RECID=1 STAMP=1028024100
     
407. cataloged datafile copy
     
408. datafile copy file name=+DATA/clone2/datafile/undotbs1.272.1028023983 RECID=2 STAMP=1028024100
     
409. cataloged datafile copy
     
410. datafile copy file name=+DATA/clone2/datafile/users.284.1028023983 RECID=3 STAMP=1028024101
     
411. cataloged datafile copy
     
412. datafile copy file name=+DATA/clone2/datafile/tbstrans1.275.1028023981 RECID=4 STAMP=1028024101
     
413. 
     
414. datafile 2 switched to datafile copy
     
415. input datafile copy RECID=1 STAMP=1028024100 file name=+DATA/clone2/datafile/sysaux.256.1028023983
     
416. datafile 3 switched to datafile copy
     
417. input datafile copy RECID=2 STAMP=1028024100 file name=+DATA/clone2/datafile/undotbs1.272.1028023983
     
418. datafile 4 switched to datafile copy
     
419. input datafile copy RECID=3 STAMP=1028024101 file name=+DATA/clone2/datafile/users.284.1028023983
     
420. datafile 5 switched to datafile copy
     
421. input datafile copy RECID=4 STAMP=1028024101 file name=+DATA/clone2/datafile/tbstrans1.275.1028023981
     
422. 
     
423. contents of Memory Script:
     
424. {
     
425.    Alter clone database open resetlogs;
     
426. }
     
427. executing Memory Script
     
428. 
     
429. database opened
     
430. Dropping offline and skipped tablespaces
     
431. Executing: drop tablespace "TBSTRANS2" including contents cascade constraints
     
432. Finished Duplicate Db at 2019-12-26:10:16:18
     
433. released channel: c1
     
434. released channel: c2
     
435. released channel: c3
     
436. released channel: c4
     
437. released channel: c5
     
438. released channel: c6
     
439. released channel: c7
     
440. released channel: c8
     
441. 
     
442. Recovery Manager complete.
     
443. [oracle@station76 ~]$

复制代码