physical standby configuration

8/16/2019 Physical Standby Configuration

http://slidepdf.com/reader/full/physical-standby-configuration 1/8

PHSICAL STANDY CONFIGURATION

1. Create and confgure p!"#ca$ Stand%! Data%a"e 1&g PART I

Confgure the Primary Database1. Enable Archivelog ModeS'L( "utdo)n #**ed#ate

S'L( "tartup *ountS'L( a$ter data%a"e arc#+e$og,S'L( a$ter data%a"e open,S'L( arc#+e $og $#"t

-. Create a Password File I a pa"")ord f$e doe" not e/#"t or te pr#*ar! data%a"e0 create one u"#ng te o$$o)#ng"tep"2orac$e3+*$#nu/1 456 cd 6ORACL78HO97:d%"2orac$e3+*$#nu/1 d%"56 orap)d f$e;orap)prod pa"")ord;9!S!"Pa"")ordS'L( a$ter "!"te* "et re*ote8$og#n8pa"")ordf$e;e/c$u"#+e "cope;"pf$e,S!"te* a$tered.S'L( "utdo)n #**ed#ate

S'L( "tartup open

<. Enable Force Logging (optional To p$ace te pr#*ar! data%a"e #n orced $ogg#ng *ode0 connect a" SYS and run te o$$o)#ng

S'L( a$ter data%a"e orce $ogg#ng, To +er#! orce $ogg#ng #" ena%$ed or te data%a"eS'L( "e$ect orce8$ogg#ng ro* +6data%a"e,FORC78LOGGING==============

Y7S

>. Create !tandby "edo Logs (optional

S'L( "e$ect group?0 tread?0 %!te"0 *e*%er" ro* +6$og,GROUP? THR7AD? @YT7S 979@7RS========== ========== ========== ==========1 1 ->-BB&& -- 1 ->-BB&& -< 1 ->-BB&& -

Te nu*%er o "tand%! redo $og" reu#red or te p!"#ca$ "tand%! data%a"e #n t#" e/a*p$e#" < E 1 1 ; > at &9@ eac.Fro* te pr#*ar! data%a"e0 connect a" SYS and run te o$$o)#ng to create our "tand%!redo $og f$e group"S'L( a$ter data%a"e add "tand%! $ogf$e tread 1 group > "#e &*,S'L( a$ter data%a"e add "tand%! $ogf$e tread 1 group "#e &*,S'L( a$ter data%a"e add "tand%! $ogf$e tread 1 group "#e &*,

S'L( a$ter data%a"e add "tand%! $ogf$e tread 1 group J "#e &*, To +er#! te ne) "tand%! redo $og f$e"S'L( "e$ect group?0 t!pe0 *e*%er ro* +6$ogf$e order %! group?0 *e*%er,

. Confgure the Primary Database #nitiali$ation Parameters Te para*eter" $#"ted %e$o) "ou$d %e p$aced #n te #n#t#a$#at#on f$e or te pr#*ar!data%a"e.? ===2 Du*p De"t#nat#on Para*eter" 5 === ?aud#t8f$e8de"t;K:u&1:app:orac$e:ad*#n:prod:adu*pK




%acground8du*p8de"t;K:u&1:app:orac$e:ad*#n:prod:%du*pKcore8du*p8de"t;K:u&1:app:orac$e:ad*#n:prod:cdu*pKu"er8du*p8de"t;K:u&1:app:orac$e:ad*#n:prod:udu*pK

? ===2 Ro$e=#ndependent Para*eter" 5 === ?arc#+e8$ag8target;M&&

co*pat#%$e;K1&.-.&..&Kcontro$8f$e";K:u&-:oradata:PROD:contro$f$e:o18*8c"tnM8.ct$K0K:u&<:a"8reco+er!8area:PROD:contro$f$e:o18*8c"t!!8.ct$Kd%8na*e;KprodKd%8create8f$e8de"t;K:u&-:oradataKd%8reco+er!8f$e8de"t;K:u&<:a"8reco+er!8areaKd#"patcer";KPROTOCOL;TCP S7RIC7;prodD@K#n"tance8na*e;KprodK$og8arc#+e8confg;Kdg8confg;prod0"t%!K$og8arc#+e8*a/8proce""e";>re*ote8$og#n8pa"")ordf$e;Ke/c$u"#+eK

? ===2 Pr#*ar! Ro$e Para*eter" 5 === ?

d%8un#ue8na*e;KprodK$og8arc#+e8de"t81;K$ocat#on;u"e8d%8reco+er!8f$e8 de"t +a$#d8or;a$$8$ogf$e"0a$$8ro$e"d%8un#ue8na*e;prodK$og8arc#+e8de"t8-;K"er+#ce;"t%!.#no +a$#d8or;on$#ne8$ogf$e"0pr#*ar!8ro$ed%8un#ue8na*e;"t%!K$og8arc#+e8de"t8"tate81;Kena%$eK$og8arc#+e8de"t8"tate8-;KdeerK"er+#ce8na*e";Kprod.#no0 prodK

? ===2 Stand%! Ro$e Para*eter" 5 === ?d%8f$e8na*e8con+ert;K:ST@Y:K0K:PROD:K$og8f$e8na*e8con+ert;K:ST@Y:K0K:PROD:Ka$8"er+er;KprodK0K"t%!Ka$8c$#ent;KprodK"tand%!8f$e8*anage*ent;KautoKSe+era$ o te #n#t#a$#at#on para*eter" $#"ted a%o+e can not %e d!na*#ca$$! *od#fed andtereore )#$$ reu#re te pr#*ar! data%a"e to %e %ouncedS'L( "utdo)n #**ed#ateS'L( "tartup

. Create a %ac&up o' the Primary DatabaseA p!"#ca$ "tand%! data%a"e can %e created u"#ng e#ter a ot or co$d %acup o te pr#*ar!a" $ong a" a$$ o te nece""ar! arc#+e$og" are a+a#$a%$e to %r#ng te "tand%! data%a"e to acon"#"tent "tate.2orac$e3+*$#nu/1 456 *d#r =p :u&>:orac$e:dg8"tag#ng2orac$e3+*$#nu/- 456 *d#r =p :u&>:orac$e:dg8"tag#ngFro* te pr#*ar! o"t0 peror* an R9AN %acup o te pr#*ar! data%a"e tat p$ace" te%acup"et #nto te "tag#ng d#rector!2orac$e3+*$#nu/1 456 r*an target "!":9!S!"Pa"")ord3prod

R9AN( %acup de+#ce t!pe d#" or*at K:u&>:orac$e:dg8"tag#ng:QUK data%a"e p$u"arc#+e$og,

J. Create a !tandby Controlfle U"#ng te "a*e proce"" a" a%o+e0 create a "tand%! contro$f$e #n te "tag#ng d#rector! u"#ngR9AN




2orac$e3+*$#nu/1 456 r*an target "!":9!S!"Pa"")ord3prod

R9AN( %acup de+#ce t!pe d#" or*at K:u&>:orac$e:dg8"tag#ng:QUK current contro$f$e or"tand%!,

B. Prepare an In#t#a$#at#on Para*eter or te Stand%! Data%a"eFrom the primary database create a pfle in the staging directory) S'L( create pf$e;K:u&>:orac$e:dg8"tag#ng:#n#t"t%!.oraK ro* "pf$e,F#$e created.Ne/t0 *od#! te nece""ar! para*eter" #n te ne) pf$e to a$$o) te data%a"e to operate #nte "tand%! ro$e.

? ===2 9e*or! Para*eter" 5 === ?"t%!.88d%8cace8"#e;M&MM>"t%!.88a+a8poo$8"#e;1JJJ-1"t%!.88$arge8poo$8"#e;1JJJ-1"t%!.88"ared8poo$8"#e;-B-1-J-"t%!.88"trea*"8poo$8"#e;&

? ===2 Du*p De"t#nat#on Para*eter" 5 === ?aud#t8f$e8de"t;K:u&1:app:orac$e:ad*#n:"t%!:adu*pK%acground8du*p8de"t;K:u&1:app:orac$e:ad*#n:"t%!:%du*pKcore8du*p8de"t;K:u&1:app:orac$e:ad*#n:"t%!:cdu*pKu"er8du*p8de"t;K:u&1:app:orac$e:ad*#n:"t%!:udu*pK

? ===2 Ro$e=#ndependent Para*eter" 5 === ?arc#+e8$ag8target;M&&co*pat#%$e;K1&.-.&..&Kcontro$8f$e";K:u&-:oradata:ST@Y:contro$f$e:o18*8c"tnM8.ct$K0K:u&<:a"8reco+er!8area:ST@Y:contro$f$e:o18*8c"t!!8.ct$Kd%8na*e;KprodKd%8create8f$e8de"t;K:u&-:oradataKd%8reco+er!8f$e8de"t;K:u&<:a"8reco+er!8areaKd#"patcer";KPROTOCOL;TCP S7RIC7;ST@YD@K#n"tance8na*e;K"t%!K$og8arc#+e8confg;Kdg8confg;prod0"t%!K$og8arc#+e8*a/8proce""e";>re*ote8$og#n8pa"")ordf$e;Ke/c$u"#+eK

? ===2 Pr#*ar! Ro$e Para*eter" 5 === ?d%8un#ue8na*e;K"t%!K$og8arc#+e8de"t81;K$ocat#on;u"e8d%8reco+er!8f$e8 de"t +a$#d8or;a$$8$ogf$e"0a$$8ro$e"d%8un#ue8na*e;"t%!K$og8arc#+e8de"t8-;K"er+#ce;prod.#no +a$#d8or;on$#ne8$ogf$e"0pr#*ar!8ro$ed%8un#ue8na*e;prodK$og8arc#+e8de"t8"tate81;Kena%$eK$og8arc#+e8de"t8"tate8-;Kena%$eK"er+#ce8na*e";K"t%!.#no0 "t%!K

? ===2 Stand%! Ro$e Para*eter" 5 === ?d%8f$e8na*e8con+ert;K:PROD:K0K:ST@Y:K$og8f$e8na*e8con+ert;K:PROD:K0K:ST@Y:Ka$8"er+er;KprodK0K"t%!Ka$8c$#ent;K"t%!K




"tand%!8f$e8*anage*ent;KautoK

M. *rans'er Files to the !tandby +ost U"#ng an OS re*ote cop! ut#$#t!0 tran"er te %acup o te pr#*ar! data%a"e0 "tand%!contro$f$e0 and "tand%! #n#t#a$#at#on para*eter f$e to te "tand%! o"t +*$#nu/-

2orac$e3+*$#nu/1 456 "cp :u&>:orac$e:dg8"tag#ng: +*$#nu/-:u&>:orac$e:dg8"tag#ng:

Confgure ,racle -et Components,racle -et ListenerA$toug not *andator!0 create a na*ed "tat#c $#"tener entr! #n te $#"tener.ora f$e or eacdata%a"e #n te Data Guard confgurat#onPrimary +ostSID8LIST8LIST7N7R ;SID8LIST ;SID8D7SC ;SID8NA97 ; PLS7/tProcORACL78HO97 ; :u&1:app:orac$e:product:1&.-.&:d%81PROGRA9 ; e/tproc

SID8D7SC ;GLO@AL8D@NA97 ; PROD.INFOSID8NA97 ; prodORACL78HO97 ; :u&1:app:orac$e:product:1&.-.&:d%81

IN@OUND8CONN7CT8TI97OUT8LIST7N7R ; &

LIST7N7R ;D7SCRIPTION8LIST ;D7SCRIPTION ;ADDR7SS ; PROTOCOL ; TCPHOST ; +*$#nu/1.#noPORT ; 1-1ADDR7SS ; PROTOCOL ; IPC7Y ; 7TPROC&!tandby +ost

SID8LIST8LIST7N7R ;SID8LIST ;SID8D7SC ;SID8NA97 ; PLS7/tProcORACL78HO97 ; :u&1:app:orac$e:product:1&.-.&:d%81PROGRA9 ; e/tprocSID8D7SC ;GLO@AL8D@NA97 ; [email protected] ; "t%!ORACL78HO97 ; :u&1:app:orac$e:product:1&.-.&:d%81

IN@OUND8CONN7CT8TI97OUT8LIST7N7R ; &

LIST7N7R ;




D7SCRIPTION8LIST ;D7SCRIPTION ;ADDR7SS ; PROTOCOL ; TCPHOST ; +*$#nu/-.#noPORT ; 1-1ADDR7SS ; PROTOCOL ; IPC7Y ; 7TPROC&

"estart ,racle -et Listener !erviceAter *a#ng cange" to te $#"tener.ora0 re"tart te Orac$e Net $#"tener "er+#ce on tepr#*ar! and "tand%! o"t

2orac$e3+*$#nu/1 456 $"nrct$ re$oad

2orac$e3+*$#nu/- 456 $"nrct$ re$oad

,racle -et Aliases Te pr#*ar! and "tand%! o"t "ou$d conta#n an Orac$e Net a$#a" #n te tn"na*e".ora f$e ora$$ pr#*ar! and "tand%! net "er+#ce na*e"

PROD.INFO ;

D7SCRIPTION ;ADDR7SS ; PROTOCOL ; TCPHOST ; +*$#nu/1.#noPORT ; 1-1CONN7CT8DATA ;S7R7R ; D7DICAT7DS7RIC78NA97 ; prod.#no

[email protected] ;D7SCRIPTION ;ADDR7SS ; PROTOCOL ; TCPHOST ; +*$#nu/-.#noPORT ; 1-1CONN7CT8DATA ;S7R7R ; D7DICAT7DS7RIC78NA97 ; "t%!.#no




Confgure the !tandby Database

T#" "ect#on conta#n" te "tep" u"ed to create0 *ount0 and "tart Redo App$! "er+#ce" or te

p!"#ca$ "tand%! data%a"e.

1. Create the !tandby Password File

Create te pa"")ord f$e on te "tand%! data%a"e u"#ng te o$$o)#ng "tep"

2orac$e3+*$#nu/- 456 cd 6ORACL78HO97:d%"

2orac$e3+*$#nu/- d%"56 orap)d f$e;orap)"t%! pa"")ord;9!S!"Pa"")ord

-. Create an spfle 'or the !tandby #nstance

2orac$e3+*$#nu/- 456 "$p$u" : a" "!"d%a

S'L( create "pf$e ro* pf$e;K:u&>:orac$e:dg8"tag#ng:#n#t"t%!.oraK,

F#$e created.

S'L( $" =$ 6ORACL78HO97:d%"

tota$ 1-

=r)=r===== 1 orac$e o#n"ta$$ 1< Dec B ---& orap)"t%!=r)=r===== 1 orac$e o#n"ta$$ >&B Dec B ---& "pf$e"t%!.ora

<. Create and !tart the !tandby #nstance

Start %! creat#ng te du*p d#rector#e" on te "tand%! o"t a" reerenced #n te "tand%!

#n#t#a$#at#on para*eter f$e

2orac$e3+*$#nu/- 456 *d#r =p :u&1:app:orac$e:ad*#n:"t%!:adu*p

2orac$e3+*$#nu/- 456 *d#r =p :u&1:app:orac$e:ad*#n:"t%!:%du*p

2orac$e3+*$#nu/- 456 *d#r =p :u&1:app:orac$e:ad*#n:"t%!:cdu*p

2orac$e3+*$#nu/- 456 *d#r =p :u&1:app:orac$e:ad*#n:"t%!:dpdu*p

2orac$e3+*$#nu/- 456 *d#r =p :u&1:app:orac$e:ad*#n:"t%!:pf$e

2orac$e3+*$#nu/- 456 *d#r =p :u&1:app:orac$e:ad*#n:"t%!:"cr#pt"

2orac$e3+*$#nu/- 456 *d#r =p :u&1:app:orac$e:ad*#n:"t%!:udu*p

Ne/t0 create and +er#! a$$ d#rector#e" on te "tand%! o"t tat )#$$ %e u"ed or data%a"e f$e"

and te F$a" Reco+er! Area

2orac$e3+*$#nu/- 456 *d#r =p :u&-:oradata:ST@Y:contro$f$e

2orac$e3+*$#nu/- 456 *d#r =p :u&-:oradata:ST@Y:dataf$e

2orac$e3+*$#nu/- 456 *d#r =p :u&-:oradata:ST@Y:on$#ne$og

2orac$e3+*$#nu/- 456 *d#r =p :u&<:a"8reco+er!8area:ST@Y:arc#+e$og

2orac$e3+*$#nu/- 456 *d#r =p :u&<:a"8reco+er!8area:ST@Y:auto%acup

2orac$e3+*$#nu/- 456 *d#r =p :u&<:a"8reco+er!8area:ST@Y:%acup"et

2orac$e3+*$#nu/- 456 *d#r =p :u&<:a"8reco+er!8area:ST@Y:contro$f$e

2orac$e3+*$#nu/- 456 *d#r =p :u&<:a"8reco+er!8area:ST@Y:on$#ne$og

Ater +er#!#ng te appropr#ate en+#ron*ent +ar#a%$e" are "et on te "tand%! o"t6ORACL78SID0 6ORACL78HO970 6PATH0 6LD8LI@RARY8PATH0 "tart te p!"#ca$ "tand%!

#n"tance

2orac$e3+*$#nu/- 456 eco 6ORACL78SID

"t%!

2orac$e3+*$#nu/- 456 "$p$u" : a" "!"d%a




S'L( "tartup no*ount

>. Create the Physical !tandby Database

Fro* te "tand%! o"t )ere te "tand%! #n"tance )a" u"t "tarted0 dup$#cate te pr#*ar!

data%a"e a" a "tand%! u"#ng R9AN

2orac$e3+*$#nu/- 456 r*an target "!":9!S!"Pa"")ord3prod au/#$#ar!

"!":9!S!"Pa"")ord3"t%!

R9AN( dup$#cate target data%a"e or "tand%!,

R9AN( e/#t

Te R9AN dup$#cate proce"" a%o+e )#$$ read te %acup"et tat )a" tran"erred to te

"tag#ng d#rector!0 c$one te "tand%! contro$f$e0 *ount te data%a"e on te ne) "tand%!

contro$f$e0 and re"tore te p!"#ca$ data%a"e f$e".

. !tart "edo Apply on the !tandby Database

No) tat te "tand%! #" #n p$ace0 "tart Redo App$! on te "tand%! data%a"e %! putt#ng #t #n

*anaged reco+er! *ode.

S'L( a$ter data%a"e reco+er *anaged "tand%! data%a"e d#"connect, To u"e Rea$ T#*e App$!0 run te o$$o)#ng a$ternate +er"#on o te a$ter data%a"e co**and

to p$ace te "tand%! data%a"e #n *anaged reco+er! *ode

S'L( a$ter data%a"e reco+er *anaged "tand%! data%a"e u"#ng current $ogf$e d#"connect,

-,*E)*o use real time apply standby logfle is mandatory.

!tart "emote Archiving

V#t te "tand%! data%a"e no) #n *anaged reco+er! *ode0 te ne/t and fna$ pa"e #" to

"tart "#pp#ng redo data to te "tand%! ro* te pr#*ar!.

S'L( a$ter "!"te* "et $og8arc#+e8de"t8"tate8-;ena%$e "cope;%ot,

S!"te* a$tered.

To orce te current redo $og" to %e arc#+ed #**ed#ate$!0 u"e te o$$o)#ng "tate*ent on

te pr#*ar! data%a"e

S'L( a$ter "!"te* arc#+e $og current,

S!"te* a$tered.

At t#" po#nt0 te "tand%! data%a"e )#$$ cont#nue to app$! cange" ro* arc#+e redo $og"

%e#ng tran"erred ro* te pr#*ar!.

"edo *ransport

Fro* te pr#*ar! data%a"e0 peror* a $og ")#tc and ten +er#! te tran"*#""#on" o te

arc#+e redo $og f$e )a" "ucce""u$

S'L( a$ter "!"te* ")#tc $ogf$e,

S'L( "e$ect "tatu"0 error ro* +6arc#+e8de"t )ere de"t8#d ; -,STATUS 7RROR

========= =========================================================

ALID

I te tran"*#""#on )a" "ucce""u$0 te "tatu" o te de"t#nat#on )#$$ %e ALID a" "o)n

a%o+e. I or an! rea"on te tran"*#""#on )a" un"ucce""u$0 te "tatu" )#$$ %e INALID and

te u$$ te/t o te error *e""age )#$$ %e popu$ated #n te 7RROR co$u*n )#c can %e u"ed




to #n+e"t#gate and correct te #""ue.

"edo Apply

F#r"t0 #dent#! te e/#"t#ng arc#+ed redo redo $og" on te "tand%! data%a"e

2orac$e3+*$#nu/- 456 "$p$u" "!":9!S!"Pa"")ord3"t%! a" "!"d%a

S'L( a$ter "e""#on "et n$"8date8or*at ; KDD=9ON=YYYY HH->9ISSK,

S'L( "e$ect "euence?0 fr"t8t#*e0 ne/t8t#*e0 arc#+ed0 app$#ed ro* +6arc#+ed8$og order

%! "euence?,

Fro* te pr#*ar! data%a"e0 arc#+e te current $og u"#ng te o$$o)#ng S'L "tate*ent

S'L( a$ter "!"te* arc#+e $og current,

Go %ac to te "tand%! data%a"e and re=uer! te 6ARCHI7D8LOG +#e) to +er#! redo

data )a" "#pped0 rece#+ed0 arc#+ed0 and app$#ed

S'L( "e$ect "euence?0 fr"t8t#*e0 ne/t8t#*e0 arc#+ed0 app$#ed ro* +6arc#+ed8$og order

%! "euence?,

physical standby configuration

Documents