11g RMAN新特性 active database duplication 复制数据库

第二.利用active database duplication 复制一个数据库
~\ nP%y8u*x#aJ6X0前面1到5步 和创建standby 数据库一样

其中第5步设置dataguard相关初始化参数可以去掉ITPUB个人空间Knux|&i#q5?

9g'~;]'U6o+m7f J06.登录主库 开始复制ITPUB个人空间3gN9h5P9B1H
C:\Documents and Settings\Administrator>set oracle_sid=primaryITPUB个人空间J"R#Jq7}Pg
C:\Documents and Settings\Administrator>rman target / auxiliarysys/abcdefg@standby
Z,h\ L$q/C,P pni!\0Recovery Manager: Release 11.1.0.6.0 - Production on Thu Jul 31 14:10:57 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: PRIMARY (DBID=1498839992)
e7mL/Exn{0connected to auxiliary database: PRIMARY (not mounted)

RMAN> RMAN> duplicate target database to 'standby'ITPUB个人空间*x-BCsP9? ^Y+C$P
2> from active database
4\ Gb1~%S-rn3^ ZZk\'F03> spfile set DB_UNIQUE_NAME 'standby'ITPUB个人空间jE"f`|)xP
4> set log_archive_dest_1ITPUB个人空间%V1F_N$a~yV'dBT-r
5> 'LOCATION=d:\standby\archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
"b5L'j;exQ+qIQ [06> 'ITPUB个人空间%Hp&[5kl#V
7> set CONTROL_FILES 'd:\app\administrator\oradata\standby\control01.ctl',
([X8GE.i @08> 'd:\app\administrator\oradata\standby\control02.ctl',ITPUB个人空间s5vd)|z]
9> 'd:\app\administrator\oradata\standby\control03.ctl'
'Q,C@b5^4DC_5VJ010> ;

Starting Duplicate Db at 31-JUL-08
4IL.tsob.qjR0using target database control file instead of recovery catalogITPUB个人空间8Q3Q+Omfpi.mSE
allocated channel: ORA_AUX_DISK_1
OJARkYC0channel ORA_AUX_DISK_1: SID=98 device type=DISK

contents of Memory Script.:
9uFf4r.X5n+l2f0{
gX
x't(a+z4E"n\I0   backup as copy reuseITPUB个人空间O q"Ia5bz7A'M3O
   file  'D:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEPRIMARY.ORA' auxiliary formatITPUB个人空间]
K1lH#|wJ~1\
 'D:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\SPFILESTANDBY.ORA'   ;ITPUB个人空间S I#AK1j
   sql clone "alter system set spfile= ''D:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\SPFILESTANDBY.ORA''";
b5qm:SN|s N3{ \0}ITPUB个人空间#Q#G3d(~6z*@ p7tc'Rd
executing Memory Script

Starting backup at 31-JUL-08
j F5{PhB9^E V8Q0allocated channel: ORA_DISK_1ITPUB个人空间&v:x7s]aB
channel ORA_DISK_1: SID=138 device type=DISK
2V T_q{
n B9B0Finished backup at 31-JUL-08

sql statement: alter system set spfile= ''D:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\SPFILESTANDBY.ORA''

contents of Memory Script.:
R*N.F%yh0{
:hx'b&pRD&@0   sql clone "alter system set  db_name =ITPUB个人空间t:fY"w7L$F PH
 ''STANDBY'' comment=ITPUB个人空间;D"If0^ _5X!iR/qF+H
 ''duplicate'' scope=spfile";ITPUB个人空间^6zF ?pq
   sql clone "alter system set  db_unique_name =ITPUB个人空间:ifh
o0tjJ"C
 ''standby'' comment=
*DJ4F dl"Z@@0 '''' scope=spfile";ITPUB个人空间f I%z"p U/M
   sql clone "alter system set  log_archive_dest_1 =ITPUB个人空间'V+]%jH^KFj
@1W
 ''LOCATION=d:\standby\archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES)'' comment=
3@,o9v I0GG0 '''' scope=spfile";
JY:BU wSz2E0   sql clone "alter system set  CONTROL_FILES =ITPUB个人空间:^ h*R*CsNs/K
 ''d:\app\administrator\oradata\standby\control01.ctl'', ''d:\app\administrator\oradata\standby\control02.ctl'', ''d:\app\administrator\oradata\standby\control03.ctl'' comment=ITPUB个人空间6ZQ2Jz2{0hQ
\
 '''' scope=spfile";
0@?A.?"y7HY0   shutdown clone immediate;
sdaB4D3lpE0   startup clone nomount ;ITPUB个人空间c!@![;f\f/Y#]J6C
}ITPUB个人空间qTDw#v
executing Memory Script

sql statement: alter system set  db_name =  ''STANDBY'' comment= ''duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''standby'' comment= '''' scope=spfile

sql statement: alter system set  log_archive_dest_1 =  ''LOCATION=d:\standby\archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES)'' comment= '''' scope=spfile

sql statement: alter system set  CONTROL_FILES =  ''d:\app\administrator\oradata\standby\control01.ctl'', ''d:\app\administrator\oradata\standby\control02.ctl'', ''d:\app\administrator\oradata\standby\control03.ctl'' comment= '''' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
%R(?f9N%D0Oracle instance started

Total System Global Area     431038464 bytes

Fixed Size                     1333676 bytes
?jF)nga:}%c7W0Variable Size                255854164 bytesITPUB个人空间 ~l}~W~+MX
Database Buffers             167772160 bytes
/`V,ayb^~0Redo Buffers                   6078464 bytes

contents of Memory Script.:
S%I&{%Ov.VBQ0P0{ITPUB个人空间 {"M!CeF8IH"p
   set newname for datafile  1 to
*Y0zG%f6V0 "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSTEM01.DBF";ITPUB个人空间%LiJK#~3z3]f
   set newname for datafile  2 toITPUB个人空间@
p0hG4i\\
 "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSAUX01.DBF";
Mm?t-w.X#_0   set newname for datafile  3 toITPUB个人空间.Z9Tn n(SP v+V
 "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\UNDOTBS01.DBF";
-CGf9qY0   set newname for datafile  4 to
dRc+A f#f l
h(S0 "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\USERS01.DBF";ITPUB个人空间f5KBUl?C
   set newname for datafile  5 toITPUB个人空间yg;W/a;o'n
 "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEST01_NEW.DBF";
ZC8XPk
G_G0   backup as copy reuseITPUB个人空间0J9Zdf&FmY
   datafile  1 auxiliary formatITPUB个人空间'tj\5ZC+Uz
 "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSTEM01.DBF"   datafileITPUB个人空间Hg&B2upQn,QK
 2 auxiliary formatITPUB个人空间-U~5d#a8m-X/v"J|
 "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSAUX01.DBF"   datafile
)tZl_3U]!]0 3 auxiliary formatITPUB个人空间7XQ2?*B uw2o A
D
 "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\UNDOTBS01.DBF"   datafile
aK)g^9k/J0 4 auxiliary formatITPUB个人空间U
~r3`^
 "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\USERS01.DBF"   datafile
G6h)O!EC3v0 5 auxiliary formatITPUB个人空间+fXt.~'|3l6r
 "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEST01_NEW.DBF"   ;ITPUB个人空间x'N_3eY9t2W6E*vX8h
   sql 'alter system archive log current';
9N1X.S.i4tbBr}0}
(~-x M:x@9y&v0executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 31-JUL-08
YB-}.WPi0using channel ORA_DISK_1
v2_;u(O9A0channel ORA_DISK_1: starting datafile copyITPUB个人空间2Y,z*A/~CI"n8j1F
input datafile file number=00001 name=D:\APP\ADMINISTRATOR\ORADATA\PRIMARY\SYSTEM01.DBF
fED#CaM"^;yz0output file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSTEM01.DBF tag=TAG20080731T141157 RECID=0 STAMP=0ITPUB个人空间O v-k4O DB
T
v,Tr
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15ITPUB个人空间.LShWD8^8@$y3P
channel ORA_DISK_1: starting datafile copy
.dihH7u!q5D0input datafile file number=00003 name=D:\APP\ADMINISTRATOR\ORADATA\PRIMARY\UNDOTBS01.DBF
T[/j)_O5z R@:H&t0output file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\UNDOTBS01.DBF tag=TAG20080731T141157 RECID=0 STAMP=0
_V'KYpr"w5V5rQ0channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
&w"u5NV!s2A{Y1Yf0channel ORA_DISK_1: starting datafile copyITPUB个人空间 K:SH-d%M2W \@#~"D
input datafile file number=00002 name=D:\APP\ADMINISTRATOR\ORADATA\PRIMARY\SYSAUX01.DBFITPUB个人空间kPMIs]j
output file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSAUX01.DBF tag=TAG20080731T141157 RECID=0 STAMP=0ITPUB个人空间f/~$@$W?*t
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
*IOz*Zp"C8y0channel ORA_DISK_1: starting datafile copy
}A?.at9Z:N5@0input datafile file number=00005 name=D:\APP\ADMINISTRATOR\ORADATA\PRIMARY\TEST01_NEW.DBFITPUB个人空间%^Mc:h(Aa*c [
output file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEST01_NEW.DBF tag=TAG20080731T141157 RECID=0 STAMP=0
8T'H0W~4jkL0channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03ITPUB个人空间&N^,r
S{
channel ORA_DISK_1: starting datafile copy
m6J7RHE-Q*|p0input datafile file number=00004 name=D:\APP\ADMINISTRATOR\ORADATA\PRIMARY\USERS01.DBF
a/MZ9mDI,dN&Y^C0output file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\USERS01.DBF tag=TAG20080731T141157 RECID=0 STAMP=0ITPUB个人空间5D'VBk0|&P:N/?o#j
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01ITPUB个人空间D OT"?t
Finished backup at 31-JUL-08

sql statement: alter system archive log currentITPUB个人空间!Cm}Jk"Oz$T
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "STANDBY" RESETLOGS ARCHIVELOG
%IBb x l*L0  MAXLOGFILES     16ITPUB个人空间KA$ZSj#k
  MAXLOGMEMBERS      3
]2{s!@n&|i0  MAXDATAFILES      100
$k
YxU6j[$m8_ _0  MAXINSTANCES     8
"XaRoU0  MAXLOGHISTORY      292ITPUB个人空间e't+d-aA4^w7K
 LOGFILEITPUB个人空间7tY:rW@s|%qW(S
  GROUP  1 ( 'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\REDO01.LOG' ) SIZE 50 M  REUSE,ITPUB个人空间)_$_0|Z:N4Kd
  GROUP  2 ( 'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\REDO02.LOG' ) SIZE 50 M  REUSE,

_a;Z/Y4X$g(B/y?0|5m0  GROUP  3 ( 'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\REDO03.LOG' ) SIZE 50 M  REUSEITPUB个人空间RGDm[hQ
 DATAFILE
F x$D@e
[?B0  'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSTEM01.DBF'
yjzC\
_/]0 CHARACTER SET WE8MSWIN1252

2J`mI*K2D z0contents of Memory Script.:ITPUB个人空间dP[@9?
{
)U1`;ykH W0   backup as copy reuse
mV |(x"jTs0   archivelog like  "D:\PRIMARY\ARCHIVELOG\ARC00047_0661357304.001" auxiliary format
@H0y:@2Ak/Cc#n0 "D:\STANDBY\ARCHIVELOG\ARC00047_0661357304.001"   ;
*?g| Wr/m0   catalog clone archivelog  "D:\STANDBY\ARCHIVELOG\ARC00047_0661357304.001";
;b1\a$n9hB.Yj x3q0   switch clone datafile all;
_R8JfwCJP2j.`0}ITPUB个人空间"g%rf*mdo
executing Memory Script

Starting backup at 31-JUL-08
?l8N6u6z%Z z%v6U0using channel ORA_DISK_1ITPUB个人空间Nn5{-onL t8v-lA(co]
channel ORA_DISK_1: starting archived log copyITPUB个人空间*Yy-b#fkHO
input archived log thread=1 sequence=47 RECID=65 STAMP=661529574ITPUB个人空间2C9q?4l?C{
output file name=D:\STANDBY\ARCHIVELOG\ARC00047_0661357304.001 RECID=0 STAMP=0ITPUB个人空间FeX1pki5pX[
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01ITPUB个人空间:}LQ5l]q/f~7d
Finished backup at 31-JUL-08

cataloged archived log
P a5F*w#Q P+a\0archived log file name=D:\STANDBY\ARCHIVELOG\ARC00047_0661357304.001 RECID=1 STAMP=661529578

datafile 2 switched to datafile copy
&ds$U)C;D!qF!TY0input datafile copy RECID=1 STAMP=661529578 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSAUX01.DBFITPUB个人空间PL'p&@&d*a$D2N
datafile 3 switched to datafile copy
D7?D3k$l4Wr"e0input datafile copy RECID=2 STAMP=661529579 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\UNDOTBS01.DBF
IgB3mR8rvax0datafile 4 switched to datafile copy
D _7S+XG'x/V1~0input datafile copy RECID=3 STAMP=661529579 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\USERS01.DBF

QH2e Y |'~rX*x0datafile 5 switched to datafile copyITPUB个人空间 DD\s;q
r
input datafile copy RECID=4 STAMP=661529579 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEST01_NEW.DBF

contents of Memory Script.:
o#rE:C*@0{
%d;l3l.fJ9QA0   set until scn  286773;
(PRo$J6]0   recover
Iu&h"b9T~W0   clone databaseITPUB个人空间]a
X NjblZU
    delete archivelog
U[!eDA+@ ic?M0   ;ITPUB个人空间kN1l9`r6d S,?
}
5TtzkA0executing Memory Script

executing command: SET until clause

Starting recover at 31-JUL-08
r9b
VX2[+S/@0allocated channel: ORA_AUX_DISK_1
a|%w9m(mF"cH2v0channel ORA_AUX_DISK_1: SID=153 device type=DISK

starting media recovery

archived log for thread 1 with sequence 47 is already on disk as file D:\STANDBY\ARCHIVELOG\ARC00047_0661357304.001ITPUB个人空间BQQ%JO$\OJ
archived log file name=D:\STANDBY\ARCHIVELOG\ARC00047_0661357304.001 thread=1 sequence=47ITPUB个人空间\4U:zL(\ X
media recovery complete, elapsed time: 00:00:00
8qHEH$Pt0Finished recover at 31-JUL-08

contents of Memory Script.:
K[&h;f)}0{
"K*s"y{axO0   shutdown clone immediate;
8NOZI8TfM,~l(D0   startup clone nomount ;ITPUB个人空间 r t^ `1UM A
}ITPUB个人空间n"RB8p"H_j
executing Memory Script

database dismounted
,fz.xE k0Oracle instance shut down

connected to auxiliary database (not started)ITPUB个人空间 E#r8Bc A
Oracle instance started

Total System Global Area     431038464 bytes

Fixed Size                     1333676 bytesITPUB个人空间D*u
fT1n
Variable Size                255854164 bytesITPUB个人空间%Yz!}K7{
Database Buffers             167772160 bytesITPUB个人空间X9M)VBWY6|&j
Redo Buffers                   6078464 bytesITPUB个人空间Am:A'di z/W
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "STANDBY" RESETLOGS ARCHIVELOG
U-|/}3O/k7{ f7[zp0  MAXLOGFILES     16ITPUB个人空间!\
L'bA CHK
  MAXLOGMEMBERS      3
efN:INW#H,P0  MAXDATAFILES      100ITPUB个人空间US"jz0h^}e0s
  MAXINSTANCES     8ITPUB个人空间2DS#ufl!A*m"b)F
  MAXLOGHISTORY      292ITPUB个人空间R[i]4v8K;s
 LOGFILEITPUB个人空间;HM8L$x5`*sK0d1j
  GROUP  1 ( 'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\REDO01.LOG' ) SIZE 50 M  REUSE,
w^x:k,VYIx0  GROUP  2 ( 'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\REDO02.LOG' ) SIZE 50 M  REUSE,ITPUB个人空间U:G6?$m?},Sa;O
  GROUP  3 ( 'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\REDO03.LOG' ) SIZE 50 M  REUSE
ngZ0]x)Lxp0 DATAFILEITPUB个人空间G4?`a%R1A.S TU}
  'D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSTEM01.DBF'
/f zz9S#f^7RC"\o`U0 CHARACTER SET WE8MSWIN1252

ITPUB个人空间#d7k(I O1[jk
contents of Memory Script.:
1D$Np+au_\0{
`*OLQ|:uA$_1^q0   set newname for tempfile  1 toITPUB个人空间 u;BEN/D
 "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEMP01.DBF";ITPUB个人空间)X.q6~ C/b6H#E
   switch clone tempfile all;ITPUB个人空间
UV,z f aICD
   catalog clone datafilecopy  "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSAUX01.DBF";
|$M/j@&f_V|0   catalog clone datafilecopy  "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\UNDOTBS01.DBF";ITPUB个人空间7^MXOS ]
   catalog clone datafilecopy  "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\USERS01.DBF";
/h:m8z `XQv1F6z$x0   catalog clone datafilecopy  "D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEST01_NEW.DBF";
e3o;K&y2gD*C['NmZv0   switch clone datafile all;
v5T$q+c4Y+?2~R([0}ITPUB个人空间hmabU ? meh
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEMP01.DBF in control file

cataloged datafile copyITPUB个人空间|%[2ui'J%L
datafile copy file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSAUX01.DBF RECID=1 STAMP=661529588

cataloged datafile copy
\$}y-R|v0datafile copy file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\UNDOTBS01.DBF RECID=2 STAMP=661529588

cataloged datafile copyITPUB个人空间M2e1hN"a}^
datafile copy file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\USERS01.DBF RECID=3 STAMP=661529588

cataloged datafile copy
m)Hlz D0`:u9lY Z0datafile copy file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEST01_NEW.DBF RECID=4 STAMP=661529588

datafile 2 switched to datafile copy
LN%G4~f:o3iJ0input datafile copy RECID=1 STAMP=661529588 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\SYSAUX01.DBFITPUB个人空间zRI8jJ6HA
datafile 3 switched to datafile copy
V$dk.R[3W'FFz5L7N0input datafile copy RECID=2 STAMP=661529588 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\UNDOTBS01.DBF
;|mt;q%vp3I5t
v0datafile 4 switched to datafile copy
/q;iIt7Z l&U$M0input datafile copy RECID=3 STAMP=661529588 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\USERS01.DBF
al#Xx"QB+E.skq0datafile 5 switched to datafile copy
3d0y*I9S2|(N bqVR6x0input datafile copy RECID=4 STAMP=661529588 file name=D:\APP\ADMINISTRATOR\ORADATA\STANDBY\TEST01_NEW.DBF

contents of Memory Script.:ITPUB个人空间;\}l9Md-I
{
Z/YE"z#TxU0   Alter clone database open resetlogs;ITPUB个人空间*V5f^cJ:cj8h
}
}oRrV5Wn E0executing Memory Script

database opened
dq |:L3pJBr0Finished Duplicate Db at 31-JUL-08

7.登录复制的数据库

C:\Documents and Settings\Administrator>set oracle_sid=standby

C:\Documents and Settings\Administrator>sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 31 14:05:15 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

ITPUB个人空间8a%K$u%`D!m`'_s
Connected to:ITPUB个人空间7xhD2r-e C7uD
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - ProductionITPUB个人空间+C,q[?%K
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select status,instance_name from v$instance;

STATUS       INSTANCE_NAME
jd8{ e*Ow8zT,ks0------------ ----------------ITPUB个人空间4\r!kn2_U3aVJ4K
OPEN         standby

SQL> archive log list;ITPUB个人空间p$~"vS_4y
R
Database log mode              Archive ModeITPUB个人空间/zjb}:`!j$m
Automatic archival             EnabledITPUB个人空间)J#an%v+nlTM)Qp
Archive destination            d:\standby\archivelogITPUB个人空间*il(E7L BY@
Oldest online log sequence     1ITPUB个人空间,M-~&H9K*u"D\
Next log sequence to archive   2ITPUB个人空间2Yfbi)U+\3s(P Y
Current log sequence           2