New Features for DBA’s

Subscribe to Posts by Email


 

Subscriber Count

    701

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

Example 4: Configuring Online Change Synchronization after initial load

In previous example we just loaded the table and that task is only one time.

In this example , we will configure a continuous synchronisation for the same myobj table.

  • Create a GoldenGate Checkpoint table
  • Create an Extract group
  • Create a parameter file for the online Extract group
  • Create a Trail
  • Create a Replicat group
  • Create a parameter file for the online Replicat group
On Source Steps On Target Steps
    Create CheckPoint Table

ggsci> EDIT PARAMS ./GLOBALS

###add the following two lines global params file ###

GGSCHEMA GGS_OWNER

CHECKPOINTTABLE GGS_OWNER.CHKPTAB

ggsci> stop mgr
Create a Primary Extract Group

ggsci> ADD EXTRACT ext2, TRANLOG, BEGIN NOW

ggsci> ADD RMTTRAIL /u01/ggt_target/dirdat/rt, EXTRACT EXT2

ggsci> EDIT PARAMS ext2

###add the following lines in params file###

EXTRACT ext2

USERID ggs_owner, PASSWORD ggs_owner

RMTHOST targethost, MGRPORT 7809

RMTTRAIL /u01/ggt_target/dirdat/rt

TABLE test.myobj;

 Create a Replicate Group

ggsci> DBLOGIN USERID ggs_owner, PASSWORD ggs_owner

ggsci> ADD CHECKPOINTTABLE GGS_OWNER.CHKPTAB

ggsci> ADD REPLICAT rep2, EXTTRAIL /u01/ggt_target/dirdat/rt CHECKPOINTTABLE CHKPTAB

ggsci> edit params rep2

###add the following lines in params file####

REPLICAT rep2

ASSUMETARGETDEFS

USERID ggs_owner, PASSWORD ggs_owner

MAP test.myobj, TARGET test.myobj;
Start extract and check status

ggsci> START EXTRACT ext2

ggsci> status extract ext2

ggsci> info extract ext2, detail

 Start replicat and check status

ggsci> START replicat rep2

ggsci> status replicate ext2

ggsci> info replicat ext2, detail
Perform any DML Operation

delete from test.myobj where rownum < 1000;

commit;

    
Check the data select count(*) from myobj; Check the Data select count(*) from myobj;