Gavinsoorma.com.au



Oracle GoldenGate 18c and GoldenGate Cloud Services WorkshopHands-on Lab Exercise 11Using MACROS and OBEY filesTRUNCATE the MYOBJECTS table in the PDB1 database [oracle@rac01 ~]$ sqlplus demo/oracle@pdb1SQL> truncate table myobjects;Table truncated.DROP and recreate the MYOBJECTS table in PDB2 database.SQL> conn demo/oracle@pdb2Connected.SQL> drop table myobjects;Table dropped.SQL> create table myobjects as select * from all_objects where 1=2;Table created.SQL> alter table myobjects add constraint pk_myobjects primary key (object_id);Table altered.Create the diroby and dirmac directories. [oracle@rac01 ~]$ cd /acfs_oh/app/goldengate[oracle@rac01 goldengate]$ mkdir dirmac[oracle@rac01 goldengate]$ mkdir dirobyCreate the Macro.[oracle@rac01 ]$ cd dirmac/[oracle@rac01 dirmac]$ vi macrolib1.macMACRO #tables_for_extractBEGINSOURCECATALOG pdb1TABLE demo.*;END; [oracle@rac01 dirmac]$ vi macrolib2.macMACRO #map_tablesBEGINSOURCECATALOG pdb2MAP pdb1.demo.*, TARGET pdb2.demo.*;END;Create the parameter files.[oracle@rac01 dirmac]$ cd ../dirprm[oracle@rac01 dirprm]$ vi ext1.prmINCLUDE ./dirmac/macrolib1.macEXTRACT ext1SETENV (ORACLE_HOME='/acfs_oh/product/12.2.0/dbhome_1')USERIDALIAS oggadmin_cdb1EXTTRAIL ./dirdat/ogg1/lt#tables_for_extract()[oracle@rac01 dirprm]$ vi pump1.prmINCLUDE ./dirmac/macrolib1.macEXTRACT pump1SETENV (ORACLE_HOME='/acfs_oh/product/12.2.0/dbhome_1')USERIDALIAS oggadmin_cdb1RMTHOST 192.168.56.130, MGRPORT 7809RMTTRAIL ./dirdat/ogg2/rt#tables_for_extract()[oracle@rac01 dirprm]$ vi rep3.prmINCLUDE ./dirmac/macrolib2.macREPLICAT rep3USERIDALIAS oggadmin_pdb2DBOPTIONS INTEGRATEDPARAMS (max_sga_size 1024, parallelism 2)#map_tables()Create the OBEY file.[oracle@rac01 dirprm]$ cd ../diroby/[oracle@rac01 diroby]$ vi ogg1.obystart managerdblogin useridalias oggadmin_cdb1stop extract *stop replicat *shell sleep 30start extract ext1start extract pump1start replicat rep3shell sleep 30info allExecute OBEY file[oracle@rac01 diroby]$ cd ..[oracle@rac01 goldengate]$ ./ggsciOracle GoldenGate Command Interpreter for OracleVersion 18.1.0.0.0 OGGCORE_18.1.0.0.0_PLATFORMS_180928.0432_FBOLinux, x64, 64bit (optimized), Oracle 12c on Sep 29 2018 04:22:21Operating system character set identified as UTF-8.Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.GGSCI (rac01.localdomain) 1> OBEY ./diroby/ogg1.obyGGSCI (rac01.localdomain) 2> start managerTransparent Integration with XAG is enabled. Sending the command START MANAGER to XAG...2019-01-31 23:36:57 INFO OGG-02407 CRS/XAG status: CRS-2676: Start of 'xag.ogg_ha.goldengate' on 'rac01' succeeded.GGSCI (rac01.localdomain) 3> dblogin useridalias oggadmin_cdb1Successfully logged into database CDB$ROOT.GGSCI (rac01.localdomain as C##oggadmin@cdb1_2/CDB$ROOT) 4> stop extract *Sending STOP request to EXTRACT EXT1 ...Request processed.Sending STOP request to EXTRACT PUMP1 ...Request processed.GGSCI (rac01.localdomain as C##oggadmin@cdb1_2/CDB$ROOT) 5> stop replicat *REPLICAT INITREP2 is already stopped.REPLICAT INITREP3 is already stopped.Sending STOP request to REPLICAT REP1 ...STOP request pending completion of recovery mode.REPLICAT REP3 is already stopped.GGSCI (rac01.localdomain as C##oggadmin@cdb1_2/CDB$ROOT) 6> shell sleep 30GGSCI (rac01.localdomain as C##oggadmin@cdb1_2/CDB$ROOT) 7> start extract ext1Sending START request to MANAGER ...EXTRACT EXT1 startingGGSCI (rac01.localdomain as C##oggadmin@cdb1_2/CDB$ROOT) 8> start extract pump1Sending START request to MANAGER ...EXTRACT PUMP1 startingGGSCI (rac01.localdomain as C##oggadmin@cdb1_2/CDB$ROOT) 9> start replicat rep3Sending START request to MANAGER ...REPLICAT REP3 startingGGSCI (rac01.localdomain as C##oggadmin@cdb1_2/CDB$ROOT) 10> shell sleep 30GGSCI (rac01.localdomain as C##oggadmin@cdb1_2/CDB$ROOT) 11> info allProgram Status Group Lag at Chkpt Time Since Chkpt XAG MANAGER RUNNING MANAGED/xag.ogg_ha.goldengate/rac01EXTRACT RUNNING EXT1 01:34:40 00:00:03 CRITICAL EXTRACT RUNNING PUMP1 00:00:00 00:00:03 CRITICAL REPLICAT STOPPED INITREP2 00:00:00 278:58:34 NON-CRITICAL REPLICAT STOPPED INITREP3 00:00:00 278:58:33 NON-CRITICAL REPLICAT ABENDED REP1 00:00:00 249:35:32 NON-CRITICAL REPLICAT RUNNING REP3 00:00:00 00:00:25 NON-CRITICAL View the EXT1 Report File and note that the macro has been executed and that the appropriate tables have been selected for processing by the extractGGSCI (rac01.localdomain as C##oggadmin@cdb1_2/CDB$ROOT) 17> view report ext1……2019-01-31 23:38:29 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry pdb1.demo.*): TABLE "PDB1"."DEMO"."MYOBJECTS".2019-01-31 23:38:33 INFO OGG-06509 Using the following key columns for source table PDB1.DEMO.MYOBJECTS: OBJECT_ID.2019-01-31 23:38:33 INFO OGG-06508 Wildcard MAP (TABLE) resolved (entry pdb1.demo.*): TABLE "PDB1"."DEMO"."MYOBJECTS". ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download