• No results found

46948496 Golden Gate Tutorial

N/A
N/A
Protected

Academic year: 2021

Share "46948496 Golden Gate Tutorial"

Copied!
26
0
0

Loading.... (view fulltext now)

Full text

(1)c c  

(2)       c c    

(3)  

(4)  

(5) 

(6)         

(7)         

(8)    

(9)   

(10)  

(11)  

(12) 

(13)  

(14)  ! "   

(15)  

(16)  

(17)   

(18) # 

(19)  $ %  &  '( %

(20)    

(21)   %    

(22)   )

(23)   %

(24)     .     

(25)     

(26)      c c 

(27)   

(28)  ". *source: Oracle GoldenGate Administration Guide^ . .

(29)   +!

(30) 

(31)   

(32)   

(33)   

(34)     

(35) , 

(36)  

(37) - 

(38)    

(39) 

(40) 

(41)   

(42)          

(43)  

(44)  

(45) c c

(46)   

(47)    

(48) 

(49) "   +, 

(50)  

(51)  

(52)   

(53)      

(54)     c c"   

(55)  

(56)   

(57)       

(58) .  

(59) 

(60) "+       

(61)       

(62)   

(63)  "   +- 

(64)  

(65)   

(66)   

(67)  

(68)           

(69)    

(70)  ", 

(71)  

(72)   - 

(73)     

(74) 

(75)     &  

(76) . "    +&  

(77)   

(78) 

(79)   

(80)   

(81)     

(82)     !

(83) * &  

(84) ^

(85)   

(86)   

(87)   * &  

(88) ^" 

(89)    

(90)    

(91)  +&/0 / 

(92)   

(93)  

(94) 

(95) 

(96) 

(97)  - 

(98)  "    +

(99)  

(100)  

(101)    c c

(102) 

(103)  

(104)        

(105) 

(106)  

(107) 

(108) , 

(109)  - 

(110)      "   

(111)     

(112)      

(113)     

(114)    "         , 

(115)   +

(116) 

(117)  - +

(118)     

(119)   "   /  

(120)   

(121)  

(122)        

(123)  

(124)  "+       /    , 

(125)    +&/0 /  

(126)  

(127)  

(128) ")/   

(129) /

(130) 

(131) , 

(132)   

(133)  

(134)   +

(135)  

(136)  

(137) /     

(138) 

(139)  - +

(140)   

(141)   "    / , 

(142)  

(143)   

(144)   

(145)   

(146)   

(147)    

(148)   

(149)  

(150)   "     

(151)  

(152) 

(153)  

(154)     

(155) 

(156) 

(157)  

(158)  

(159)    

(160) 

(161) "/         

(162) 

(163)     

(164) 

(165)  

(166)     

(167)   

(168) 

(169)    

(170) 

(171) "   )

(172)  

(173)      , 

(174)  

(175)    

(176)   

(177)  

(178)      *

(179)  

(180) 

(181) ! ^

(182) 

(183)  c c1

(184) (  !  *1(!^

(185)  

(186) *

(187)  +

(188) ^ 

(189) 

(190) # 

(191)     , 

(192)    

(193)    " c  + 

(194)  

(195)  

(196) , 

(197)  - 

(198)       2      

(199)  

(200)  "3

(201)     

(202)  

(203)    

(204)  

(205)  - 

(206)  ".

(207) (

(208)  

(209)      

(210)    

(211) , 

(212)  

(213) -  

(214)  

(215)

(216)   

(217) 

(218)    

(219)    *

(220)  - ^ 

(221)     

(222)  "  c c     

(223)

(224)      +   

(225)    

(226)  c c -',4

(227) " )

(228) 

(229)   

(230)  

(231) 

(232)       c c

(233) " c c 

(234)    +5 

(235) 

(236) 

(237)    

(238) # 

(239)  

(240) 

(241)  ! " #$% &  /

(242)  / 6

(243)  3  !

(244) 7

(245)  89:2:;" +  6

(246)  c c 

(247)  !/ 

(248)   9:2:;<  

(249)    

(250) 

(251)  ==   6

(252)  c c1=>";">" 

(253)  

(254)  ==:; -'4">< ? ' (

(255) )

(256) *+!,

(257) &'  (

(258) $1=9=4@2>=". $ A

(259) (4>A :;A

(260) ==A:;A=>";">"=@A>>"

(261)  ? !" -. /*,.01. 

(262)

(263) .01% ."

(264) ,&1&,&

(265) +.,,&  ? 234256 ,

(266) 6 6 ? .78.234.26 %56 ,

(267) 6 6 ?  

(268)  c c&  

(269) 

(270) 

(271) 

(272) 

(273)   1

(274)  =>";">"=@ >>   :;:;* .^

(275)  == =B>>@C$4=$9 & 

(276) *&^=@@4>>@

(277)  0

(278)   "(

(279)  

(280)  

(281) " cc& *

(282) C;:"  ^=D cc& *

(283) C;:"  ^=D/97/ &

(284)  

(285)  

(286)   

(287) 

(288)

(289) 

(290)  

(291) 0 >=00

(292)  0

(293)  0=="">0 A= /

(294) 

(295)  0 >=0

(296)  0 0

(297) 

(298) $

(299)  -

(300)  0 >=0

(301)  0 0

(302)

(303) $

(304)  &   0 >=0

(305)  0 0

(306) $

(307)    0 >=0

(308)  0 0

(309) $

(310)  ) 

(311)   

(312)   c c!

(313)  , 

(314)  - 

(315)   ") 

(316)   

(317) 

(318)  

(319)  

(320)  

(321) E    

(322) F

(323)   

(324)   

(325) ccA)5,- 

(326) 

(327) # 

(328) 

(329)  " D %. - :6 ,6 6" 6.,

(330) &%-; ',,< D   . $   - %#. $  - %. C  #%G H 

(331) 

(332) " D  =   . $ G c

(333)  ".

(334) D #   #=#% . $ G c

(335)  " D  % . $ G c

(336)  " D -%>#% . $ G c

(337)  " D   %.-%> . $ G c

(338)  " D    .-  . $ < c

(339)  " )  

(340) c c 

(341) E 

(342)       

(343)    ?  

(344)  c c&  

(345) 

(346) 

(347) 

(348) 

(349)   1

(350)  =>";">"=@ >> ( 84 :;* .^

(351)  == =B>>@C$4;$=: & 

(352) *&^=@@4>>@

(353)  0

(354)   "(

(355)  

(356)  

(357) " cc& * >>B^=D7c?9/. $ =//@. $        " )      

(358)    

(359)

(360)

(361) 

(362)   

(363) , 

(364)  

(365)  2 >=>2>2>9=C$4=$=cc,---=@>5     "+    

(366)  

(367)    

(368)

(369)      

(370) 

(371)  " >=>2>2>9=C$4=$=cc,---=@>/-&,(,5 5c" D7//9?c 9?/G  

(372)  c c  A  -     +

(373)  c c!

(374) 

(375) 

(376)   

(377)       

(378)  

(379)  c c

(380)   

(381)  

(382) 

(383) "+!

(384) 

(385)      

(386)   

(387)   

(388)     

(389)    

(390)

(391)  

(392) 

(393) E      

(394) c c

(395)    , 

(396)  - " (

(397)     

(398)   c c 

(399) &  

(400)  *cc& ^     !

(401) 

(402) 

(403)  /c + 

(404) 

(405) 

(406)     /-+  

(407)     

(408) 

(409) 

(410)   

(411) "+ 

(412)  B9>@ 

(413)    

(414) 

(415)   

(416) 

(417) 

(418) 

(419)    

(420)  

(421)  "   

(422) 

(423)    

(424) 

(425) 

(426) (H++(-+      

(427)  , 

(428)  - 

(429)   !

(430)  

(431)  ".

(432) +H,- /()-

(433) 

(434) 

(435) # 

(436)  c c 

(437)    

(438)   

(439)  

(440) 

(441) !

(442) *, 

(443)  0- ^  

(444) 

(445) 

(446)  

(447) " +!

(448) 

(449)      

(450)  

(451)  c c   

(452)  /H-c,,8+-(&+

(453) 

(454) "H H,&',&I/ 5+   

(455)  

(456)       

(457)   " +     

(458) 

(459) 

(460)  J

(461)  K

(462) C;: L?&6  

(463)  c c&  

(464) 

(465) 

(466) 

(467) 

(468)   1

(469)  =>";">"=@ >>   :;:;* .^

(470)  == =B>>@C$4=$9 & 

(471) *&^=@@4>>@

(472)  0

(473)   "(

(474)  

(475)  

(476) " cc& D/c B9>@ 9/ A 

(477) //@ A 

(478)  9cB/0 >=0

(479)  0 0

(480) 0 9/2C?/ +

(481)     

(482) c&   /?c/ ?c" 

(483)      !

(484)   ?D?c  cc& * >>B^;D -   !

(485)  

(486) * /

(487)  >>B"B9>@^"  c c  1  -       +   

(488)   c c     

(489)  

(490) 

(491)  

(492)  

(493)  ==  -' 

(494)    

(495)  == 

(496)   ( 8

(497) " +/-H&+'  

(498)  B

(499)   

(500)     

(501)    

(502) 

(503)  ") B

(504)    

(505) 

(506)   

(507)   c c 

(508)    " /  =^     : 

(509) E cc& *

(510) C;:"  ^4DB 

(511) =/9/7 ,8+-(&+"      

(512)   

(513)    

(514)        -!*    

(515) 

(516)    ^    

(517) H-&, +(,  " ^   - -    

(518)  B$  

(519)  

(520)  9/6//@$  

(521)    

(522) 

(523) 

(524) 

(525) , 

(526)  * . 

(527)  

(528) 

(529)  ^ 2/$+  /

(530)  

(531)   

(532)    c$

(533) 

(534) !

(535) 

(536)   

(537)  7$     

(538)  

(539)  "+      

(540)     

(541)  

(542)  

(543)    

(544)       

(545)   ".

(546) cc& *

(547) C;:"  ^:D/ 

(548)  ,8+-(&+ = H,-  A 

(549) /()- A 

(550)  -!+'+ >>B!c-/-+B9>@ -!++(I

(551)  c-H/  +(, "

(552)   G   C^     >: E       

(553)  

(554) /,& (-H5 cc& * >>B^=D =/9? -,/ &(+" ;^   - -   =  -,/ &(+$ - 

(555) 

(556) 

(557)   H,- 0/()-$ 

(558)  

(559) -  

(560) *  

(561)  

(562)  

(563)  ^ (H!,+(-c,+,3$  

(564)  

(565) 

(566)     

(567)    

(568) 

(569)  !(/$c c 

(570)   

(571) 

(572) 

(573) 

(574) 

(575)  

(576) 

(577)            " + 

(578) 

(579) 

(580)    

(581) 

(582)          cc& * >>B^D/  60 >=0

(583)  0 

(584) 0 0

(585) 

(586) 0

(587) ;"

(588) 7J5L -,/ &(+  H,-  A 

(589) /()- A 

(590)  (H!,+(-c,+,3 !(/ "  

(591) +(-c,+ "  

(592) G /  D F -   G &H5+*M^ NNN2 B   D F -   < &H5+*M^ NNN2 > /  4^/      >  # )  

(593)    = 

(594) "        

(595)  

(596)   

(597) 

(598)      ")     

(599) - 

(600)    

(601)    , 

(602)     

(603)  

(604)   " /  cc& *

(605) C;:"  ^=:D/B 

(606) .

(607) +(-+

(608) #   !(5(c,-O ,8+-(&+(= 

(609)  cc& *

(610) C;:"  ^9D -   

(611)  ,8+-(&+(= 

(612) >=>2>2====$CC -H55 5c &  5 (  -&  +'"/-H&+ >=>2>2====$CC$=:-

(613) B + H-&, +(, cc& *

(614) C;:"  ^@D -   

(615)  ,8+-(&+(= 

(616) >=>2>2====$CC +//, &  5 (  -&  +'"/-H&+ >=>2>2====$CC$=: G + H-&, +(,   D F -   < &H5+*M^ NNN2 B  c c  *  -    #  '  

(617) 

(618) 

(619)  

(620)    

(621) c c

(622) 

(623)   

(624)  "   

(625)    c c   

(626) .    

(627)  

(628) *

(629)  ==  ^

(630) 

(631) 

(632)  

(633)  *

(634)  == ( 8^"+ 

(635)  ,!/&++    

(636)   ,!/

(637)  ' " + 

(638)   $ &

(639) c c&   &

(640) , 

(641)  

(642)  &

(643) 

(644) 

(645) 

(646)  , 

(647)  

(648)  &

(649) +

(650)  &

(651) - 

(652)  &

(653) 

(654) 

(655) 

(656)  - 

(657)   c c> % c c   &        

(658) 

(659)  

(660) - 

(661)   

(662) 

(663)  

(664)  

(665)

(666)

(667) 

(668)    " + 

(669)  

(670) 

(671) 

(672)        

(673)    

(674)   

(675)    

(676) 

(677)

(678)   " )  

(679)  &     - 

(680)  

(681)   

(682) c c   "   

(683) 

(684)  

(685)  

(686) c(")   c(

(687) 

(688) 2C?7         - 

(689)   , +/(-(! " cc& * >>B^D/&6c7/ cc&',!(ccA)5,- 2C?7cc/.@?&2C7.

(690) cc& * >>B^;D7c?9/. $ =//@. $        " cc& * >>B^:D2C?7cc/.@?&2C7    

(691)    ccA)5,-"&'I/+("  $0 >=0

(692)  0 

(693) 0 DH . $ 6. $   M/ $- =="=">":">2/

(694)    ! 39>@$>$=@>=> & 

(695) * ^=@9>>B

(696)  "(

(697)  

(698)  

(699) " &   $ 

(700)   ==,

(701) 

(702)  , - =="=">":">2:;/

(703)    )/

(704)  (/!-(  +      D>% 55 P+ 22222222222222222222222222222222222222222222222222222222222222222222222222222 c-H/A5(!,5+5H1(-&'(-*9^ c-H/AI,Q5+5H5H!,-*=@^ ,55H!,-*=>^ -(5+5H5H!,-*=@^ (H +A+1(-&'(-*@^ &-,(+,A+5+5H(+, (+AH/(+,A+5+5H(+, &H--,5+A -5+5H1(-&'(-*44^    c  cc& *

(705) C;:"  ^=DB

(706) =?c=7c??@ ,8+-(&+"     ) 

(707) 

(708) F  

(709)   GoldenGate software location on the target system  

(710) 

(711)  

(712) "  -  : ;  - 

(713)   

(714)  

(715)    cc& *

(716) C;:"  ^D6 ,

(717) 6 6 -$ 6 6 6 = B

(718)  -!++-( "    - -     

(719)  cc& *

(720) C;:"  ^CD/

(721)  ,8+-(&+ = H,-  A 

(722) /()- A 

(723)  -!+'+ >>B!c-/-+B9>@ -!++-( 0 >=0

(724)  0 

(725) 0 0

(726) 0

(727)  +(, "G ?c/8/       cc& * >>B^BD 

(728) =B6 ,

(729) 6 6 -$ 6 6 6  -,/ &(+" 5 ,8++-(      

(730)     

(731)    -!++-( 

(732) 

(733)   

(734) 

(735) 

(736) 

(737)  

(738)   

(739)   

(740)   "    - -     = 

(741)  cc& * >>B^9D/ 

(742) .

(743) -,/ &(+

(744) = (H!,+(-c,+,3 H,-  A 

(745) /()- A 

(746)  !(/ "+(-c,+ "G ?/9 /    cc& *

(747) C;:"  ^=:D/B

(748)  +(-+

(749) #   !(5(c,-O ,8+-(&+,8+= 

(750)  cc& *

(751) C;:"  ^=BD/9/B

(752)  ,8+-(&+,8+=$-H55 5c cc& *

(753) C;:"  ^=:D?DB

(754)  ,8+-(&+,8+= 

(755) >=>2>2>9=;$B -H55 5c &  >>$>>$>>* >>$>>$>@ ^  -&  

(756)  -    >=>2>2>9=;$B$;9# =;4-(B;;9> ?c /    cc& * >>B^=D/ 

(757)  +(-+

(758) #   !(5(c,-O -,/ &(+-,/= 

(759)  cc& * >>B^D?D 

(760)  -,/ &(+-,/= 

(761) >=>2>2>9=;$44 -H55 5c &  >>$>>$>>* >>$>>$>= ^  -&  36 ,

(762) 6 6 -$ 6 6 6 ,,,,,

(763)  >=>2>2>9=;$B$4B":>>;4-(=>;4 5 $

(764)  

(765)   R

(766) S* 

(767) 

(768) ^ 9/?@/I ?/9 D  0

(769)  &  " D9/3++++@23;C?c;< =

(770)  " D&!! +G &  " ?c D//D@23;C?c;< ( NNN2 ++++  c c  0  -     +/ *    

(771)  , 

(772)  

(773) / ^     

(774) , 

(775)  

(776)  

(777)  

(778)   ")/    .

(779) , 

(780)  

(781)  

(782)   

(783)  

(784)    

(785)     +&/0 /")/   

(786) , 

(787)  

(788)  

(789)    

(790)  

(791) 

(792) / 

(793) 

(794) 

(795)  

(796) 

(797)  

(798)   

(799)   

(800)   " +      

(801)    

(802) 

(803)       

(804)      , 

(805)  

(806)  

(807)    

(808) 

(809)     

(810) 

(811) "(

(812)  

(813)    , 

(814)  

(815)   

(816) *^"( 

(817)     

(818)  

(819)  

(820) 

(821)   

(822) 

(823) / "  .  

(824)   

(825)  

(826) 

(827)     

(828) 

(829) 

(830)      

(831)    

(832)     

(833)   

(834) "     cc& * >>B^=DB

(835) =?c=7c??@ ,8+-(&+"      H (,8+-(   

(836)  

(837)  

(838)   

(839)  , 

(840)  

(841)  

(842)    

(843) / 

(844)  ")   

(845)  /

(846) 

(847) , 

(848)  

(849) E 

(850)  = cc& * >>B^CDB6 ,

(851) 6 6 -$ 6 6 6=B

(852)  ,8++-( "     

(853)   

(854) / 

(855)  ,8++-( H-&,

(856)       

(857)  

(858) / 

(859)   cc& * >>B^;DB =B/9 6 ,

(860) 6 6 -$ 6 6 6 ,8+-(&+"    - -   #   cc& * >>B^4D/

(861)  60 >=0

(862)  0 

(863) 0 0

(864) 

(865) 0 ="

(866) 7J5L ,8+-(&+ = H,-  A 

(867) /()- A 

(868)  ,8++-( 0 >=0

(869)  0 

(870) 0 0

(871) 0 +(,!5 +-")-IA/(5G / -#   -      # H -!++-(       

(872)  

(873)    / 

(874)  

(875)   

(876) 

(877)  

(878)   cc& * >>B^:D6 ,

(879) 6 66 6 =B  -!++-( "    - -    5 2

(880) 

(881) /(+'-H    

(882) /      

(883) 

(884)  E  

(885)     

(886)  

(887)  

(888) 

(889) 

(890) " cc& * >>B^D/  60 >=0

(891)  0 

(892) 0 0

(893) 

(894) 0 "

(895) 7J5L.

(896) ,8+-(&+  H,-  A 

(897) /()- A 

(898)  -!+'+

(899) C;:!c-/-+B9>@ -!++-( 0 >=0

(900)  0 0

(901) 0

(902)  /(+'-H +(,!5 +-")-IA/(5G ?c/8/     +,8++-(        

(903)  

(904)      -!++-(    

(905) / 

(906)   

(907)   " cc& *

(908) C;:"  ^D 

(909) =B6 ,

(910) 6 66 6  -,/ &(+"    - -    cc& *

(911) C;:"  ^CD/ 

(912)  -,/ &(+

(913) = (H!,+(-c,+,3 H,-  A 

(914) /()- A 

(915)  !(/!5 +-")-IA/(5+(-c,+!5 +-")-IA/(5G ?/9  #= $    " cc& * >>B^CD/B

(916)  +(-+

(917) #   !(5(c,-O ,8+-(&+,8+= 

(918)  cc& * >>B^;D/B  +(-+

(919) #   !(5(c,-O ,8+-(&+/H!/ 

(920)  cc& * >>B^4D -  

(921)  ,8+-(&+,8+= 

(922) >=>2>2=9==$C -H55 5c &  >>$;>$4* >>$>>$>@ ^  -&  

(923)  -    >=>2>2=9=>$;$=@# B:=-(=4>9:>@: cc& * >>B^:D?DB  ,8+-(&+/H!/ 

(924) >=>2>2=9==$C -H55 5c &  >>$>>$>>* >>$>>$> ^  -&  30 >=0

(925)  0 

(926) 0 0

(927) 0>>>>>> >=>2>2=9==$=4$=>">>>>>>-(4;>C ? 2 

(928)   

(929) 

(930)  +

(931) F 0 >=0

(932)  0 

(933) 0 0

(934) 0>>>>>> ?c/8/ /    cc& *

(935) C;:"  ^;D/ 

(936)  +(-+

(937) #   !(5(c,-O -,/ &(+-,/= 

(938) .

(939) cc& *

(940) C;:"  ^4D/9/ 

(941)  -,/ &(+-,/=$-H55 5c  c c  G  -  #  '    

(942) 

(943)    

(944) 

(945) !     

(946) c c

(947)  

(948)  

(949)  " ( 

(950)  

(951) 

(952) #       

(953) 

(954)  

(955) "  -  $  -   #$ c c -$ $ " +  

(956)    

(957) ccA)5,- 

(958) 

(959)  

(960) 

(961) # 

(962) 

(963)  

(964)    

(965) 

(966) 

(967)  

(968) "  5 2

(969) 

(970)   Q(  DJ > .  !

(971) 

(972)   

(973)   Q 

(974) 

(975)   

(976) c c  E  " 5+,$+  

(977) 

(978) 

(979)  

(980)  

(981) " 5+,$ 

(982)   

(983)  

(984)    "  ,

(985) c c $cc/.@?  !

(986) 

(987)   

(988)  

(989) 

(990)   

References

Related documents

Chair Bennett opened the meeting giving a background on the how and why the Utilities Board has begun to look at the governance structure and governance process of the Utilities

The mt-tRNA sequences from the different species were aligned to the complementary mt- tRNA sequence from the rCRS and these alignments were then used to look for nucleotide changes

Ruoning [3-4] considered the rationality of metric definition and discussed the problem for least squares fitting of fuzzy-value data, which are expressed as fuzzy numbers, and

Journal of Information Technology Management Volume XXI, Number 1, 2010 43 Table 11: Business Performance Outcome:.. Operational Efficiency Mean Std

The emergence of an integrative model that addresses the impact of different ERP deployments on performance and national culture on CSFs would enable ERP implementing firms to

With the discussions in literature review, the research framework is developed to examine relationship between system quality, information quality, vendor/consultant

Reference [13] examines how firm-level strategic resources, such as purchasing teams, influence the exploitation of e-business technologies and the relationship between e-business