API tools faq
paste
ExaGridDba

12c duplicate active using compressed backupset

ExaGridDba
Sep 11th, 2013
255
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.04 KB | None | 0 0
raw download clone embed print report
  1. script:
  2.  
  3. run
  4. {
  5. allocate channel c00 device type disk;
  6. allocate auxiliary channel a00 device type disk;
  7. allocate channel c01 device type disk;
  8. allocate auxiliary channel a01 device type disk;
  9. allocate channel c02 device type disk;
  10. allocate auxiliary channel a02 device type disk;
  11. allocate channel c03 device type disk;
  12. allocate auxiliary channel a03 device type disk;
  13. duplicate target database to PUUOO
  14. using compressed backupset
  15. from active database
  16. spfile
  17. parameter_value_convert 'POLOLU', 'PUUOO';
  18. }
  19.  
  20. quit
  21.  
  22.  
  23. some output:
  24.  
  25. restore
  26. from service 'POLOLU' using compressed backupset
  27. clone database
  28. ;
  29. sql 'alter system archive log current';
  30. }
  31. executing Memory Script
  32.  
  33. executing command: SET NEWNAME
  34.  
  35. executing command: SET NEWNAME
  36.  
  37. executing command: SET NEWNAME
  38.  
  39. executing command: SET NEWNAME
  40.  
  41. Starting restore at 2013-09-12 00:47:36
  42.  
  43. channel a00: starting datafile backup set restore
  44. channel a00: using compressed network backup set from service POLOLU
  45. channel a00: specifying datafile(s) to restore from backup set
  46. channel a00: restoring datafile 00001 to +DATA
  47. channel a01: starting datafile backup set restore
  48. channel a01: using compressed network backup set from service POLOLU
  49. channel a01: specifying datafile(s) to restore from backup set
  50. channel a01: restoring datafile 00003 to +DATA
  51. channel a02: starting datafile backup set restore
  52. channel a02: using compressed network backup set from service POLOLU
  53. channel a02: specifying datafile(s) to restore from backup set
  54. channel a02: restoring datafile 00004 to +DATA
  55. channel a03: starting datafile backup set restore
  56. channel a03: using compressed network backup set from service POLOLU
  57. channel a03: specifying datafile(s) to restore from backup set
  58. channel a03: restoring datafile 00006 to +DATA
  59. channel a02: restore complete, elapsed time: 00:01:15
  60. channel a03: restore complete, elapsed time: 00:01:45
  61. channel a00: restore complete, elapsed time: 00:02:15
  62. channel a01: restore complete, elapsed time: 00:02:15
  63. Finished restore at 2013-09-12 00:49:52
  64.  
  65. sql statement: alter system archive log current
  66. current log archived
  67.  
  68. contents of Memory Script:
  69. {
  70. restore clone force from service 'POLOLU' using compressed backupset
  71. archivelog from scn 1856714;
  72. switch clone datafile all;
  73. }
  74. executing Memory Script
  75.  
  76. Starting restore at 2013-09-12 00:49:55
  77.  
  78. channel a00: starting archived log restore to default destination
  79. channel a00: using compressed network backup set from service POLOLU
  80. channel a00: restoring archived log
  81. archived log thread=1 sequence=19
  82. channel a01: starting archived log restore to default destination
  83. channel a01: using compressed network backup set from service POLOLU
  84. channel a01: restoring archived log
  85. archived log thread=1 sequence=20
  86. channel a00: restore complete, elapsed time: 00:00:03
  87. channel a01: restore complete, elapsed time: 00:00:03
  88. Finished restore at 2013-09-12 00:49:59
  89.  
  90. datafile 1 switched to datafile copy
  91. input datafile copy RECID=5 STAMP=825900600 file name=+DATA/PUUOO/DATAFILE/system.440.825900463
  92. datafile 3 switched to datafile copy
  93. input datafile copy RECID=6 STAMP=825900600 file name=+DATA/PUUOO/DATAFILE/sysaux.412.825900465
  94. datafile 4 switched to datafile copy
  95. input datafile copy RECID=7 STAMP=825900601 file name=+DATA/PUUOO/DATAFILE/undotbs1.456.825900465
  96. datafile 6 switched to datafile copy
  97. input datafile copy RECID=8 STAMP=825900602 file name=+DATA/PUUOO/DATAFILE/users.457.825900485
  98.  
  99. contents of Memory Script:
  100. {
  101. set until scn 1856875;
  102. recover
  103. clone database
  104. delete archivelog
  105. ;
  106. }
  107. executing Memory Script
  108.  
  109. executing command: SET until clause
  110.  
  111. Starting recover at 2013-09-12 00:50:03
  112.  
  113. starting media recovery
  114.  
  115. archived log for thread 1 with sequence 19 is already on disk as file +DATA/PUUOO/ARCHIVELOG/2013_09_12/thread_1_seq_19.448.825900597
  116. archived log for thread 1 with sequence 20 is already on disk as file +DATA/PUUOO/ARCHIVELOG/2013_09_12/thread_1_seq_20.455.825900597
  117. archived log file name=+DATA/PUUOO/ARCHIVELOG/2013_09_12/thread_1_seq_19.448.825900597 thread=1 sequence=19
  118. archived log file name=+DATA/PUUOO/ARCHIVELOG/2013_09_12/thread_1_seq_20.455.825900597 thread=1 sequence=20
  119. media recovery complete, elapsed time: 00:00:05
  120. Finished recover at 2013-09-12 00:50:11
  121. Oracle instance started
  122.  
  123. Total System Global Area 2505338880 bytes
  124.  
  125. Fixed Size 2684688 bytes
  126. Variable Size 721422576 bytes
  127. Database Buffers 1761607680 bytes
  128. Redo Buffers 19623936 bytes
  129.  
  130. contents of Memory Script:
  131. {
  132. sql clone "alter system set db_name =
  133. ''PUUOO'' comment=
  134. ''Reset to original value by RMAN'' scope=spfile";
  135. sql clone "alter system reset db_unique_name scope=spfile";
  136. }
  137. executing Memory Script
  138.  
  139. sql statement: alter system set db_name = ''PUUOO'' comment= ''Reset to original value by RMAN'' scope=spfile
  140.  
  141. sql statement: alter system reset db_unique_name scope=spfile
  142. Oracle instance started
  143.  
  144. Total System Global Area 2505338880 bytes
  145.  
  146. Fixed Size 2684688 bytes
  147. Variable Size 721422576 bytes
  148. Database Buffers 1761607680 bytes
  149. Redo Buffers 19623936 bytes
  150. sql statement: CREATE CONTROLFILE REUSE SET DATABASE "PUUOO" RESETLOGS ARCHIVELOG
  151. MAXLOGFILES 16
  152. MAXLOGMEMBERS 3
  153. MAXDATAFILES 100
  154. MAXINSTANCES 8
  155. MAXLOGHISTORY 292
  156. LOGFILE
  157. GROUP 1 SIZE 50 M ,
  158. GROUP 2 SIZE 50 M ,
  159. GROUP 3 SIZE 50 M
  160. DATAFILE
  161. '+DATA/PUUOO/DATAFILE/system.440.825900463'
  162. CHARACTER SET AL32UTF8
  163.  
  164.  
  165. contents of Memory Script:
  166. {
  167. set newname for clone tempfile 1 to new;
  168. switch clone tempfile all;
  169. catalog clone datafilecopy "+DATA/PUUOO/DATAFILE/sysaux.412.825900465",
  170. "+DATA/PUUOO/DATAFILE/undotbs1.456.825900465",
  171. "+DATA/PUUOO/DATAFILE/users.457.825900485";
  172. switch clone datafile all;
  173. }
  174. executing Memory Script
  175.  
  176. executing command: SET NEWNAME
  177.  
  178. renamed tempfile 1 to +DATA in control file
  179.  
  180. cataloged datafile copy
  181. datafile copy file name=+DATA/PUUOO/DATAFILE/sysaux.412.825900465 RECID=1 STAMP=825900655
  182. cataloged datafile copy
  183. datafile copy file name=+DATA/PUUOO/DATAFILE/undotbs1.456.825900465 RECID=2 STAMP=825900655
  184. cataloged datafile copy
  185. datafile copy file name=+DATA/PUUOO/DATAFILE/users.457.825900485 RECID=3 STAMP=825900656
  186.  
  187. datafile 3 switched to datafile copy
  188. input datafile copy RECID=1 STAMP=825900655 file name=+DATA/PUUOO/DATAFILE/sysaux.412.825900465
  189. datafile 4 switched to datafile copy
  190. input datafile copy RECID=2 STAMP=825900655 file name=+DATA/PUUOO/DATAFILE/undotbs1.456.825900465
  191. datafile 6 switched to datafile copy
  192. input datafile copy RECID=3 STAMP=825900656 file name=+DATA/PUUOO/DATAFILE/users.457.825900485
  193.  
  194. contents of Memory Script:
  195. {
  196. Alter clone database open resetlogs;
  197. }
  198. executing Memory Script
  199.  
  200. database opened
  201. Finished Duplicate Db at 2013-09-12 00:52:02
  202. released channel: c00
  203. released channel: c01
  204. released channel: c02
  205. released channel: c03
  206.  
  207. Recovery Manager complete.
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!