Active Datagaurd Steps

Oracle 11g Active Data Guard using (RMAN) (RMA N)

Oracle Database 11g Active Standby Database Creation using RMAN PRIMAR SID!" (In#or$ation) Machine IP: 192.168.1.98 Machine Name: prim Database name (db_name): prim Database Uniqe Name (db_niqe_name): prim !N" "er#ice Name: stand(!hr$%h this ser#ice& the primar' machine i be c$nnected t$ "!*ND+, "!*ND+, machine)

S%AND& SID!" (In#or$ation) Machine IP: 192.168.1.99 Machine Name: stand Database name (db_name): stand Database Uniqe Name (db_niqe_name): stand !N" "er#ice Name: prim (!hr$%h this ser#ice& the standb' machine i be c$nnected t$ P-IM*-, machine)

CON'IGRA%ION ON PRIMAR SI%!"  "tep1: reate p/e 0r$m sp/e $n the primar' database: database: "3create p/e 0r$m sp/e4 "tep2:  *dd 0$$in% settin%s settin%s in the p/e $n the P-IM*-, P-IM*-, side. D+_UNIU5_N*M57primar'7 *_ient7primar'7 *_"er#er7standb'7 _*-;I<5_NI  7D_NI (primar'& standb')7 standb'_/e_mana%ementat$ -5M!5_IN_P*""=-DI55>U"I<5 _*-;I<5_-M*!?t_?s_?r.arc _*-;I<5_D5"!_1   7*!INU"5_D+_-5<5-,_I5_D5"!   <*ID_-(*_I5"&*_-5")   D+_UNIU5_N*M5primar'7 _*-;I<5_D5"!_2  7"5-
"er#ice_names7primar'7

Sa$*le I$age o# *ri$ary P'I+!,

"tep@: reate pass$rd /e sin% A"he pr$mptB. C$raceinE1FGH $rapd /e$rapprim pass$rdmana%er entries 0$rce' i%n$recase' "tepJ: "3startp m$nt4 "tep: !aKe the Primar' database t$ *rchi#e $% M$de. "3ater database archi#e$%4 5nabe $rce $%%in%. "3ater database 0$rce $%%in%4

N$ shtd$n the database: "3shtd$n immediate4 N$ startp the database: "3startp4

"tep6: N$ add standb' -ed$ $% %r$p t$ the P-IM*-, site. "3*ter database add standb' %r$p  (AL1LradhaLprimLstand1.$%B&BL1LradhaLprimLstand2.$%B) sie 1m4

"tepO: "tartp the database 0r$m p/e. "3startp p/e4 reate sp/e 0r$m p/e t$ startp the database ith sp/e. It is necessar' 0$r primar' database t$ se sp/e in a data%ard en#ir$nment. "3reate sp/e 0r$m p/e4 N$ b$nce the D+ t$ taKe aect $0 ne parameter 0r$m p/e. "tep8:

-estart the database "3 sht immediate4 "3 startp4 "tep9: $n/%re tnsnames.$ra $n b$th ser#ers t$ h$d entries 0$r b$th databases. N$ $n P-IM*-, site create 0$$in% ser#ices in !N"names.$ra /e. !his /e i be se $n standb' site as$. =hie createin% istener se N5!M- tiit'. Q tnsnames.$ra Net$rK $n/%rati$n ie: L1LradhaLpr$dctL11.2.Ldbh$me_1Lnet$rKLadminLtnsnames.$ra Q enerated b' race c$n/%rati$n t$$s. %-is is *ri$ary side %NS and +istener .le i$age,

N$te: !his tnsnames.$ra i be sed $n b$th side $0 data%ard en#. "tep1: istener.$ra 0$r "tandb' "ite. Q enerated b' race c$n/%rati$n t$$s. Standby side %NS and +istener Details I$age.

"tep11:

No/ c-ec0 t-e %NS and +istener #or &ot- side Pri$ary and Standby side Pri$ary side listener and %NS status

Standby side status o# tns and listener 

CON'IGRA%ION ON S%AND& SI%!" "tep1:

reate 0$$in% direct$ries $n tar%et standb' mKdir Rp L1L%$piLstand mKdir Rp L1L%$piLstandL-*  mKdir Rp LL1L%$piLstandL "tep2:

reate p/e 0$r standb'. %-e sa$*le i$age *.le o# standby,

"tep@:

"tart database sin% ab$#e created p/e "3startp n$m$nt p/e. "tepJ: reate pass$rd /e sin% A"he pr$mptB. C$raceinE1FGH $rapd /e$eapstand pass$rd$race entries 0$rce' i%n$recase' "tep: =e can ser an' $ne c$mmand t$ c$nnect -M*N

1.Use this c$mmand t$ c$nnect t$ rman $n primar' side rman tar%et s'sLmana%er aEiiar' s'sLmana%erstand 2.Use this c$mmand t$ c$nnect t$ rman $n standb' side rman tar%et s'sLmana%erprim aEiiar' s'sLmana%er "tep6:

-n 0$$in% script in rman pr$mpt t$ create standb' database sin% rman

-M*N3 dpicate tar%et database 0$r standb' 0r$m acti#e database

!he ab$#e c$mmand i create standb' database.

C-ec0 Standby Arc-ive Destination -n 0$$in% c$mmand at primar' site t$ checK archi#e dest_1 0$r standb' . seect stats& err$r 0r$m #Harchi#e_dest here dest_id24 n P-IM*-, site enabe $%_archi#e_dest_state_2 t$ start shippin% archi#ed red$ $%s. "3*ter s'stem set $%_archi#e_dest_state_25N*+5 sc$peb$th4

Start A**ly Process "tart the app' pr$cess $n standb' ser#er.  *!5- D*!*+*"5 -5<5- M*N*5D "!*ND+, D*!*+*"5 DI"NN5!4 I0 '$ need t$ cance the app' pr$cess& isse the 0$$in% c$mmand.  *!5- D*!*+*"5 -5<5- M*N*5D "!*ND+, D*!*+*"5 *N54 I0 '$ pre0er& '$ can set a dea' beteen the arri#a $0 the archi#ed red$ $% and it bein% appied $n the standb' ser#er sin% the 0$$in% c$mmands.  *!5- D*!*+*"5 -5<5- M*N*5D "!*ND+, D*!*+*"5 *N54

ReadOnly Standby and Active Data Guard nce a standb' database is c$n/%red& it can be $pened in readR$n' m$de t$ a$ qer' access. !his is $0ten sed t$ $S$ad rep$rtin% t$ the standb' ser#er& thereb' 0reein% p res$rces $n the primar' ser#er. =hen $pen in readR$n' m$de& archi#e $% shippin% c$ntines& bt mana%ed rec$#er' is st$pped& s$ the standb' database bec$mes increasin%' $t $0 date nti mana%ed rec$#er' is resmed. !$ sitch the standb' database int$ readR$n' m$de& d$ the 0$$in%. ";U!D=N IMM5DI*!54 "!*-!UP MUN!4  *!5- D*!*+*"5 P5N -5*D N,4 !$ resme mana%ed rec$#er'& d$ the 0$$in%. ";U!D=N IMM5DI*!54 "!*-!UP MUN!4  *!5- D*!*+*"5 -5<5- M*N*5D "!*ND+, D*!*+*"5 DI"NN5! -M "5""IN4 In 11%& race intr$dced the *cti#e Data ard 0eatre. !his a$s the standb' database t$ be $pen in readR$n' m$de& bt sti app' red$ in0$rmati$n. !his means a standb' can be a#aiabe 0$r qer'in%& 'et sti be p t$ date. !here are icensin% impicati$ns 0$r this 0eatre& bt the 0$$in% c$mmands sh$ h$ acti#e data %ard can be enabed. ";U!D=N IMM5DI*!54 "!*-!UP MUN!4  *!5- D*!*+*"5 P5N -5*D N,4  *!5- D*!*+*"5 -5<5- M*N*5D "!*ND+, D*!*+*"5 DI"NN5! -M "5""IN4

Since $anaged recovery continues /it- active data guard t-ere is no need to s/itc- bac0 to $anaged recovery #ro$ readonly $ode in t-is case .

"tep1: ance the mana%er rec$#er'. "3 rec$#er mana%ed standb' database cance4 Media rec$#er' c$mpete. "tep2: pen the database in readR$n' m$de. "3 ater database $pen read $n'4 Database atered. "tep@: -estarts the -ed$ app'. "3 rec$#er mana%ed standb' database disc$nnect sin% crrent $%/e4 Media rec$#er' c$mpete. RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR QQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQ QQQQQQQQQQQQQQQQQQQQQQQQ

 Active Data Guard %esting" create $ne ser and tabe nder the primar' side and checK in the "tandbb' side.  *nd add the detais in the tabe $n primar' side and checK the chan%es in the standb' side. Pri$ary side user adding

Standby side user login c-ec0ing i$age

%-e .nal result i$age o# *ri$ary and standby Pri$ary standby  

Protection Mode" !here are three pr$tecti$n m$des 0$r the primar' database: •

MaEimm *#aiabiit': !ransacti$ns $n the primar' d$ n$t c$mmit nti red$ in0$rmati$n has been ritten t$ the $nine red$ $% and the standb' red$ $%s $0 at east $ne standb' $cati$n. I0 n$ standb' $cati$n is a#aiabe& it acts in the same manner as maEimm per0$rmance m$de nti a standb' bec$mes a#aiabe a%ain.

•

MaEimm Per0$rmance: !ransacti$ns $n the primar' c$mmit as s$$n as red$ in0$rmati$n has been ritten t$ the $nine red$ $%. !rans0er $0 red$ in0$rmati$n t$ the standb' ser#er is as'nchr$n$s& s$ it d$es n$t impact $n per0$rmance $0 the primar'.

•

MaEimm Pr$tecti$n: !ransacti$ns $n the primar' d$ n$t c$mmit nti red$ in0$rmati$n has been ritten t$ the $nine red$ $% and the standb' red$ $%s $0 at

east $ne standb' $cati$n. I0 n$t sitabe standb' $cati$n is a#aiabe& the primar' database shts d$n. +' de0at& 0$r a ne' created standb' database& the primar' database is in maEimm per0$rmance m$de. "55! pr$tecti$n_m$de -M #Hdatabase4 P-!5!IN_MD5 RRRRRRRRRRRRRRRRRRRR M*>IMUM P5--M*N5 "3 !he m$de can be sitched sin% the 0$$in% c$mmands. N$te the aterati$ns in the red$ transp$rt attribtes. RR MaEimm *#aiabiit'.  *!5- ","!5M "5! _*-;I<5_D5"!_27"5-IMIT5 *<*I*+II!,4 RR MaEimm Per0$rmance.  *!5- ","!5M "5! _*-;I<5_D5"!_27"5-IMIT5 P5--M*N54 RR MaEimm Pr$tecti$n.  *!5- ","!5M "5! _*-;I<5_D5"!_27"5-IMIT5 P-!5!IN4  *!5- D*!*+*"5 P5N4