Database Cloning Using Hot Backup

DATABASE CLONING USING HOT BACKUP [root@localhost ~]# su  ra!a" [ra!a"@localhost ~] ll total $% r&rr $ ra!a" '(a$ $%) $%) A*r % $+,-. ra!a"$/0"1 r&rr $ ra!a" '(a$ $%. A*r % $ $$,22 $,22 ra!a"/0"1 [ra!a"@localhost ~] / ra!a"/0"1 [ra!a"@localhost ~] s3l*lus 4 as s5s'(a S6L7Plus, 80l0as0 $$/$/9/%/9  Pro'uct:o" o" Su" A*r ++ 9;,-+,+; +9$+ Co*5r: $;)+? +99.? Oracl0/ All r:
Put th0 'ata(as0 :" (acFu* !o'0 or taF:"< th0 (acFu* o 'ata:l0s / S6L alt0r 'ata(as0 (0<:" (acFu* alt0r 'ata(as0 (0<:" (acFu* 7 E88O8 at l:"0 $, O8A9$$+2, ca""ot start o"l:"0 (acFu* !0':a r0co10r5 "ot 0"a(l0' It &:ll "ot *ut th0 'ata(as0 :" (acFu* !o'0 (0caus0 !0':a r0co10r5 :s "ot 0"a(l0'? so 0"a(l0 th0 !0':a r0co10r5 :rst / S6L arch:10 lo< l:st Data(as0 lo< !o'0 No Arch:10 o'0  Auto!at:c arch:1al D:sa(l0'  Arch:10 '0st:"at:o" USEDB8ECOE8JILEDEST Ol'0st o"l:"0 lo< s03u0"c0 $ Curr0"t lo< s03u0"c0 + S6L shut :!!0':at0 Data(as0 clos0'/ Data(as0 ':s!ou"t0'/ O8ACLE :"sta"c0 shut 'o&"/ S6L startu* !ou"t O8ACLE :"sta"c0 start0'/ Total S5st0! Glo(al Ar0a +.+9$$+%- (5t0s :0' S:0 $+;;2-- (5t0s ar:a(l0 S:0 $)).-%)%- (5t0s Data(as0 Bu0rs .;%;$..% (5t0s 80'o Bu0rs ++.2+)9 (5t0s Data(as0 !ou"t0'/ S6L alt0r 'ata(as0 arch:10lo< Data(as0 alt0r0'/ S6L alt0r 'ata(as0 o*0"

Data(as0 alt0r0'/ S0t th0 arch:10 '0st:"at:o"s &h0r0 arch:10 r0'olo< :l0 &:ll
Data(as0 alt0r0'/ Ch0cF &h0th0r th0 'ata(as0 :s :" (acFu* !o'0 or "ot/ S6L s0l0ct 7 ro! 1(acFu* ILE# STATUS CHANGE# TIE     $ ACTIE M%M%;2 ++AP8$+ + ACTIE M%M%;2 ++AP8$+ 2 ACTIE M%M%;2 ++AP8$+ - ACTIE M%M%;2 ++AP8$+ Ch0cF th0 arch:10 lo< s03u0"c0 "u!(0r/ S6L arch:10 lo< l:st Data(as0 lo< !o'0 Arch:10 o'0  Auto!at:c arch:1al E"a(l0'  Arch:10 '0st:"at:o" 4'9$4oracl04ora'ata4ra!a"4arch Ol'0st o"l:"0 lo< s03u0"c0 $ N0t lo< s03u0"c0 to arch:10 2 Curr0"t lo< s03u0"c0 2 Ch0cF th0 arch:10 r0'olo< :l0s/ S6L s0l0ct "a!0 ro! 1arch:10'lo< NAE  4'9$4oracl04ora'ata4ra!a"4arch$+.)$+-2;-2/'(  4'9$4oracl04ora'ata4ra!a"4arch$2.)$+-2;-2/'(  Cha"<0 th0 'ata(as0 (acFu* !o'0 to 0"' (acFu*/ S6L alt0r 'ata(as0 0"' (acFu* Data(as0 alt0r0'/  A
S6L arch:10 lo< l:st Data(as0 lo< !o'0 Arch:10 o'0  Auto!at:c arch:1al E"a(l0'  Arch:10 '0st:"at:o" 4'9$4oracl04ora'ata4ra!a"4arch Ol'0st o"l:"0 lo< s03u0"c0 + N0t lo< s03u0"c0 to arch:10 Curr0"t lo< s03u0"c0 orc0ull5 s&:tch th0 lo<:l0 or arch:1:"< / S6L alt0r s5st0! s&:tch lo<:l0 S5st0! alt0r0' TaF0 th0 (acFu* o co"trol :l0 to trac0 o"l5 (0caus0 &0 "00' to cha"<0 th0 'ata(as0 "a!0 &h:l0 cr0at:"< th0 co"trol :l0 S6L alt0r 'ata(as0 (acFu* co"trol:l0 to trac0 Data(as0 alt0r0'/ Ch0cF th0 al0rt lo< :l0 locat:o"s us:"< 0:th0r 1':a<:"o or (acF
Curr0"t lo<# $ s03# - !0!# 9, 4'9$4oracl04ora'ata4ra!a"4r0'o9$/lo< Su" A*r ++ 9;,M$,2% +9$+ alt0r 'ata(as0 0"' (acFu* Co!*l0t0', alt0r 'ata(as0 0"' (acFu* alt0r 'ata(as0 (acFu* co"trol:l0 to trac0 BacFu* co"trol:l0 &r:tt0" to trac0 :l0 4'9$4oracl04':a<4r'(!s4ra!a"4ra!a"4trac04ra!a"ora2%%+/trc Co!*l0t0', alt0r 'ata(as0 (acFu* co"trol:l0 to trac0 Co*5 th0 trac0 :l0 to so!0 locat:o"s a"' 'o th0 !o'::cat:o"s :" th0 scr:*t/ [ra!a"@localhost trac0] c* 4'9$4oracl04':a<4r'(!s4ra!a"4ra!a"4trac04ra!a"ora2%%+/trc 4'9$4ra!a"/s3l [ra!a"@localhost trac0] 1: 4'9$4ra!a"/s3l STA8TUP NOOUNT C8EATE CONT8OLILE SET DATABASE CLONEHOT 8ESETLOGS  A8CHIELOG ALOGILES $% ALOGEBE8S 2 ADATAILES $99 AINSTANCES ) ALOGHISTO8J +;+ LOGILE G8OUP $ 4'9$4oracl04ora'ata4clo"0hot4r0'o9$/lo< SIE M9? G8OUP + 4'9$4oracl04ora'ata4clo"0hot4r0'o9+/lo< SIE M9? G8OUP 2 4'9$4oracl04ora'ata4clo"0hot4r0'o92/lo< SIE M9  STANDBJ LOGILE DATAILE   4'9$4oracl04ora'ata4clo"0hot4s5st0!9$/'(?   4'9$4oracl04ora'ata4clo"0hot4s5sau9$/'(?   4'9$4oracl04ora'ata4clo"0hot4u"'ot(s9$/'(?   4'9$4oracl04ora'ata4clo"0hot4us0rs9$/'( CHA8ACTE8 SET QE)SQIN$+M+  ,Rs4ra!a"4clo"0hot4<

Not0, All th0 locat:o"s o th:s co"trol :l0 cr0at:o" scr:*t shoul' 0:st *h5s:call5? so cr0at0 th0 a**ro*r:at0 ':r0ctor5 *h5s:call5/ S6L cr0at0 *:l0 ro! s*:l0 :l0 cr0at0'/ No&? co!0 to *ara!0t0r :l0 locat:o"s a"' co*5 th0 *:l0 [ra!a"@localhost trac0] c' O8ACLEHOE4'(s [ra!a"@localhost '(s] c* :":tra!a"/ora :":tclo"0hot/ora E':t th0 *ara!0t0r :l0 a"' 'o th0 a**ro*r:at0 cha"<0s/ Not0, All th0 locat:o"s o th:s *ara!0t0r :l0 shoul' 0:st *h5s:call5? so cr0at0 th0 a**ro*r:at0 ':r0ctor5 *h5s:call5 a"' cha"<0 th0 'ata(as0 "a!0 also [ra!a"@localhost '(s] 1: :":tclo"0hot/ora clo"0hot/'(cach0s:0+9;.$M+9 clo"0hot/a1a*ools:0-$;-29clo"0hot/lar<0*ools:0-$;-29clo"0hot/oracl0(as04'9$4oracl0#O8ACLEBASE s0t ro! 0"1:ro"!0"t clo"0hot/*
7/':a<"ost:c'0st4'9$4oracl0 7/':s*atch0rs=P8OTOCOLTCP> =SE8ICEclo"0hotDB> 7/lo<arch:10'0st$LOCATION4'9$4oracl04ora'ata4clo"0hot4arch 7/!0!or5tar<0t+%;-)-92+ 7/o*0"cursors299 7/*roc0ss0s$M9 7/r0!ot0lo<:"*ass&or':l0ECLUSIE 7/u"'ota(l0s*ac0UNDOTBS$ ,Rs4ra!a"4clo"0'(4< [ra!a"@localhost ~] c' 4'9$4oracl04ora'ata4ra!a" [ra!a"@localhost ra!a"] ll total $M)$-M+ r&r $ ra!a" '(a$ -;+);+$% A*r ++ 9;,-% arch$+.)$+-2;-2/'(  r&r $ ra!a" '(a$ .;).+ A*r ++ 9;,M9 arch$2.)$+-2;-2/'(  r&r $ ra!a" '(a$ $;+MM+;% A*r ++ $9,99 arch$-.)$+-2;-2/'(  r&r $ ra!a" '(a$ ;.-)-)9 A*r ++ $9,99 co"trol9$/ctl r&r $ ra!a" '(a$ ;.-)-)9 A*r ++ $9,99 co"trol9+/ctl r&r $ ra!a" '(a$ ;.-)-)9 A*r ++ $9,99 co"trol92/ctl r&r $ ra!a" '(a$ M+-+;2$+ A*r ++ $9,99 r0'o9$/lo< r&r $ ra!a" '(a$ M+-+;2$+ A*r ++ $9,99 r0'o9+/lo< r&r $ ra!a" '(a$ M+-+;2$+ A*r ++ 9;,M9 r0'o92/lo< r&r $ ra!a" '(a$ M;9))9.%) A*r ++ $9,99 s5sau9$/'(  r&r $ ra!a" '(a$ .+2M+M%2+ A*r ++ $9,99 s5st0!9$/'(  r&r $ ra!a" '(a$ +9;.;.$+ A*r ++ 9;,M% t0!*9$/'(  r&r $ ra!a" '(a$ -$;M$+2+ A*r ++ 9;,M. u"'ot(s9$/'(  r&r $ ra!a" '(a$ M+M$9.+ A*r ++ 9;,M$ us0rs9$/'(  Co*5 th0 a**ro*r:at0 arch:10 r0'olo< :l0s to (acFu* locat:o"s / [ra!a"@localhost ra!a"] c* arch7 4'9$4oracl04ora'ata4clo"0hot4 [ra!a"@localhost ~] ll r&rr $ ra!a" '(a$ $%) A*r % $+,-. ra!a"$/0"1 r&rr $ ra!a" '(a$ $%. A*r % $$,22 ra!a"/0"1

Co*5 th0 0"1:ro"0!0"t :l0 to "0& locat:o"s a"' <:10 "a!0 to "0& 0"1:ro"0!0"t :l0 a"' cha"<0 th0 O8ACLESID *ara!0t0r / [ra!a"@localhost ~] c* ra!a"/0"1 clo"0hot/0"1 [ra!a"@localhost ~] 1: clo"0hot/0"1 0*ort O8ACLEBASE4'9$4oracl0 0*ort O8ACLEHOE4'9$4oracl04$$<8+ 0*ort O8ACLESIDclo"0hot 0*ort PATHO8ACLEHOE4(:",PATH 0*ort LDLIB8A8JPATHO8ACLEHOE4l:( No&? ru" th0 0"1:ro"!0"t :l0 o" sta<0 s0r10r/ [ra!a"@localhost ~] / clo"0hot/0"1 [ra!a"@localhost ~] s3l*lus 4 as s5s'(a S6L7Plus, 80l0as0 $$/$/9/%/9  Pro'uct:o" o" Su" A*r ++ 9;,M),+% +9$+ Co*5r: $;)+? +99.? Oracl0/ All r:
80co10r th0 'ata(as0 a"' a**l5 th0 arch:10 :l0s/ S6L r0co10r 'ata(as0 us:"< (acFu* co"trol:l0 u"t:l ca"c0l O8A99+.;, cha"<0 M%M%;2 <0"0rat0' at 9-4++4+9$+ 9;,-%,2+ "00'0' or thr0a' $ O8A99+);, su<<0st:o" , 4'9$4oracl04ora'ata4clo"0hot4arch$2.)$+-2;-2/'(  O8A99+)9, cha"<0 M%M%;2 or thr0a' $ :s :" s03u0"c0 #2 S*0c:5 lo<, 8ETsu<<0st0' V :l0"a!0 V AUTO V CANCELW auto O8A99+.;, cha"<0 M%M.-+ <0"0rat0' at 9-4++4+9$+ 9;,M9,+9 "00'0' or thr0a' $ O8A99+);, su<<0st:o" , 4'9$4oracl04ora'ata4clo"0hot4arch$-.)$+-2;-2/'(  O8A99+)9, cha"<0 M%M.-+ or thr0a' $ :s :" s03u0"c0 #O8A99+.), lo< :l0 4'9$4oracl04ora'ata4clo"0hot4arch$2.)$+-2;-2/'( "o lo"<0r "00'0' or th:s r0co10r5 O8A9929), ca""ot o*0" arch:10' lo< 4'9$4oracl04ora'ata4clo"0hot4arch$-.)$+-2;-2/'( O8A+.92., u"a(l0 to o(ta:" :l0 status L:"u Error, +, No such :l0 or ':r0ctor5  A'':t:o"al :"or!at:o", 2 O8A9$M-., &ar":"<, 8ECOE8 succ00'0' (ut OPEN 8ESETLOGS &oul' <0t 0rror (0lo& O8A9$$;M, o"l:"0 (acFu* o :l0 $ "00's !or0 r0co10r5 to (0 co"s:st0"t O8A9$$$9, 'ata :l0 $, 4'9$4oracl04ora'ata4clo"0hot4s5st0!9$/'( S6L r0co10r 'ata(as0 us:"< (acFu* co"trol:l0 u"t:l ca"c0l O8A99+.;, cha"<0 M%M.-+ <0"0rat0' at 9-4++4+9$+ 9;,M9,+9 "00'0' or thr0a' $

O8A99+);, su<<0st:o" , 4'9$4oracl04ora'ata4clo"0hot4arch$-.)$+-2;-2/'(  O8A99+)9, cha"<0 M%M.-+ or thr0a' $ :s :" s03u0"c0 #S*0c:5 lo<, 8ETsu<<0st0' V :l0"a!0 V AUTO V CANCELW auto O8A9929), ca""ot o*0" arch:10' lo< 4'9$4oracl04ora'ata4clo"0hot4arch$-.)$+-2;-2/'( O8A+.92., u"a(l0 to o(ta:" :l0 status L:"u Error, +, No such :l0 or ':r0ctor5  A'':t:o"al :"or!at:o", 2 O8A9$M-., &ar":"<, 8ECOE8 succ00'0' (ut OPEN 8ESETLOGS &oul' <0t 0rror (0lo& O8A9$$;M, o"l:"0 (acFu* o :l0 $ "00's !or0 r0co10r5 to (0 co"s:st0"t O8A9$$$9, 'ata :l0 $, 4'9$4oracl04ora'ata4clo"0hot4s5st0!9$/'( O*0" th0 'ata(as0 &:th r0s0tlo
%/ A