Oracle Dataguard for win2003

Oracle10gdataguard for win2003

Oralce版本DOIT博客I,R4{R\~

SQL> select * from v$version;DOIT博客X3\3Q+YA;t3fv@
}

BANNER

---------------------------------------------------------------- DOIT博客&N&lndqi

Oracle Database10gEnterpriseEdition Release10.2.0.3.0 - ProdDOIT博客bV8D1s3p

PL/SQL Release10.2.0.3.0 - ProductionDOIT博客{a%syb{

CORE    10.2.0.3.0      ProductionDOIT博客:zuFS\w
b/m

TNS for 32-bit Windows: Version10.2.0.3.0 - Production

NLSRTL Version10.2.0.3.0 – ProductionDOIT博客 {F,J+STJ'Z

 DOIT博客
~~-z&E/Lc

Windows版本

Microsoft(R) Windows(R) Server 2003,EnterpriseEditionDOIT博客jVEnXF;}&BgQ;x

5.2.3790 Service Pack 1内部版本3790

primary ip:172.168.1.147    primary sid:test

standby ip:172.168.1.230    standby sid:test1

db_name:testDOIT博客 y6q*?D.}R1Y[

 DOIT博客mp*SvS9M0z

一、在primary和standby上安装oracle10r2软件，并打上10.2.0.3（5337014_10203_WINNT.zip）补丁,2台机器的安装目录相同。DOIT博客bTZ/ij&R2r){ x

 DOIT博客qAaw+L

二、在primary上用DBCA建立database,建立database的时候要设置成归档模式。DOIT博客 Jx;zy4hY

 DOIT博客g nvo4t0UnZb:l/m

三、为standby创建控制文件DOIT博客E o[$l}

从cmd登录到database,打开database,创建standby控制文件。

C:\>set oracle_sid=test

C:\>sqlplus /nologDOIT博客e7W6DO5u!DY

SQL>conn / as sysdba

SQL>startup;

SQL>alter database create standby controlfile as ‘c:\oracle\ TEST1_CONTOL.CTL’;DOIT博客sh'd:P$WI1j:BKFDO

四、修改primary的init文件,由于默认spfile启动，先创建pfile:DOIT博客*Z/s6~G-j?"A,E%|b

Sql>create pfile from pfileDOIT博客(~'g1?[
i w4O)w

然后修改C:\oracle\product\10.2.0\db_1\database\INITtest.ora，加入如下行：

*.db_unique_name=test

*.service_names=testDOIT博客
b!iI ^2v8w%DM1N`h

*.log_archive_config='DG_CONFIG=(test,test1)'

*.log_archive_dest_1='LOCATION=C:\oracle\product\10.2.0\flash_recovery_area

             VALID_FOR=(ALL_LOGFILES,ALL_ROLES)DOIT博客)M D#rj't(Fs

             db_unique_name=test'DOIT博客5v){m Q(x9y|Kb

*.log_archive_dest_2='SERVICE=test1

                             VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DOIT博客)_t+U1a+A"_ ^

                             DB_UNIQUE_NAME=test1'

*.log_archive_dest_state_1='enable'DOIT博客7Se4K{3BK"P+vw

*.log_archive_dest_state_2='enable'

*.FAL_CLIENT='test1'DOIT博客nV'\qn,t}

*.FAL_SERVER='test'DOIT博客3OY%P[~-?H

*.standby_file_management='auto'

*.standby_archive_dest='C:\oracle\product\10.2.0\flash_recovery_area'

删除C:\oracle\product\10.2.0\db_1\database\SPFILEtest.ora，让数据库用INITtest.ora参数启动。DOIT博客
iEhAH;J

五、把primary上的database移植到standby中

把primary上的test的库关闭。DOIT博客xy8R4G2R
CX$N&`

把primary上的test的相关datafile拷贝到standby机器上。文件路径要一致。

1.数据文件: C:\oracle\product\10.2.0\ oradata

2.参数文件：C:\oracle\product\10.2.0\db_1\database\INITtest.oraDOIT博客~U-mn;k#k K[

3.跟踪文件：C:\oracle\product\10.2.0\admin

4.在pramiry中生成的standby的控制文件：c:\oracle\TEST1_CONTOL.CTLDOIT博客$y o_7?F/U'm*^S

5.闪回文件：C:\oracle\product\10.2.0\ flash_recovery_area

 DOIT博客1?3jNyf&y9y
I(_OL

在cmd中建立standby的database服务

C:\〉oradim -NEW -SID test1 –INTPWD kyskys -STARTMODE manualDOIT博客$e3c"m7w2MY h!R

 DOIT博客[$^1Jir
gLM d_

创建standby的密码文件：

Orapwd file=PWDtest1 password=kyskys(和pramiry的密码一样)DOIT博客k+z
Q#le7a\F

六、修改standby的init文件，注意如下参数：DOIT博客.k@[!d|w(|4~5d}|

*.control_files='C:\oracle\TEST1_CONTOL.CTL'DOIT博客 C*YE!BB

*.db_unique_name='test1'

*.FAL_CLIENT='test1'DOIT博客%e4c0ss"mx/}

*.FAL_SERVER='test'DOIT博客,w
O0w-R b/f

*.service_names='test1'

*.standby_file_management='auto'

*.standby_archive_dest='C:\oracle\product\10.2.0\flash_recovery_area'DOIT博客_8vG$BzY/z$`W}m

*.log_archive_config='DG_CONFIG=(test,test1)'DOIT博客4I5I$t B%L m

*.log_archive_dest_1='LOCATION=C:\oracle\product\10.2.0\flash_recovery_area

             VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

             db_unique_name=test1'DOIT博客:uA$i i[op

*.log_archive_dest_2='SERVICE=testDOIT博客2TDhb}%M

VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

                     DB_UNIQUE_NAME=test'DOIT博客v O3UYR&?q [*c&m

*.log_archive_dest_state_1='enable'

*.log_archive_dest_state_2='enable'DOIT博客r;JYy]6M'qf

七、修改pramiry监听和TNS：

C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\ listener.ora

# listener.ora Network Configuration File:

C:\oracle\product\10.2.0\db_1\network\admin\listener.ora

# Generated by Oracle configuration tools.DOIT博客#Jg DN{7y2kR*Iq

 DOIT博客3H2r aYb0G

LISTENER =

 (DESCRIPTION_LIST =

   (DESCRIPTION =

    (ADDRESS_LIST =DOIT博客*O:U&J4ISch_-K }

     (ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.1.147)(PORT = 1521))DOIT博客0Xx[)l,c-?

    )DOIT博客^!Z
V/]l \

     (ADDRESS_LIST =

     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))DOIT博客Rx-e] Mt)`w

    )

   )DOIT博客R*c']zS/W
A;{g

 )

 DOIT博客'iY%Wpm#kf`

SID_LIST_LISTENER =DOIT博客G1Q0c7r2R6yD
hy q

 (SID_LIST =

   (SID_DESC =

     (SID_NAME = PLSExtProc)

     (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)DOIT博客*dc V \.\A

     (PROGRAM = extproc)

   )

   (SID_DESC =DOIT博客p(Bz%GT3}4h5D

   (GLOBAL_DBNAME = test)DOIT博客/nb%qkm]C

   (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)

   (SID_NAME = test)

   )DOIT博客 X/B
{0O0A

 )DOIT博客f B%mK%|A

C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora

# tnsnames.ora Network Configuration File:DOIT博客M)i [_2HH%`

C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.oraDOIT博客I3_)VW L3lM+s6amb

# Generated by Oracle configuration tools.DOIT博客I:kI1z U"eJ3{

TEST1 =DOIT博客)o"cU9C&{)z-{

 (DESCRIPTION =DOIT博客
}u6Z,Mv$R-y5c

   (ADDRESS_LIST =DOIT博客Ea:g5?9IM)d

     (ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.1.230)(PORT = 1521))DOIT博客5x$pR C%QS

   )

   (CONNECT_DATA =

     (SERVICE_NAME = test1)

   )DOIT博客sNA5D
Hl
a4q#b

 )

TEST =

 (DESCRIPTION =DOIT博客~Bw P;P

   (ADDRESS_LIST =DOIT博客MH"O6p*\Dr

     (ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.1.147)(PORT = 1521))

   )DOIT博客 }f6R nv#h7ys

   (CONNECT_DATA =

     (SERVICE_NAME = test)

   )

 )

 DOIT博客f%lL+q$Us%z}

EXTPROC_CONNECTION_DATA =

 (DESCRIPTION =

   (ADDRESS_LIST =

     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

   )

   (CONNECT_DATA =

     (SID = PLSExtProc)DOIT博客w"X3|%Q"p`a

     (PRESENTATION = RO)DOIT博客6c$v+k6H2c
_S+Wz,U

   )

 )DOIT博客Cg+aB2Qi

 DOIT博客2}j6y8L%f QN3t

七、修改standby监听和TNS：

# listener.ora Network Configuration File:DOIT博客H @P \ C[&c
A

C:\oracle\product\10.2.0\db_1\network\admin\listener.oraDOIT博客o,\SrJ.V j+HXQ

# Generated by Oracle configuration tools.

 DOIT博客@
MG0y%G B

LISTENER =DOIT博客|gm.Kw{4S

 (DESCRIPTION_LIST =

   (DESCRIPTION =DOIT博客 PC"S6DuR+Jl0L1u

     (ADDRESS_LIST =

       (ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.1.230)(PORT = 1521))

     )

   )DOIT博客 P.{bZi:l LS uG

 )

 DOIT博客jN_1fDx

SID_LIST_LISTENER =DOIT博客s o$Oi(l4Y&PL.KL4\

 (SID_LIST =DOIT博客&q,KG"k!HriL#b8Kk,_5Y
w

   (SID_DESC =

     (GLOBAL_DBNAME = test)

     (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)

     (SID_NAME = test)DOIT博客"V$[rou1r IVa+H$_

   )DOIT博客$T-E7Ps\U"{\

 )DOIT博客i&Tr$K)_})^6O

# tnsnames.ora Network Configuration File:

 C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

TEST1 =

 (DESCRIPTION =DOIT博客rI!lDOPJ&^

   (ADDRESS_LIST =DOIT博客W_^;N1p

     (ADDRESS = (PROTOCOL = TCP)(HOST = 172.168.1.230)(PORT = 1521))

   )DOIT博客n6Y I)o4N6Gu q

   (CONNECT_DATA =DOIT博客@/GuQ)g

     (SERVICE_NAME = test1)DOIT博客4Hhz"a@wb@

   )DOIT博客jH$zYV1i

 )DOIT博客6d^m*C8[6f

TEST =

 (DESCRIPTION =DOIT博客~1Hm_#\,`3~