我申请这个blog是为了督促自己，把自己平时的一些想法和思考结果保留下来。 本博客所有内容均为原创，如有转载请注明作者和出处

Oracle11新特性——备份恢复功能增强（七）

上一篇 / 下一篇  2007-12-06 00:00:00 / 个人分类：ORACLE

查看( 14 ) / 评论( 0 ) / 评分( 0 / 0 )

打算写一系列的文章介绍11g的新特性和变化。

Oracle11g在备份和恢复方面新增了很多的功能，无论是性能、功能性、安全性和可操作性方面都有了不同程度的提高。

这一篇介绍DUPLICATE语法的增强。

Oracle11新特性——备份恢复功能增强（一）：http://yangtingkun.itpub.net/post/468/412991

Oracle11新特性——备份恢复功能增强（二）：http://yangtingkun.itpub.net/post/468/414647

Oracle11新特性——备份恢复功能增强（三）：http://yangtingkun.itpub.net/post/468/414834

Oracle11新特性——备份恢复功能增强（四）：http://yangtingkun.itpub.net/post/468/414941

Oracle11新特性——备份恢复功能增强（五）：http://yangtingkun.itpub.net/post/468/416015

Oracle11新特性——备份恢复功能增强（六）：http://yangtingkun.itpub.net/post/468/423531

ITPUB个人空间#jX3d/jp(]Wf

Oracle在11g中增强了DUPLICATE语法的功能，在使用DUPLICATE数据库或创建STANDBY数据库的时候，不再需要任何备份。也就是说，在目标数据库服务器上和本地数据库服务器上都不需要存在任何的备份，Oracle直接利用源数据库来生成目标数据库，Oracle把这种方法叫做active database duplication。

下面这个测试是在虚拟机上进行的，两台服务器都没有足够的空间存放备份，这时候，DUPLICATE新特性的优势就体现出来了。

利用11g提供的DUPLICATE功能，使得STANDBY创建过程简化很多，只需要在STANDBY数据库设置一个简单的init.ora文件，将STANDBY数据库实例启动起来就可以了：

[oracle@yangtk2 ~]$ echo 'db_name=ora11g' >> initora11g.oraITPUB个人空间;E|d(N5Y{4XHx
[oracle@yangtk2 ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Nov 29 13:25:44 2007

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

Connected to an idle instance.

SQL> startup nomount pfile=initora11g.oraITPUB个人空间mOX)S"?+{8m{
ORACLE instance started.

Total System Global Area 146472960 bytes
Q+]'@,?+P~&~:T+bcDp0Fixed Size 1298472 bytes
.v:xh2knv@9V0Variable Size 92278744 bytesITPUB个人空间~jD[;xE$C{Jg
Database Buffers 50331648 bytesITPUB个人空间}3HfH MpXUmm
Redo Buffers 2564096 bytesITPUB个人空间$qP.G z2I
SQL> exit
cA Q e6P0Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - ProductionITPUB个人空间~ j9|+}!F5^(m a
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsITPUB个人空间(r.c0G0m"K*A
[oracle@yangtk2 ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 29-NOV-2007 13:26:02

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

Starting /data/oracle/product/11.1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.6.0 - ProductionITPUB个人空间e*R#|:~g9O g a
System parameter file is /data/oracle/product/11.1/network/admin/listener.ora
%w_!u j!k)MD0Log messages written to /data/oracle/diag/tnslsnr/yangtk2/listener/alert/log.xml
^ ^1A1V:q&d0Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.25.4.70)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.25.4.70)(PORT=1521)))ITPUB个人空间I!}'r'A2vb9Z`O%J
STATUS of the LISTENERITPUB个人空间)w:l ?~ KUw7i
------------------------ITPUB个人空间`5| b4Dz|v
Alias LISTENERITPUB个人空间1tegU\j fu[I
Version TNSLSNR for Linux: Version 11.1.0.6.0 - ProductionITPUB个人空间DKI4qs`K;_
Start Date 29-NOV-2007 13:26:02
C J#gL6Pv W!r0Uptime 0 days 0 hr. 0 min. 0 secITPUB个人空间1Yt L/^ ?6K zu
Trace Level offITPUB个人空间v!_)?+i/Q;}(d
Security ON: Local OS AuthenticationITPUB个人空间*x%\h:D,`~ U
SNMP OFF
"|/ExZ@%k7U0Listener Parameter File /data/oracle/product/11.1/network/admin/listener.oraITPUB个人空间2X bW A8@:wP't#~(S
Listener Log File /data/oracle/diag/tnslsnr/yangtk2/listener/alert/log.xml
)]T DAj k0Listening Endpoints Summary...
UD?Eg4?$D0 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.25.4.70)(PORT=1521)))
/@CvO S!vC1U0The listener supports no servicesITPUB个人空间'RH%{$Ci'W w;R C1Q4X
The command completed successfully

根据主库的目录结构在STANDBY数据库服务器建立相应的目录。

在执行DUPLICATE之前，首先设置PRIMARY数据库的FORCE LOGGING和DATA GUARD相关的初始化参数：

[oracle@yangtk ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Nov 7 03:42:16 2007

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


Ch0fK"K6u/I;Foc0Connected to:
)M \;q:z:dlX0Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
*qsRaP\$N0With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> ALTER DATABASE FORCE LOGGING;

Database altered.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG = 'DG_CONFIG=(ora11g_p,ora11g_s)';

System altered.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=/data/oracle/oradata/ora11g/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ora11g_p' SCOPE = SPFILE;

System altered.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2 = 'SERVICE=ora11g_s ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora11g_s';

System altered.

SQL> ALTER SYSTEM SET FAL_SERVER = ora11g_s;

System altered.

SQL> ALTER SYSTEM SET FAL_CLIENT = ora11g_p;

System altered.

SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT = AUTO;

System altered.

下面登陆主站点，利用RMAN执行DUPLICATE命令：

[oracle@yangtk ~]$ rman target / auxiliary sys/test@172.25.4.70/ora11g

Recovery Manager: Release 11.1.0.6.0 - Production on Wed Nov 7 05:35:27 2007

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

connected to target database: ORA11G (DBID=4026820313)ITPUB个人空间DT5d.rLMo2Y@#q
connected to auxiliary database: ORA11G (not mounted)

RMAN> DUPLICATE TARGET DATABASE FOR STANDBY
0Y tdl)} yb02> DORECOVER FROM ACTIVE DATABASE NOFILENAMECHECK ITPUB个人空间1Zb!rdNz
3> SPFILE SET DB_UNIQUE_NAME 'ora11g_s'
W.`:X^$JBr]l04> SET FAL_CLIENT 'ora11g_s'ITPUB个人空间)?5o}8xt C.j)S;n
5> SET FAL_SERVER 'ora11g_p'ITPUB个人空间RZCy0n[@ `
6> SET LOG_ARCHIVE_DEST_1 ITPUB个人空间PD7mp2n$w
7> 'LOCATION=/data/oracle/oradata/ora11g/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ora11g_s'
JV9R!I6i9WuS8n+\08> SET LOG_ARCHIVE_DEST_2 ITPUB个人空间m(ddO&y @^
9> 'SERVICE=ora11g_p ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora11g_p'
\E,n P8i&k5Vv010> SET CONTROL_FILES '/data/oracle/oradata/ora11g/ORA11G_P/controlfile/control01.ctl',
7r+o:zi9_{#C y011> '/data/oracle/flash_recovery_area/ORA11G_P/controlfile/control02.ctl'ITPUB个人空间yC ] x8c^6Gn.|:T
12> ;

Starting Duplicate Db at 07-NOV-07
N]^)u [0using target database control file instead of recovery catalog
a8F(? A@|3Tw*Z,QE0allocated channel: ORA_AUX_DISK_1ITPUB个人空间oF xET9Vw1I
channel ORA_AUX_DISK_1: SID=98 device type=DISK

contents of Memory Script:ITPUB个人空间/@0A%ZRKM
{
x7z/V#?%~0 backup as copy reuseITPUB个人空间 t8O sv3lg
file '/data/oracle/product/11.1/dbs/orapwora11g' auxiliary format
cbEWh-l'[8uX0 '/data/oracle/product/11.1/dbs/orapwora11g' file ITPUB个人空间*` \\?3mJ
'/data/oracle/product/11.1/dbs/spfileora11g.ora' auxiliary format ITPUB个人空间&Y%T]5RT"?M
'/data/oracle/product/11.1/dbs/spfileora11g.ora' ;ITPUB个人空间&aI5t,MB:fN
sql clone "alter system set spfile= ''/data/oracle/product/11.1/dbs/spfileora11g.ora''";
S.I~*@ z0}ITPUB个人空间zW3Fb)JGV|R;h
executing Memory Script

Starting backup at 07-NOV-07
o7Y#_CA+C [&J0allocated channel: ORA_DISK_1ITPUB个人空间 ~W8x_;du^s y~
channel ORA_DISK_1: SID=131 device type=DISK
~&y$]&XD(JdNf0Finished backup at 07-NOV-07

sql statement: alter system set spfile= ''/data/oracle/product/11.1/dbs/spfileora11g.ora''

contents of Memory Script:
F7y A(B+U0{ITPUB个人空间M`R;Qm@Z~
sql clone "alter system set db_unique_name =
,]*{&A/[:]]3F0 ''ora11g_s'' comment=ITPUB个人空间Q8vBz/S
'''' scope=spfile";ITPUB个人空间!K,A*xL K1V/E
sql clone "alter system set FAL_CLIENT = ITPUB个人空间2^ E(x Jk
''ora11g_s'' comment=
%b @vYdhp-dVb0 '''' scope=spfile";ITPUB个人空间ljG6p ql2O ?5L
sql clone "alter system set FAL_SERVER = ITPUB个人空间zGxlU@ u
''ora11g_p'' comment=
[yK Y_&SwT1BB9~.T0 '''' scope=spfile";
$v5H zrz[Z0 sql clone "alter system set LOG_ARCHIVE_DEST_1 =
on_B zW-_ S0 ''LOCATION=/data/oracle/oradata/ora11g/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ora11g_s'' comment=ITPUB个人空间&JYpA3P]z S$W
'''' scope=spfile";ITPUB个人空间?+R-h%P$m$D;i)ax t
sql clone "alter system set LOG_ARCHIVE_DEST_2 = ITPUB个人空间&g"^(q\o'IR
''SERVICE=ora11g_p ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora11g_p'' comment=
#I9D#ms$Lu0 '''' scope=spfile";ITPUB个人空间2t/q"j7wft_
sql clone "alter system set CONTROL_FILES = ITPUB个人空间5c8F5O&O%w l2z1p
''/data/oracle/oradata/ora11g/ORA11G_P/controlfile/control01.ctl'', ''/data/oracle/flash_recovery_area/ORA11G_P/controlfile/control02.ctl'' comment=
FE-O9y o4NQ0 '''' scope=spfile";ITPUB个人空间#P:D'?n N:q
shutdown clone immediate;ITPUB个人空间+@6z2u7aNm
startup clone nomount ;
y^)GQ/O@I1J;v6C8F0}
{yIw(H de7_7^N0executing Memory Script

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

sql statement: alter system set FAL_CLIENT = ''ora11g_s'' comment= '''' scope=spfile

sql statement: alter system set FAL_SERVER = ''ora11g_p'' comment= '''' scope=spfile

sql statement: alter system set LOG_ARCHIVE_DEST_1 = ''LOCATION=/data/oracle/oradata/ora11g/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ora11g_s'' comment= '''' scope=spfile

sql statement: alter system set LOG_ARCHIVE_DEST_2 = ''SERVICE=ora11g_p ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora11g_p'' comment= '''' scope=spfile

sql statement: alter system set CONTROL_FILES = ''/data/oracle/oradata/ora11g/ORA11G_P/controlfile/control01.ctl'', ''/data/oracle/flash_recovery_area/ORA11G_P/controlfile/control02.ctl'' comment= '''' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
V DT v3B"rty0Oracle instance started

Total System Global Area 267825152 bytes

Fixed Size 1299316 bytes
X1t%X.s1h*BA0Variable Size 167775372 bytesITPUB个人空间3V Q{g'sj v+U
Database Buffers 96468992 bytesITPUB个人空间$A AU%WJZ#^&u
Redo Buffers 2281472 bytes

contents of Memory Script:
1VG+N;QX7k-D@0{
\!b)j,J(t|@|#d0 backup as copy current controlfile for standby auxiliary format '/data/oracle/oradata/ora11g/ORA11G_P/controlfile/control01.ctl';
{(F?? ]/h*E5^?l0 restore clone controlfile to '/data/oracle/flash_recovery_area/ORA11G_P/controlfile/control02.ctl' from ITPUB个人空间;Lz)a6gu6d+i-L
'/data/oracle/oradata/ora11g/ORA11G_P/controlfile/control01.ctl';ITPUB个人空间"MA Y[C
sql clone 'alter database mount standby database';
.}?3uc Vi0}
xv8z T3J.d2B0Y-v0executing Memory Script

Starting backup at 07-NOV-07ITPUB个人空间7I9@?;n5x+b/f)^LcS
using channel ORA_DISK_1
9hYN-K Zv{"{0channel ORA_DISK_1: starting datafile copyITPUB个人空间[\,|J1U4\
copying standby control fileITPUB个人空间:hY6x6H;CM~
output file name=/data/oracle/product/11.1/dbs/snapcf_ora11g.f tag=TAG20071107T053542 RECID=5 STAMP=637997751ITPUB个人空间3N])WA XU
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
3lh)HJ\&y J&q1]0Finished backup at 07-NOV-07

Starting restore at 07-NOV-07
H],l.A&e V*C+{0allocated channel: ORA_AUX_DISK_1
-Iw F:n}j$N u_ ^0channel ORA_AUX_DISK_1: SID=153 device type=DISK

channel ORA_DISK_1: no AUTOBACKUP in 7 days found
&b#v3x7i}Gv$Z0channel ORA_AUX_DISK_1: skipped, AUTOBACKUP already found
C.f0Ace0Nw&[5T0channel clone_default: copied control file copyITPUB个人空间!NkVtST%JA
Finished restore at 07-NOV-07

sql statement: alter database mount standby database

contents of Memory Script:
,x)J+_0I;wR5mvM0{ITPUB个人空间 }fM h6Vc
set newname for tempfile 1 to ITPUB个人空间e+y1^ h J*}.g_
"/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_temp_3m11bo2t_.tmp";ITPUB个人空间{(a{[I s&C
switch clone tempfile all;
_N8z\)_ W0 set newname for datafile 1 to ITPUB个人空间9t^YM2I![ [6l
"/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_system_3d3795py_.dbf";ITPUB个人空间 G_ X Y_xu S
set newname for datafile 2 to ITPUB个人空间%P*v~Tc5t
"/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_sysaux_3d379f1s_.dbf";ITPUB个人空间1K ]+Uw8p8A;p Z-k0R"B
set newname for datafile 3 to ITPUB个人空间 Ivg+XL1g`
"/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_undotbs1_3d379k48_.dbf";ITPUB个人空间 ~VFb#yk
set newname for datafile 4 to
H8BUE6Xvt b`0 "/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_users_3d37bq45_.dbf";
4up&G"SP1^0 set newname for datafile 5 to
}ET)h/c1|Y`(_ Z0 "/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_yangtk_3d3kn7k4_.dbf";
1An'Y l JXf A0 set newname for datafile 6 to
R5o%g5iSfAy*C0 "/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_yangtk_3g73q02m_.dbf";ITPUB个人空间f i `D ^h;S$j
backup as copy reuse
l8p7DF!_0 datafile 1 auxiliary format
u.I&Ga]:GTh4?)\ n0 "/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_system_3d3795py_.dbf" datafile
])ez:C T(pQ0 2 auxiliary format ITPUB个人空间*b!^j%GvW-gN*d6V
"/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_sysaux_3d379f1s_.dbf" datafile ITPUB个人空间-os!h!de*p'd1C^8i](u
3 auxiliary format ITPUB个人空间?,S/~ z2H
"/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_undotbs1_3d379k48_.dbf" datafile ITPUB个人空间 M(B`$lP x1Y}
4 auxiliary format
u~"LY*b \EJ5V0 "/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_users_3d37bq45_.dbf" datafile
YkC#c;h0 5 auxiliary format ITPUB个人空间PS"S?&\
"/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_yangtk_3d3kn7k4_.dbf" datafile ITPUB个人空间 F)q1?V4y#p:f a
6 auxiliary format
mJW Y;t"L0 "/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_yangtk_3g73q02m_.dbf" ;ITPUB个人空间H*Mwu9ZgX q9v;y
sql 'alter system archive log current';ITPUB个人空间qo;X9A?)H^
}ITPUB个人空间"IL+Gd-\
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_temp_3m11bo2t_.tmp in control file

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 at 07-NOV-07ITPUB个人空间g_-a6[Fe
using channel ORA_DISK_1ITPUB个人空间 k#E6?$H*Y"Zn f
channel ORA_DISK_1: starting datafile copy
1sQ5lcL,W.WX0input datafile file number=00001 name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_system_3d3795py_.dbf
FY(Ya q0output file name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_system_3d3795py_.dbf tag=TAG20071107T053611 RECID=0 STAMP=0
q&IK _WKS0channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:56ITPUB个人空间 d&X+{!]T
channel ORA_DISK_1: starting datafile copy
~y mA"Y/`'@"I0input datafile file number=00002 name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_sysaux_3d379f1s_.dbf
;ws:lC$i(kn{)d0output file name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_sysaux_3d379f1s_.dbf tag=TAG20071107T053611 RECID=0 STAMP=0ITPUB个人空间+pl9GuT3ihx_
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:36
b6Ml8_GE0channel ORA_DISK_1: starting datafile copy
z-N"]m{S Tc0input datafile file number=00003 name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_undotbs1_3d379k48_.dbf
:Jut4q8U[ M#A;I0output file name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_undotbs1_3d379k48_.dbf tag=TAG20071107T053611 RECID=0 STAMP=0ITPUB个人空间(PiB'`v:t2P+m
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:46
Rb6| l-U^J'y;@dhm0channel ORA_DISK_1: starting datafile copy
~xt~ l(t%C j0input datafile file number=00005 name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_yangtk_3d3kn7k4_.dbf
%xml [6aTa'wT4n0output file name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_yangtk_3d3kn7k4_.dbf tag=TAG20071107T053611 RECID=0 STAMP=0
efPh#s,~%D,b0channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
4FcOw$Fmft0channel ORA_DISK_1: starting datafile copyITPUB个人空间 G-H m5BD P`
input datafile file number=00006 name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_yangtk_3g73q02m_.dbf
2f*PpdA(H^0output file name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_yangtk_3g73q02m_.dbf tag=TAG20071107T053611 RECID=0 STAMP=0
{ gS o(j}8d0channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15ITPUB个人空间~3d'@j5M
channel ORA_DISK_1: starting datafile copyITPUB个人空间"l9du/R,tU
input datafile file number=00004 name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_users_3d37bq45_.dbf
!G$\"r5H'pn9A)~/P!H0output file name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_users_3d37bq45_.dbf tag=TAG20071107T053611 RECID=0 STAMP=0
1^p#|F'u7de0channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
]fU"@ _T0Finished backup at 07-NOV-07

sql statement: alter system archive log current

contents of Memory Script:
[]Koe0{
h Wr/A2e7y*T0 backup as copy reuse
QJ3z-GN0 archivelog like "/data/oracle/oradata/ora11g/archivelog/1_234_630620185.dbf" auxiliary format
y0@l/F2yF0N0 "/data/oracle/oradata/ora11g/archivelog/1_234_630620185.dbf" ;
QXJ:^b(W3Z0 catalog clone archivelog "/data/oracle/oradata/ora11g/archivelog/1_234_630620185.dbf";
P w#wgu7`.D0 switch clone datafile all;
1W}-{"fu LW0}
oZ @1q[nh E^[0executing Memory Script

Starting backup at 07-NOV-07ITPUB个人空间T Ipu$a-zS
using channel ORA_DISK_1
JO4r'L0Tk)g-hj0channel ORA_DISK_1: starting archived log copy
$JAH!fQw2i$A0input archived log thread=1 sequence=234 RECID=340 STAMP=637998112
;LI+Q&h*HM0output file name=/data/oracle/oradata/ora11g/archivelog/1_234_630620185.dbf RECID=0 STAMP=0ITPUB个人空间1nTdJF/B`
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01ITPUB个人空间F%sc#U ZN
Finished backup at 07-NOV-07

cataloged archived logITPUB个人空间9D ]_h%MB;@y#n
archived log file name=/data/oracle/oradata/ora11g/archivelog/1_234_630620185.dbf RECID=1 STAMP=639940971

datafile 1 switched to datafile copyITPUB个人空间,]kqz4e
input datafile copy RECID=5 STAMP=639940972 file name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_system_3d3795py_.dbf
a#x0])g e W:a `0datafile 2 switched to datafile copy
-U|@M9y8y n)@9}B0input datafile copy RECID=6 STAMP=639940972 file name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_sysaux_3d379f1s_.dbf
_VvT/J+\'Qh:I0datafile 3 switched to datafile copyITPUB个人空间g9L swb-P9k#xE
input datafile copy RECID=7 STAMP=639940972 file name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_undotbs1_3d379k48_.dbfITPUB个人空间Jx)e]$in
datafile 4 switched to datafile copy
[*j}4]y~0input datafile copy RECID=8 STAMP=639940972 file name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_users_3d37bq45_.dbf
9I u%S-W!S%Lx3~0datafile 5 switched to datafile copy
XZD}t,p,X0input datafile copy RECID=9 STAMP=639940972 file name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_yangtk_3d3kn7k4_.dbf
~(x-X(flC:A9V}0datafile 6 switched to datafile copyITPUB个人空间Y9|z/}k
input datafile copy RECID=10 STAMP=639940972 file name=/data/oracle/oradata/ora11g/ORA11G_P/datafile/o1_mf_yangtk_3g73q02m_.dbf

contents of Memory Script:ITPUB个人空间2{(T F)@.J
{ITPUB个人空间D f-r f5B9S6uK
set until scn 4362299;ITPUB个人空间4]*i|-q.g?J f
recover
YT-j$k'h'z w!I0 standbyITPUB个人空间t7{5y$f7D?D%M bm#n2m-w8`
clone database
mA;ad\ Jt E0 delete archivelogITPUB个人空间)WpI1m.]6A5N'Ul
;
d"Q;LN2\7II/a0}ITPUB个人空间sM]Bw L~:X
executing Memory Script

executing command: SET until clause

Starting recover at 07-NOV-07ITPUB个人空间+LL[g#~TvjCT&O
using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 234 is already on disk as file /data/oracle/oradata/ora11g/archivelog/1_234_630620185.dbf
'R.U+z h1w0archived log file name=/data/oracle/oradata/ora11g/archivelog/1_234_630620185.dbf thread=1 sequence=234
\;th8`Ec;Lr0media recovery complete, elapsed time: 00:00:01ITPUB个人空间 mF{1ZXV Z#_yz
Finished recover at 07-NOV-07ITPUB个人空间 G.h9m4p7b"M
Finished Duplicate Db at 07-NOV-07

下面登陆STANDBY数据库，并开始应用日志：

[oracle@yangtk2 ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Nov 29 17:43:07 2007

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


6s)th5] v%PS0Connected to:ITPUB个人空间"G LwN7ydf&~
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - ProductionITPUB个人空间"R~q bN
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database recover managed standby database disconnect from session;

Database altered.

在建立STANDBY的过程需要注意：

把密码文件从PRIMARY数据库拷贝到STANDBY数据库，否则执行DUPLICATE命令的时候会出现错误：

ORA-17627: ORA-01017: invalid username/password; logon denied

为STANDBY数据库指定新的控制文件位置，否则执行DUPLICATE命令的时候会出现错误：

ORA-19607: /data/oracle/oradata/ora11g/ORA11G_P/controlfile/o1_mf_3d378sn2_.ctl is an active control file

Oracle11g的新特性使得建立STANDBY数据库变得简化得多了，不再需要创建备份，不需要拷贝SPFILE、CONTROLFILE。


导入论坛 引用链接 收藏 分享给好友 推荐到圈子 管理 举报

TAG:

 

评分：0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

Open Toolbar