GoldenGate System 2: quick setup of a third-party one-way communication GoldenGate Environment

GoldenGate System 2: quick setup of a third-party one-way communication GoldenGate environment 1. Environment preparation (1) download the installation package and decompress it to ORACLE_BASE (2) modify the environment change [oracle @ irms156ogg] $ vi ~ /. Bashrc exportPATH = $ ORACLE_HOME/bin:/u01/app/ogg: $ PATH (3) create a subdirectory [oracle @ irms157 ogg] $ ggsci GGSCI (irms157) 1> create subdirs Creating subdirectories under currentdirectory/u01/app/ogg Parameter files/u01/app/ogg/dirprm: already exists Report files/u01/app/ogg/dirrpt: created Checkpoint files/u01/app/ogg/dirchk: created Process status files/u01/app/ogg/dirpcs: created SQL script files/u01/ap P/ogg/dirsql: created Database definitions files/u01/app/ogg/dirdef: created Extract data files/u01/app/ogg/dirdat: created Temporary files/u01/app/ogg/dirtmp: created Stdout files/u01/app/ogg/dirout: created Note: We recommend that all Goldengate operations be performed under the Goldengate installation directory. 2. Enable the management process (1) Create the management process parameter file GGSCI (irms156) 1> edit params mgr port 7809 (2) start manager GGSCI (irms156) 2> start mgr Managerstarted. GGSCI (irms156) 3> info mgr Manager isrunning (IP port irms156.7809 ). GGSCI (irms156) 4> info all Program Status Group Lag at Chkpt Time Since Chkpt manager running 3. Enable supplemental logs on the source end (1) oracle-specificinstallation steps Thefollowing steps are only required when GoldenGate will be capturi Ng data fromthe server. therefore it is only needed when you are installing GoldenGate forOracle as your <source> environment. [oracle @ irms157 ogg] $ sqlplus/nolog SQL> conn/as sysdba Connected. SQL> alter database add supplementallog data; Database altered. SQL> alter system switch logfile; System altered. (2) Enable Add supplemental logging for a specific mode object GGSCI (irms156) 9> dblogin useridsystem, passw Ord Lu123456; Successfully logged into database. GGSCI (irms156) 10> add trandatascott. emp; ERROR: No viable tables matchedspecification. (do not include a semicolon) GGSCI (irms156) 11> add trandatascott. emp Logging of supplemental redo dataenabled for table SCOTT. EMP. GGSCI (irms156) 13> add trandatascott. salgrade 2013-05-14 14:29:47 WARNING OGG-00869 No unique key is defined for table 'salgrad '. all viable columns Will be used to represent the key, but may notguarantee uniqueness. KEYCOLS may beused to define the key. logging of supplemental redo dataenabled for table SCOTT. SALGRADE. GGSCI (irms156) 14> add trandatascott. bonus 14:30:12 WARNING OGG-00869 No unique key is defined for table 'BONUS '. all viable columns will be used to represent the key, but may not guaranteeuniqueness. KEYCOLS may be Used to definethe key. logging of supplemental redo dataenabled for table SCOTT. BONUS. GGSCI (irms156) 15> add trandatascott. dept Logging of supplemental redo dataenabled for table SCOTT. DEPT. GGSCI (irms156) 16> info trandata scott. emp Logging ofsupplemental redo log data is enabled for table SCOTT. EMP. columnssupplementally logged for table SCOTT. EMP: EMPNO. 3. Data preparation (1) create a table on the target and the source (2) import the initial data from the source As scott mode is used in this experiment, each oracle database is installed by default, so no preparation is required. In step 2, you can use datapump, goldengatedirect load, SQL * loader, and other methods. 4. Configure source extraction (1) add extraction group Guangdong: GGSCI (irms156) 1> add extracteoragd, tranlog, begin now, threads 1 EXTRACT added. GGSCI (irms156) 2> info extracteoragd extract eoragd Initialized 2013-05-1414: 58 Status STOPPED Checkpoint Lag 00:00:00 (updated 00:00:13 ago) Log Read Checkpoint Oracle Redo Logs 14:58:05 Thread 1, seqno 0, RBA 0 SCN 0.0 (0) Log Read Checkpoint Oracle Redo Logs 14:58:05 Th Read 2, Seqno 0, RBA 0 SCN 0.0 (0) Jiangsu: GGSCI (irms156) 1> add extract eorajs, tranlog, begin now, threads 1 EXTRACT added. GGSCI (irms156) 2> info extract eorajs extract eoragd Initialized 2013-05-1414: 58 Status STOPPED Checkpoint Lag 00:00:00 (updated 00:00:13 ago) Log Read Checkpoint Oracle Redo Logs 14:58:05 Thread 1, seqno 0, RBA 0 SCN 0.0 (0) Log Read Checkpoint Oracle Redo Logs 201 3-05-14 14:58:05 Thread 2, Seqno 0, RBA 0 SCN 0.0 (0) (2) Create the extraction process parameter file Guangdong: GGSCI (irms156) 3> edit params eoragd extract eoragd userid system, PASSWORD Lu123456 RMTHOST 10.252.48.155, MGRPORT 7809 RMTTRAIL. /dirdat/gd TABLE scott. emp; TABLE scott. dept; TABLE scott. salgrade; TABLE scott. bonus; Jiangsu: GGSCI (irms156) 3> edit params eorajs extract eorajs userid system, PASSWORD Lu123456 RMTHOST 10.252.48.1 55, MGRPORT 7809 RMTTRAIL. /dirdat/js TABLE scott. emp; TABLE scott. dept; TABLE scott. salgrade; TABLE scott. bonus; (3) Define the GoldenGate trail add thetrail that will store the changes on the target. guangdong: GGSCI (irms156) 8> add RMTTRAIL. /dirdat/gd, extract eoragd rmttrail added. GGSCI (irms156) 9> info rmttrail * Extract Trail :. /dir/gd Extract: EORAGD Seqno: 0 RBA: 0 File Size: 5 M Jiangsu: GGSCI (irms1 56) 8> add RMTTRAIL. /dirdat/js, extracteorajs rmttrail added. GGSCI (irms156) 9> info rmttrail * Extract Trail :. /dir/js Extract: EORAGD Seqno: 0 RBA: 0 File Size: 5 M (4) Start the extraction process and verify Guangdong: GGSCI (irms156) 10> start extracteoragd Sending START request to MANAGER... extract eoragd starting GGSCI (irms156) 11> info extracteoragd, detail GGSCI (irms156) 12> view report eoragd Jiangsu: GGSCI (irms156) 10> start e Xtracteorajs Sending START request to MANAGER... extract eorajs starting GGSCI (irms156) 11> info extract eorajs, detail GGSCI (irms156) 12> view report eorajs 5. Configure the target checkpoint table (1) configure the global parameter file and add the checkpoint table GGSCI (irms155) 1> edit params. /globals checkpointtablescott. ggschkpt (2) activates the GLOBALS parameter file and exits directly before entering ggsci. GGSCI (irms155) 2> exit (3) Add the checkpoint table GGSCI (irms155) 1> dblogin useridsystem, password Lu123456 Successfully logged into database. GGSCI (irms155) 3> addcheckpointtable scott. ggschkpt Successfully created checkpoint tablescott. ggschkpt. 6. Configure the target end change shipping (1) add the replicat group Guangdong: GGSCI (irms155) 5> add replicat roragd, exttrail. /dirdat/gd, checkpointtablescott. ggschkpt REPLICAT added. jiangsu: GGSCI (irms155) 5> add r Eplicat rorajs, exttrail./dirdat/js, checkpointtablescott. ggschkpt REPLICAT added. Consistent with the source configuration. (2) Create the replicat parameter file Guangdong: GGSCI (irms155) 7> edit params roragd replicat roragd userid system, PASSWORD Lu123456 handlecollisions assumetargetdefs discardfile. /dirrpt/RORAGD. DSC, purge map scott. emp, TARGET scott. emp; MAP scott. salgrade, TARGETscott. salgrade; MAP scott. bonus, TARGET scott. bonus; MAP scott. dept, TARGET scott. dept; Jiangsu: GGSCI (irms155) 7> edit params rorajs replicat rorajs userid system, PASSWORD Lu123456 handlecollisions assumetargetdefs discardfile. /dirrpt/RORAJS. DSC, purge map scott. emp, TARGET scott. emp; MAP scott. salgrade, TARGETscott. salgrade; MAP scott. bonus, TARGET scott. bonus; MAP scott. dept, TARGET scott. dept; (3) start the replicat process Guangdong: GGSCI (irms155) 8> START replicatroragd Sending start request to MANAGER... replicat roragd starting GGSCI (irms155) 9> info replicat roragd replicat roragd Last Started 00:00:00 Status RUNNING Checkpoint Lag 00:00:09 (updated ago) Log Read Checkpoint File. /dirdat/gd000000 First Record RBA 0 GGSCI (irms155) 10> info all Program Status Group Lag at Chkpt Time Since Chkpt manager running replicat running roragd 00:00:00 Jiangsu: GGSCI (irms155) 8> start replicatrorajs Sending START request to MANAGER... replicat rorajs starting GGSCI (irms155) 9> info replicat rorajs replicat rorajs Last Started 00:00:00 Status RUNNING Checkpoint Lag 00:00:09 (updated ago) Log Read Checkpoint File. /dirdat/js000000 First Record RBA 0 GGSCI (irms155) 10> info all Program Status Group Lag at Chkpt Time Since Chkpt manager running replicat running rorajs 00:00:00 00:00:02