| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: cloning a 120gb database using dd
I did this some time ago on Sequent Dynix/ptx 4.4.0 This should not be an
issue.
I've attached 3 files which make up the routine.
1.CAPPPbld.sh
This is the controlling script and will obvously need to be modified for
your platform.
2.controlfile.sql
This is the code to recreate the control file for the new database.
3.CAPPPbld.rdcp
The actual commands to copy the raw datafiles. uses rdcp so you will have to change if you want to use dd.
mail me if you need more info at philh_at_sequent.com
ak494_at_hotmail.com wrote in article <792chd$avu$1_at_nnrp1.dejanews.com>...
> Oracle gurus,
> The entire db is on raw partitions. The OS is Aix 4.1
> and Oracle 7.3. I have all procedures to do cloning for an ordinary
> database. Do the same procedures follow if I replace cp (i.e. copying
> datafiles) by dd ? Export is not an alternative as we are not taking
> exports. If anybody has any information on this, I would be grateful
> for replies.
>
> Thanks
> Raja
>
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
begin 600 CAPPPbld.rdcp
M+V1E=B]V>"]R9'-K+W)E<W0O8V%P;%]R8G,P," O9&5V+W9X+W)D<VLO<F5S
M="]C87!P7W)B<S P#0HO9&5V+W9X+W)D<VLO<F5S="]C87!L7W1M<# P("]D
M978O=G_at_O<F1S:R]R97-T+V-A<'!?=&UP,# -"B]D978O=G_at_O<F1S:R]R97-T
M+V-A<&Q?=&UP,#$@+V1E=B]V>"]R9'-K+W)E<W0O8V%P<%]T;7 P,0T*+V1E
M=B]V>"]R9'-K+W)E<W0O8V%P;%]T;7 P,B O9&5V+W9X+W)D<VLO<F5S="]C
M87!P7W1M<# R#0HO9&5V+W9X+W)D<VLO<F5S="]C87!L7W1M<# S("]D978O
M=G_at_O<F1S:R]R97-T+V-A<'!?=&UP,#,-"B]D978O=G_at_O<F1S:R]R97-T+V-A
M<&Q?<WES,# @+V1E=B]V>"]R9'-K+W)E<W0O8V%P<%]S>7,P," -"B]D978O
M=G_at_O<F1S:R]R97-T+V-A<&Q?9# Q7S P("]D978O=G_at_O<F1S:R]R97-T+V-A
M<'!?9# Q7S P( T*+V1E=B]V>"]R9'-K+W)E<W0O8V%P;%]D,#%?,#$@+V1E
M=B]V>"]R9'-K+W)E<W0O8V%P<%]D,#%?,#$@#0HO9&5V+W9X+W)D<VLO<F5S
M="]C87!L7V0P,5\P,B O9&5V+W9X+W)D<VLO<F5S="]C87!P7V0P,5\P,B -
M"B]D978O=G_at_O<F1S:R]R97-T+V-A<&Q?9# R7S P("]D978O=G_at_O<F1S:R]R
M97-T+V-A<'!?9# R7S P( T*+V1E=B]V>"]R9'-K+W)E<W0O8V%P;%]D,#)?
M,#$@+V1E=B]V>"]R9'-K+W)E<W0O8V%P<%]D,#)?,#$@#0HO9&5V+W9X+W)D
M<VLO<F5S="]C87!L7V0P,E\P,B O9&5V+W9X+W)D<VLO<F5S="]C87!P7V0P
M,E\P,B -"B]D978O=G_at_O<F1S:R]R97-T+V-A<&Q?9# S7S P("]D978O=G_at_O
M<F1S:R]R97-T+V-A<'!?9# S7S P( T*+V1E=B]V>"]R9'-K+W)E<W0O8V%P
M;%]D,#-?,#$@+V1E=B]V>"]R9'-K+W)E<W0O8V%P<%]D,#-?,#$@#0HO9&5V
M+W9X+W)D<VLO<F5S="]C87!L7V0P,U\P,B O9&5V+W9X+W)D<VLO<F5S="]C
M87!P7V0P,U\P,B -"B]D978O=G_at_O<F1S:R]R97-T+V-A<&Q?9# T7S P("]D
M978O=G_at_O<F1S:R]R97-T+V-A<'!?9# T7S P( T*+V1E=B]V>"]R9'-K+W)E
M<W0O8V%P;%]D,#1?,#$@+V1E=B]V>"]R9'-K+W)E<W0O8V%P<%]D,#1?,#$@ M#0HO9&5V+W9X+W)D<VLO<F5S="]C87!L7V0P-%\P,B O9&5V+W9X+W)D<VLO M<F5S="]C87!P7V0P-%\P,B -"B]D978O=G_at_O<F1S:R]R97-T+V-A<&Q?9# UM7S P("]D978O=G_at_O<F1S:R]R97-T+V-A<'!?9# U7S P( T*+V1E=B]V>"]R
M9'-K+W)E<W0O8V%P;%]D,#5?,#$@+V1E=B]V>"]R9'-K+W)E<W0O8V%P<%]D M,#5?,#$@#0HO9&5V+W9X+W)D<VLO<F5S="]C87!L7V0P-5\P,B O9&5V+W9X M+W)D<VLO<F5S="]C87!P7V0P-5\P,B -"B]D978O=G_at_O<F1S:R]R97-T+V-AM<&Q?9# V7S P("]D978O=G_at_O<F1S:R]R97-T+V-A<'!?9# V7S P( T*+V1E
M=B]V>"]R9'-K+W)E<W0O8V%P;%]D,#9?,#$@+V1E=B]V>"]R9'-K+W)E<W0O M8V%P<%]D,#9?,#$@#0HO9&5V+W9X+W)D<VLO<F5S="]C87!L7V0P-E\P,B O ?9&5V+W9X+W)D<VLO<F5S="]C87!P7V0P-E\P,B -"B]C`
begin 600 Capppbld.sh
M(R$O8FEN+W-H#0HC<V5T("UX#0HC(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C
M(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(PT*(R!0<F]G<F%M.B!#05!0
M4&)L9"YS: T*(PT*(R!$97-C<FEP=&EO;CH_at_4F5B=6EL9',@0T%04% @9&%T
M86)A<V4_at_9G)O;2!T:&4_at_0T%03$E612!D871A8F%S92X-"B,-"B,@1&5T86EL
M._at_T*(PDQ+@E#:&5C:W,@=&AA="!B;W1H(&1A=&%B87-E<R!A<F4@<VAU=&1O
M=VXN#0HC"3(N"4-O<&EE<R!T:&4_at_0T%03$E612!F:6QE<R!U<VEN9R!R9&-P
M+@T*(PDS+@E292UC<F5A=&5S('1H92!#05!04"!C;VYT<F]L9FEL92X-"B,)
M-"X)4F4M8G5I;&1S('1H92!#05!04"!414U0('1A8FQE<W!A8V4N#0HC"34N
M"5)E+7-T87)T<R!#05!,259%(&1A=&%B87-E+@T*(PT*(R!.;W1E._at_T*(PDQ
M+@E38W)I<'0_at_8V%L;',@0T%04% N<F1C<"!W:&EC:"!I<R!A('-T871I8R!L
M:7-T#0HC"0EO9B!T:&4_at_9&%T86)A<V4@=F]L=6UE<R!T;R!B92!C;W!I960@
M86YD('1H92!T87)G970N#0HC"0E)9B!T:&4@;&%Y;W5T(&]F('1H92!D871A
M8F%S92!C:&%N9V5S('1H:7,@9FEL92!M87D_at_86QS;PT*(PD);F5E9"!T;R!C
M:&%N9V4@=&\@<F5F;&5C="!T:&ES+@T*(PT*(R!697)S:6]N.@T*(R @,B @
M,3,O,#,O.3@@(%!("49I>&5D(&)U9W,@86YD(&%D9&5D('1I;64@=&\@;&]G
M9FEL92!O=71P=70N#0HC(" Q(" P-"\P,R\Y-R )4$@)0F%S92X-"B,C(R,C
M(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C
M(R,C#0H-"E!23T<](D-!4%!08FQD(B )"0D)"2,@;F%M92!O9B!S8W)I<'0-
M"D]204-,15](3TU%/2(O;W!T+V%P<"]O<F%C;&4O<')O9'5C="\W+C,N,R() M"2,@3U)!0TQ%7TA/344-"D]204-,15]"05-%/2(O;W!T+V%P<"]O<F%C;&4B M"0D)"2,@3U)!0TQ%7T)!4T4-"D]204-,15]3240](D-!4%!0(@D)"0D)(R!/M4D%#3$5?4TE$#0I73U)+1$E2/2(D>T]204-,15]"05-%?2]A9&UI;B\D>T]2 M04-,15]3241]+W)E8G5I;&0B"2,@=V]R:VEN9R!D:7(-"E-13%=!4U1%/2(D M>U!23T=]+G=A<W1E(B )"0D)(R!W;W)K:6YG(&9I;&4-"E-13%=!4U1%,3TB
M)'M04D]'?2YW87-T93$B( D)"0DC('=O<FMI;F<@9FEL90T*4E5.3$]'/2(D
M>U=/4DM$25)]+T-!4%!08FQD+FQO9R(@(" )"0DC(&-Y8VQE9"!D86EL>2!L
M;V<-"E)$0U!,25-4/2(D>U=/4DM$25)]+R1[3U)!0TQ%7U-)1'TN<F1C<"()
M"2,@<F1C<"!F:6QE+@T*5$]$05D]8&1A=&4@*R5D)6TE>25()4U@"0D)"2,@
M=&]D87ES(&1A=&4N#0H-"F5X<&]R="!/4D%#3$5?2$]-12!/4D%#3$5?0D%3
M12!/4D%#3$5?4TE$#0H-"B,@0VQE87(@9&]W;B!T:&4_at_97AI<W1I;F<@<G5N
M(&QO9R!A;F0@:6YI=&EA;&ES92!A(&YE=R!O;F4_at_9F]R('1H:7,@<G5N+@T*
M(PT*<FT@+68@)'M254Y,3T=]#0H^("1[4E5.3$]'?0T*:68_at_6R D/R M;F4@
M,"!=(#L@=&AE;@T*("!%4E)-4T<](B1[4%)/1WT@("T@($524D]2(2!#86YN
M;W0_at_8W)E871E(&QO9R!F:6QE+B(@#0H@(&5C:&\@(B1[15)235-'?2(-"B @
M97AI=" Q#0IF:0T*#0HC(%=R:71E(&AE861E<B!D971A:6QS('1O(&QO9V9I
M;&4N#0HC#0IE8VAO("(D>U1/1$%9?3HD)#H^/CX^/B!3=&%R=&EN9R!#05!0
M4&)L9"YS:" \/#P\/"(@/CX@)'M254Y,3T=]#0H-"B,@0VAE8VL@:68_at_8F]T
M:"!#05!,259%(&%N9"!#05!04"!A<F4@<VAU=&1O=VXN#0HC#0IE8VAO("(D
M>U1/1$%9?3HD)#I#3TU-14Y4"3I#:&5C:VEN9R!D871A8F%S97,@87)E(&1O
M=VXN(B ^/B D>U)53DQ/1WT-"F9O<B!$0B!I;B!#05!,259%($-!4%!0(#L@
M9&\-"B @1$)54#U@<',@+65A9B!\(&=R97 @(F]R85]D8G=R7R1[1$)](B!\
M(&=R97 @+78@(F=R97 B('P@=V,@+6Q@#0H@(&EF(%L@)'M$0E50?2 M;F4@
M,"!=(#L@=&AE;@T*(" @($524DU31STB)'M43T1!67TZ)"0Z15)23U(@"3HD
M>T1"?2!I<R!N;W0@<VAU=&1O=VXN(@T*(" @(&5C:&\@(B1[15)235-'?2(@
M/CX@)'M254Y,3T=]#0H@(" @96-H;R B0T%04%!B;&0N<V@@9F%I;&5D+"!P
M;&5A<V4_at_8VAE8VL@;&]G(&9I;&4N(@T*(R @("!E>&ET(#$-"B @9FD-"F1O
M;F4-"@T*(R!,;V]P(')O=6YD('1H92!L:7-T(&]F(&9I;&5S('1O(&-O<'D@
M86YD('!E<F9O<FT@=&AE(')D8W -"B,@#0IE8VAO("(D>U1/1$%9?3HD)#I#
M3TU-14Y4"3I#;W!Y:6YG(&1A=&%B87-E('9O;'5M97,N(B ^/B D>U)53DQ/
M1WT-"G=H:6QE(')E860_at_24Y,24Y%(#L_at_9&\-"B @1E)/349)3$4]8&5C:&\@
M(B1[24Y,24Y%?2(@?"!A=VL@)WMP<FEN=" D,7TG8 T*("!43T9)3$4]8&5C
M:&\@(B1[24Y,24Y%?2(@?"!A=VL@)WMP<FEN=" D,GTG8 T*("!E8VAO("(D
M>U1/1$%9?3HD)#I#3TU-14Y4"3I#;W!Y:6YG(B )"0E<#0H@(" @(" @8&5C
M:&\@)'M&4D]-1DE,17T@?"!N87=K("=[('!R:6YT("0V('TG($93/2]@("(@
M/B B( E<#0H@(" @(" @8&5C:&\@)'M43T9)3$5]('P@;F%W:R G>R!P<FEN
M=" D-B!])R!&4STO8" ^/B D>U)53DQ/1WT-"B @<F1C<" D>T923TU&24Q%
M?2 D>U1/1DE,17T@/B D>U-13%=!4U1%,7T@,CXF,0T*("!I9B!;("0_("UN
M92 P(%T@.R!T:&5N#0H@(" @15)235-'/2(D>U1/1$%9?3HD)#I%4E)/4B )
M.D9A:6QU<F4@=&\@8V]P>2 D>T923TU&24Q%?2(@#0H@(" @96-H;R B)'M%
M4E)-4T=](B ^/B D>U)53DQ/1WT-"B @("!C870@)'M344Q705-413%](#X^
M("1[4E5.3$]'?0T*(" @(&5C:&\@(D-!4%!08FQD+G-H(&9A:6QE9"P@<&QE
M87-E(&-H96-K(&QO9R!F:6QE+B(-"B @("!E>&ET(#$-"B @96QS90T*(" @
M(%1204Y34D%413U_at_8V%T("1[4U%,5T%35$4Q?2!\(&=R97 @(D-O<&EE9")@
M#0H@(" @15)235-'/2(D>U1/1$%9?3HD)#I#3TU-14Y4"3HD>U1204Y34D%4
M17TB#0H@(" @96-H;R B)'M%4E)-4T=](B ^/B D>U)53DQ/1WT-"B @9FD-
M"F1O;F4@/" D>U)$0U!,25-4?0T*#0HC(%)U;B!S8W)I<'0@=&\@<F5B=6EL
M9"!T:&4_at_0T%04% @8V]N=')O;"!F:6QE+@T*(PT*96-H;R B)'M43T1!67TZ
M)"0Z0T]-345.5 DZ4F4M8G5I;&1I;F<@0T%04% @8V]N=')O;"!F:6QE+B(@
M/CX@)'M254Y,3T=]#0HD>T]204-,15](3TU%+V)I;B]S=G)M9W)L(&-O;6UA
M;F0]0"1[5T]22T1)4GTO8V]N=')O;&9I;&4N<W%L(#X@)'M344Q705-417T-
M"FEF(%L@)#\@+6YE(# @72 [('1H96X-"B @8V%T("1[4U%,5T%35$5](#X^
M("1[4E5.3$]'?0T*("!%4E)-4T<](B1[5$]$05E].E-3.D524D]2( DZ56YA
M8FQE('1O(')E8G5I;&0_at_0T%04% @8V]N=')O;&9I;&4N(@T*("!E8VAO("(D
M>T524DU31WTB(#X^("1[4E5.3$]'?0T*("!E8VAO(")#05!04&)L9"YS:"!F
M86EL960L('!L96%S92!C:&5C:R!L;V<@9FEL92XB#0H@(&5X:70@,0T*9FD-
M"@T*(R!292UC<F5A=&4@=&AE($-!4%!0(%1E;7 @=&%B;&5S<&%C92X-"B,-
M"F5C:&\@(B1[5$]$05E].B0D.D-/34U%3E0).E)E+6-R96%T:6YG($-!4%!0
M('1E;7 @=&%B;&5S<&%C92XB(#X^("1[4E5.3$]'?0T*)'M/4D%#3$5?2$]-
M12]B:6XO<W9R;6=R;"!C;VUM86YD/4 D>U=/4DM$25)]+T-!4%!0+G1E;7 @
M/B D>U-13%=!4U1%?0T*:68_at_6R D/R M;F4@,"!=(#L@=&AE;@T*("!C870@
M)'M344Q705-417T@/CX@)'M254Y,3T=]#0H@($524DU31STB)'M43T1!67TZ
M)"0Z15)23U(@"3I5;F%B;&4@=&\@<F4M8W)E871E(%1E;7 @=&%B;&5S<&%C
M92XB#0H@(&5C:&\@(B1[15)235-'?2(@/CX@)'M254Y,3T=]#0H@(&5C:&\@
M(D-!4%!08FQD+G-H(&9A:6QE9"P@<&QE87-E(&-H96-K(&QO9R!F:6QE+B(-
M"B @97AI=" Q#0IF:0T*#0HC(%)E+7-T87)T($-!4$Q)5D4_at_9&%T86)A<V4-
M"B,-"F5C:&\@(B1[5$]$05E].B0D.D-/34U%3E0).E)E+7-T87)T:6YG($-!
M4$Q)5D4_at_9&%T86)A<V4N(B ^/B D>U)53DQ/1WT-"D]204-,15]3240](D-!
M4$Q)5D4B(#L_at_97AP;W)T($]204-,15]3240-"B1[3U)!0TQ%7TA/344O8FEN
M+W-V<FUG<FP@/#PA(#X@)'M344Q705-417T-"F-O;FYE8W0@:6YT97)N86P-
M"G-T87)T=7 -"F5X:70-"B$-"FEF(%L@)#\@+6YE(# @72 [('1H96X-"B @
M8V%T("1[4U%,5T%35$5](#X^("1[4E5.3$]'?0T*("!%4E)-4T<](B1[5$]$
M05E].B0D.D524D]2( DZ56YA8FQE('1O(')E+6-R96%T92!496UP('1A8FQE
M<W!A8V4N(@T*("!E8VAO("(D>T524DU31WTB(#X^("1[4E5.3$]'?0T*("!E
M8VAO(")#05!04&)L9"YS:"!F86EL960L('!L96%S92!C:&5C:R!L;V<@9FEL
M92XB#0H@(&5X:70@,0T*9FD-"@T*(R!4:61Y('5P#0HC#0IR;2 M9B D>U-1
M3%=!4U1%?0T*<FT@+68@)'M344Q705-413%]#0H-"B,@5W)I=&4@=')A:6QE
M<B!D971A:6QS('1O(&QO9V9I;&4N#0HC#0IE8VAO("(D>U1/1$%9?3HD)#H^
M/CX^/B!&:6YI<VAE9"!#05!04&)L9"YS:" \/#P\/"(@/CX@)'M254Y,3T=]
"#0H^
begin 600 Controlfile.sql
M8V]N;F5C="!I;G1E<FYA; T*4U1!4E154"!.3TU/54Y4#0I#4D5!5$4_at_0T].
M5%)/3$9)3$4_at_4D554T4@4T54($1!5$%"05-%($-!4%!0(%)%4T543$]'4R!.
M3T%20TA)5D5,3T<-"B @("!-05A,3T=&24Q%4R S,@T*(" @($U!6$Q/1TU%
M34)%4E,@- T*(" @($U!6$1!5$%&24Q%4R Q,# P#0H@(" @34%824Y35$%.
M0T53(#@-"B @("!-05A,3T=(25-43U)9(#0P, T*3$]'1DE,10T*("!'4D]5
M4" Q("<O9&5V+W9X+W)D<VLO<F5S="]C87!P7W)D;S P)R @4TE:12 Q.3E-
M+ T*("!'4D]54" R("<O9&5V+W9X+W)D<VLO<F5S="]C87!P7W)D;S Q)R @
M4TE:12 Q.3E-+ T*("!'4D]54" S("<O9&5V+W9X+W)D<VLO<F5S="]C87!P
M7W)D;S R)R @4TE:12 Q.3E-#0I$051!1DE,10T*(" G+V1E=B]V>"]R9'-K
M+W)E<W0O8V%P<%]S>7,P,"<L#0H@("<O9&5V+W9X+W)D<VLO<F5S="]C87!P
M7W)B<S P)RP-"B @)R]D978O=G_at_O<F1S:R]R97-T+V-A<'!?9# Q7S P)RP-
M"B @)R]D978O=G_at_O<F1S:R]R97-T+V-A<'!?9# Q7S Q)RP-"B @)R]D978O
M=G_at_O<F1S:R]R97-T+V-A<'!?9# Q7S R)RP-"B @)R]D978O=G_at_O<F1S:R]R
M97-T+V-A<'!?9# R7S P)RP-"B @)R]D978O=G_at_O<F1S:R]R97-T+V-A<'!?
M9# R7S Q)RP-"B @)R]D978O=G_at_O<F1S:R]R97-T+V-A<'!?9# R7S R)RP-
M"B @)R]D978O=G_at_O<F1S:R]R97-T+V-A<'!?9# S7S P)RP-"B @)R]D978O
M=G_at_O<F1S:R]R97-T+V-A<'!?9# S7S Q)RP-"B @)R]D978O=G_at_O<F1S:R]R
M97-T+V-A<'!?9# S7S R)RP-"B @)R]D978O=G_at_O<F1S:R]R97-T+V-A<'!?
M9# T7S P)RP-"B @)R]D978O=G_at_O<F1S:R]R97-T+V-A<'!?9# T7S Q)RP-
M"B @)R]D978O=G_at_O<F1S:R]R97-T+V-A<'!?9# T7S R)RP-"B @)R]D978O
M=G_at_O<F1S:R]R97-T+V-A<'!?9# U7S P)RP-"B @)R]D978O=G_at_O<F1S:R]R
M97-T+V-A<'!?9# U7S Q)RP-"B @)R]D978O=G_at_O<F1S:R]R97-T+V-A<'!?
M9# U7S R)RP-"B @)R]D978O=G_at_O<F1S:R]R97-T+V-A<'!?9# V7S P)RP-
M"B @)R]D978O=G_at_O<F1S:R]R97-T+V-A<'!?9# V7S Q)RP-"B @)R]D978O
M=G_at_O<F1S:R]R97-T+V-A<'!?9# V7S R)RP-"B @)R]D978O=G_at_O<F1S:R]R
M97-T+V-A<'!?=&UP,# G+ T*(" G+V1E=B]V>"]R9'-K+W)E<W0O8V%P<%]T
M;7 P,2<L#0H@("<O9&5V+W9X+W)D<VLO<F5S="]C87!P7W1M<# R)RP-"B @
M)R]D978O=G_at_O<F1S:R]R97-T+V-A<'!?=&UP,#,G#0H[#0HC(%)E8V]V97)Y
M(&ES(')E<75I<F5D(&EF(&%N>2!O9B!T:&4_at_9&%T869I;&5S(&%R92!R97-T
M;W)E9"!B86-K=7!S+ T*(R!O<B!I9B!T:&4@;&%S="!S:'5T9&]W;B!W87,@
M;F]T(&YO<FUA;"!O<B!I;6UE9&EA=&4N#0I214-/5D52($1!5$%"05-%#0HC
M($1A=&%B87-E(&-A;B!N;W<@8F4@;W!E;F5D(&YO<FUA;&QY+@T*04Q415(@
:1$%404)!4T4_at_3U!%3B!215-%5$Q/1U,[#0ID
 |
 |