通过RMAN克隆11g数据库（基于active database）

11g的RMAN duplicate 可以通过Active databaseduplicate和Backup-based duplicate两种方法实现。这里的测试使用的是Active databaseduplicate，因为Active database duplicate 功能强大，不需要先把目标数据库进行rman备份，只要目标数据库处于归档模式下即可直接通过网络对数据库进行copy，且copy完成后自动open数据库。这对于大数据特别是T级别的数据库来说优点非常明显，复制前不需要进行备份，减少了备份和传送备份的时间，同时节省备份空间。下面来进行具体的duplicate操作。

 

 

 

 

监听，口令文件配置，pfile配置，创建clone库相关目录等过程同基于备份的RMAN复制一样

 

1 2 3 4 5 6 7 8

SQL>startup pfile=$ORACLE_HOME /dbs/initclonedb .ora nomount; ORACLEinstance started.    TotalSystem Global Area  630501376 bytes FixedSize                    2215984 bytes VariableSize                  184553424 bytes DatabaseBuffers          440401920 bytes RedoBuffers                    3330048 bytes

 

 

 

 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 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 58 59 60 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 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324

[oracle@HE4~]$ rman target sys /MANAGER @orcl auxiliarysys /MANAGER @clonedb    RecoveryManager: Release 11.2.0.1.0 - Production on Thu Jan 28 19:57:31 2016    Copyright(c) 1982, 2009, Oracle and /or  its affiliates. All rights reserved.    connectedto target database: ORCL (DBID=1426154421) connectedto auxiliary database: CLONEDB (not mounted) RMAN> duplicate target database to clonedb from active database;  (这里是异机异构恢复，如果是同结构的参数会报错，需添加nofilenamecheck,谨慎使用，防止文件被覆盖) Starting DuplicateDb at 28-JAN-16 using targetdatabase control  file  instead of recovery catalog allocated channel:ORA_AUX_DISK_1 channelORA_AUX_DISK_1: SID=20 device  type =DISK    contents of MemoryScript: {     sql clone  "create spfile frommemory" ; } executing MemoryScript    sql statement:create spfile from memory    contents of MemoryScript: {     shutdown  clone immediate;     startup clone nomount; } executing MemoryScript    Oracle instance  shutdown    connected toauxiliary database (not started) Oracle instancestarted    Total System GlobalArea     630501376 bytes    Fixed Size                     2215984 bytes Variable Size                188747728 bytes DatabaseBuffers             436207616 bytes Redo Buffers                   3330048 bytes    contents of MemoryScript: {     sql clone "alter system  set   db_name =   '' ORCL ''  comment=   '' Modified by RMAN duplicate '' scope=spfile";     sql clone "alter system  set   db_unique_name =   '' CLONEDB ''  comment=   '' Modified by RMAN duplicate '' scope=spfile";     shutdown  clone immediate;     startup clone force nomount     backup as copy current controlfile auxiliaryformat  '/u01/app/oracle/oradata/clonedb/control01.ctl' ;     restore clone controlfile to  '/u01/app/oracle/oradata/clonedb/control02.ctl'  from   '/u01/app/oracle/oradata/clonedb/control01.ctl' ;     alter clone database  mount ; } executing MemoryScript    sql statement: altersystem  set   db_name =   '' ORCL ''  comment=  '' Modified by RMANduplicate ''  scope=spfile    sql statement: altersystem  set   db_unique_name =   '' CLONEDB ''  comment=  '' Modified by RMANduplicate ''  scope=spfile    Oracle instance  shutdown    Oracle instancestarted    Total System GlobalArea     630501376 bytes    Fixed Size                     2215984 bytes Variable Size                188747728 bytes DatabaseBuffers             436207616 bytes Redo Buffers                   3330048 bytes    Starting backup at28-JAN-16 allocated channel:ORA_DISK_1 channel ORA_DISK_1:SID=36 device  type =DISK channel ORA_DISK_1:starting datafile copy copying currentcontrol  file output filename= /u01/app/oracle/product/11gr2/db_1/dbs/snapcf_orcl .ftag=TAG20160128T204953 RECID=5 STAMP=902350193 channel ORA_DISK_1:datafile copy complete, elapsed  time : 00:00:03 Finished backup at28-JAN-16    Starting restore at28-JAN-16 allocated channel:ORA_AUX_DISK_1 channelORA_AUX_DISK_1: SID=18 device  type =DISK    channelORA_AUX_DISK_1: copied control  file  copy Finished restore at28-JAN-16    database mounted    contents of MemoryScript: {     set  newname  for  datafile  1 to   "/u01/app/oracle/oradata/clonedb/system01.dbf" ;     set  newname  for  datafile  2 to   "/u01/app/oracle/oradata/clonedb/sysaux01.dbf" ;     set  newname  for  datafile  3 to   "/u01/app/oracle/oradata/clonedb/undotbs01.dbf" ;     set  newname  for  datafile  4 to   "/u01/app/oracle/oradata/clonedb/users01.dbf" ;     set  newname  for  datafile  5 to   "/u01/app/oracle/oradata/clonedb/example01.dbf" ;     set  newname  for  datafile  6 to   "/u01/app/oracle/oradata/clonedb/heleitbs01.dbf" ;     backup as copy reuse     datafile 1 auxiliary  format   "/u01/app/oracle/oradata/clonedb/system01.dbf"    datafile   2 auxiliary  format   "/u01/app/oracle/oradata/clonedb/sysaux01.dbf"    datafile   3 auxiliary  format   "/u01/app/oracle/oradata/clonedb/undotbs01.dbf"    datafile   4 auxiliary  format   "/u01/app/oracle/oradata/clonedb/users01.dbf"    datafile   5 auxiliary  format   "/u01/app/oracle/oradata/clonedb/example01.dbf"    datafile   6 auxiliary  format   "/u01/app/oracle/oradata/clonedb/heleitbs01.dbf"    ;     sql  'alter system archive log current' ; } executing MemoryScript    executing  command :SET NEWNAME    executing  command :SET NEWNAME    executing  command :SET NEWNAME    executing  command :SET NEWNAME    executing  command :SET NEWNAME    executing  command :SET NEWNAME    Starting backup at28-JAN-16 using channelORA_DISK_1 channel ORA_DISK_1:starting datafile copy input datafile filenumber=00001 name= /u01/app/oracle/oradata/orcl/system01 .dbf output filename= /u01/app/oracle/oradata/clonedb/system01 .dbf tag=TAG20160128T205002 channel ORA_DISK_1:datafile copy complete, elapsed  time : 00:00:59 channel ORA_DISK_1:starting datafile copy input datafile filenumber=00002 name= /u01/app/oracle/oradata/orcl/sysaux01 .dbf output filename= /u01/app/oracle/oradata/clonedb/sysaux01 .dbf tag=TAG20160128T205002 channel ORA_DISK_1:datafile copy complete, elapsed  time : 00:00:35 channel ORA_DISK_1:starting datafile copy input datafile filenumber=00006 name= /u01/app/oracle/oradata/orcl/heleitbs01 .dbf output filename= /u01/app/oracle/oradata/clonedb/heleitbs01 .dbf tag=TAG20160128T205002 channel ORA_DISK_1:datafile copy complete, elapsed  time : 00:00:16 channel ORA_DISK_1:starting datafile copy input datafile filenumber=00005 name= /u01/app/oracle/oradata/orcl/example01 .dbf output filename= /u01/app/oracle/oradata/clonedb/example01 .dbf tag=TAG20160128T205002 channel ORA_DISK_1:datafile copy complete, elapsed  time : 00:00:15 channel ORA_DISK_1:starting datafile copy input datafile filenumber=00003 name= /u01/app/oracle/oradata/orcl/undotbs01 .dbf output filename= /u01/app/oracle/oradata/clonedb/undotbs01 .dbf tag=TAG20160128T205002 channel ORA_DISK_1:datafile copy complete, elapsed  time : 00:00:08 channel ORA_DISK_1:starting datafile copy input datafile filenumber=00004 name= /u01/app/oracle/oradata/orcl/users01 .dbf output filename= /u01/app/oracle/oradata/clonedb/users01 .dbf tag=TAG20160128T205002 channel ORA_DISK_1:datafile copy complete, elapsed  time : 00:00:01 Finished backup at28-JAN-16    sql statement: altersystem archive log current    contents of MemoryScript: {     backup as copy reuse     archivelog like  "/u01/archivelog/1_13_898373685.dbf"  auxiliary  format   "/u01/archivelog/1_13_898373685.dbf"    ;     catalog clone archivelog  "/u01/archivelog/1_13_898373685.dbf" ;     switch clone datafile all; } executing MemoryScript    Starting backup at28-JAN-16 using channelORA_DISK_1 channel ORA_DISK_1:starting archived log copy input archived logthread=1 sequence=13 RECID=9 STAMP=902350337 output filename= /u01/archivelog/1_13_898373685 .dbf RECID=0 STAMP=0 channel ORA_DISK_1:archived log copy complete, elapsed  time : 00:00:01 Finished backup at28-JAN-16    cataloged archivedlog archived log filename= /u01/archivelog/1_13_898373685 .dbf RECID=9 STAMP=902350338    datafile 1 switchedto datafile copy input datafile copyRECID=5 STAMP=902350338  file  name= /u01/app/oracle/oradata/clonedb/system01 .dbf datafile 2 switchedto datafile copy input datafile copyRECID=6 STAMP=902350338  file  name= /u01/app/oracle/oradata/clonedb/sysaux01 .dbf datafile 3 switchedto datafile copy input datafile copyRECID=7 STAMP=902350338  file  name= /u01/app/oracle/oradata/clonedb/undotbs01 .dbf datafile 4 switchedto datafile copy input datafile copyRECID=8 STAMP=902350338  file  name= /u01/app/oracle/oradata/clonedb/users01 .dbf datafile 5 switchedto datafile copy input datafile copyRECID=9 STAMP=902350338  file  name= /u01/app/oracle/oradata/clonedb/example01 .dbf datafile 6 switchedto datafile copy input datafile copyRECID=10 STAMP=902350338 filename= /u01/app/oracle/oradata/clonedb/heleitbs01 .dbf    contents of MemoryScript: {     set  until  scn  1028975;     recover     clone database      delete archivelog     ; } executing MemoryScript    executing  command :SET  until  clause    Starting recover at28-JAN-16 using channelORA_AUX_DISK_1    starting mediarecovery    archived log forthread 1 with sequence 13 is already on disk as  file /u01/archivelog/1_13_898373685 .dbf archived log filename= /u01/archivelog/1_13_898373685 .dbf thread=1 sequence=13 media recoverycomplete, elapsed  time : 00:00:00 Finished recover at28-JAN-16    contents of MemoryScript: {     shutdown  clone immediate;     startup clone nomount;     sql clone "alter system  set   db_name =   '' CLONEDB ''  comment=   '' Reset to original value by RMAN '' scope=spfile";     sql clone  "alter system reset  db_unique_name scope=spfile" ;     shutdown  clone immediate;     startup clone nomount; } executing MemoryScript    database dismounted Oracle instance  shutdown    connected toauxiliary database (not started) Oracle instancestarted    Total System GlobalArea     630501376 bytes    Fixed Size                     2215984 bytes Variable Size                188747728 bytes DatabaseBuffers             436207616 bytes Redo Buffers                   3330048 bytes    sql statement: altersystem  set   db_name =   '' CLONEDB ''  comment=  '' Reset to originalvalue by RMAN ''  scope=spfile    sql statement: altersystem reset  db_unique_name scope=spfile    Oracle instance  shutdown    connected toauxiliary database (not started) Oracle instancestarted    Total System GlobalArea     630501376 bytes    Fixed Size                     2215984 bytes Variable Size                188747728 bytes DatabaseBuffers             436207616 bytes Redo Buffers                   3330048 bytes sql statement:CREATE CONTROLFILE REUSE SET DATABASE  "CLONEDB"  RESETLOGS ARCHIVELOG    MAXLOGFILES     16    MAXLOGMEMBERS      3    MAXDATAFILES      100    MAXINSTANCES     8    MAXLOGHISTORY      292   LOGFILE    GROUP 1 (  '/u01/app/oracle/oradata/clonedb/redo01.log'  ) SIZE 50 M  REUSE,    GROUP 2 (  '/u01/app/oracle/oradata/clonedb/redo02.log'  ) SIZE 50 M  REUSE,    GROUP 3 (  '/u01/app/oracle/oradata/clonedb/redo03.log'  ) SIZE 50 M  REUSE   DATAFILE   '/u01/app/oracle/oradata/clonedb/system01.dbf'   CHARACTER SET ZHS16GBK       contents of MemoryScript: {     set  newname  for  tempfile  1 to   "/u01/app/oracle/oradata/clonedb/temp01.dbf" ;     switch clone tempfile all;     catalog clone datafilecopy  "/u01/app/oracle/oradata/clonedb/sysaux01.dbf" ,   "/u01/app/oracle/oradata/clonedb/undotbs01.dbf" ,   "/u01/app/oracle/oradata/clonedb/users01.dbf" ,   "/u01/app/oracle/oradata/clonedb/example01.dbf" ,   "/u01/app/oracle/oradata/clonedb/heleitbs01.dbf" ;     switch clone datafile all; } executing MemoryScript    executing  command :SET NEWNAME    renamed tempfile 1to  /u01/app/oracle/oradata/clonedb/temp01 .dbf  in  control  file    cataloged datafilecopy datafile copy filename= /u01/app/oracle/oradata/clonedb/sysaux01 .dbf RECID=1 STAMP=902350346 cataloged datafilecopy datafile copy filename= /u01/app/oracle/oradata/clonedb/undotbs01 .dbf RECID=2 STAMP=902350346 cataloged datafilecopy datafile copy filename= /u01/app/oracle/oradata/clonedb/users01 .dbf RECID=3 STAMP=902350346 cataloged datafilecopy datafile copy filename= /u01/app/oracle/oradata/clonedb/example01 .dbf RECID=4 STAMP=902350346 cataloged datafilecopy datafile copy filename= /u01/app/oracle/oradata/clonedb/heleitbs01 .dbf RECID=5 STAMP=902350346    datafile 2 switchedto datafile copy input datafile copyRECID=1 STAMP=902350346  file  name= /u01/app/oracle/oradata/clonedb/sysaux01 .dbf datafile 3 switchedto datafile copy input datafile copyRECID=2 STAMP=902350346  file  name= /u01/app/oracle/oradata/clonedb/undotbs01 .dbf datafile 4 switchedto datafile copy input datafile copyRECID=3 STAMP=902350346  file  name= /u01/app/oracle/oradata/clonedb/users01 .dbf datafile 5 switchedto datafile copy input datafile copyRECID=4 STAMP=902350346  file  name= /u01/app/oracle/oradata/clonedb/example01 .dbf datafile 6 switchedto datafile copy input datafile copyRECID=5 STAMP=902350346 filename= /u01/app/oracle/oradata/clonedb/heleitbs01 .dbf    contents of MemoryScript: {     Alter clone database  open  resetlogs; } executing MemoryScript    database opened Finished DuplicateDb at 28-JAN-16

 本文转自 dbapower 51CTO博客，原文链接：http://blog.51cto.com/suifu/1739806，如需转载请自行联系原作者