我们在搭建ogg的时候，通常需要先对目标库进行初始化，，那么初始化的方式很多。现在介绍ogg自己的初始化方式。
测试环境：Souce DB:OS：redhat 6.3Name:zbdba1DB:11.2.0.4OGG:11.2.1.0.1Target DB:OS：redhat 6.3Name:zbdba2DB:11.2.0.4OGG:11.2.1.0.1这里着重介绍 Initial Load，具体安装配置请参考：Source and target DB：配置并开启manager进程：GGSCI (zbdba1) 1> view param mgrport 7839DYNAMICPORTLIST 7840-7914USERID OGG,PASSWORD oggAUTORESTART REPLICAT *, RETRIES 5, WAITMINUTES 3PURGEOLDEXTRACTS ./DIRDAT/*,MINKEEPDAYS 3PURGEDDLHISTORY MINKEEPDAYS 7,MAXKEEPDAYS 10,FREQUENCYMINUTES 30PURGEMARKERHISTORY MINKEEPDAYS 7,MAXKEEPDAYS 10LAGREPORTHOURS 1LAGINFOMINUTES 30LAGCRITICALMINUTES 45GGSCI (zbdba2) 11> view param mgrport 7839DYNAMICPORTLIST 7840-7914USERID OGG,PASSWORD oggAUTORESTART REPLICAT *, RETRIES 5, WAITMINUTES 3PURGEOLDEXTRACTS ./dirdat/*,MINKEEPDAYS 3PURGEDDLHISTORY MINKEEPDAYS 7,MAXKEEPDAYS 10,FREQUENCYMINUTES 30PURGEMARKERHISTORY MINKEEPDAYS 7,MAXKEEPDAYS 10LAGREPORTHOURS 1LAGINFOMINUTES 30LAGCRITICALMINUTES 45 start managerSource:配置initload 抽取进程：GGSCI (zbdba1) 7> info allProgramStatusGroupLag at Chkpt Time Since ChkptMANAGERRUNNINGGGSCI (zbdba1) 8>GGSCI (zbdba1) 8>GGSCI (zbdba1) 8> add extract initload,sourceistableEXTRACT added.GGSCI (zbdba1) 9> info allProgramStatusGroupLag at Chkpt Time Since ChkptMANAGERRUNNINGGGSCI (zbdba1) 10> edit param initloadEXTRACT initloadUSERID ogg, PASSWORD oggRMTHOST 192.168.56.61, MGRPORT 7839RMTTASK replicat, GROUP reploadTABLE zbdba.test;Target:配置repload 复制进程GGSCI (zbdba2) 9> add replicat repload,specialrunREPLICAT added.GGSCI (zbdba2) 10>GGSCI (zbdba2) 10>GGSCI (zbdba2) 10>GGSCI (zbdba2) 10> edit param reploadREPLICAT reploadUSERID ogg, PASSWORD oggASSUMETARGETDEFSMAP zbdba.test, TARGET zbdba.test;source:SQL> conn zbdba/oracle;Connected.SQL> select count(1) from test; COUNT(1)———-86315target:SQL> select count(1) from test; COUNT(1)———-0source:开启抽取进程：GGSCI (zbdba1) 15> start extract initloadSending START request to MANAGER …EXTRACT INITLOAD starting查看日志：2015-02-27 02:18:25 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (ogg): start extract initload.2015-02-27 02:18:25 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host zbdba1 (START EXTRACT INITLOAD ).2015-02-27 02:18:25 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT INITLOAD starting.2015-02-27 02:18:25 INFO OGG-01017 Oracle GoldenGate Capture for Oracle, initload.prm: Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.2015-02-27 02:18:25 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, initload.prm: EXTRACT INITLOAD starting.2015-02-27 02:18:25 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, initload.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.2015-02-27 02:18:29 WARNING OGG-00869 Oracle GoldenGate Capture for Oracle, initload.prm: No unique key is defined for table 'TEST'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.2015-02-27 02:18:29 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, initload.prm: Virtual Memory Facilities for: COManon alloc: mmap(MAP_ANON) anon free: munmapfile alloc: mmap(MAP_SHARED) file free: munmaptarget directories:/ogg/dirtmp.2015-02-27 02:18:29 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, initload.prm: EXTRACT INITLOAD started.查看抽取情况：GGSCI (zbdba1) 18> info initloadEXTRACT INITLOAD Last Started 2015-02-27 02:18 Status RUNNINGCheckpoint LagNot AvailableLog Read Checkpoint Table ZBDBA.TEST2015-02-27 02:19:25 Record 43671TaskSOURCEISTABLEGGSCI (zbdba1) 19> info initloadEXTRACT INITLOAD Last Started 2015-02-27 02:18 Status RUNNINGCheckpoint LagNot AvailableLog Read Checkpoint Table ZBDBA.TEST2015-02-27 02:19:35 Record 54025TaskSOURCEISTABLEGGSCI (zbdba1) 20> ! info initloadEXTRACT INITLOAD Last Started 2015-02-27 02:18 Status STOPPEDCheckpoint LagNot AvailableLog Read Checkpoint Table ZBDBA.TEST2015-02-27 02:20:16 Record 86315TaskSOURCEISTABLE发现已抽取完成target:查看日志：2015-02-27 02:18:54 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, repload.prm: REPLICAT REPLOAD starting.2015-02-27 02:18:54 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, repload.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.2015-02-27 02:18:55 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, repload.prm: Virtual Memory Facilities for: COManon alloc: mmap(MAP_ANON) anon free: munmapfile alloc: mmap(MAP_SHARED) file free: munmaptarget directories:/ogg/dirtmp.2015-02-27 02:18:55 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, repload.prm: REPLICAT REPLOAD started.2015-02-27 02:18:59 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repload.prm: No unique key is defined for table 'TEST'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.2015-02-27 02:20:21 INFO OGG-00994 Oracle GoldenGate Delivery for Oracle, repload.prm: REPLICAT REPLOAD stopped normally.发现repload进程已经自动启动并且复制完毕自动停止了。查看数据库表：SQL> select count(1) from test; COUNT(1)———-86315已经完成初始化
坚韧是成功的一大要素，只要在门上敲得够久够大声，终会把人唤醒的。
