Thinking Out Loud

February 21, 2012

My Bi-directional Replication Using GoldenGate Adventure, Ep4

Filed under: 11g,GoldenGate,oracle — mdinh @ 4:20 am

https://docs.google.com/spreadsheet/ccc?key=0AmlTdsDfc8ZmdEo4SUhUVjJrTHY0UXRDSHFaYjRQLWc

The above link contains all the configurations for GoldenGate.

The parameter files (*.prm) should reside at GG_HOME/dirprm

The macro file (macrolib.mac) should reside at GG_HOME/dirmac

Don’t forget to execute ADD TRANDATA or ADD SCHEMATRANDATA before starting the manager, extract, datapump extract, replicat.

Next step, create tables and test data.

Stay tuned and I will share with you the stored procedure used to create PK sequences to avoid collisions.

Advertisements

1 Comment »

  1. nice post

    Comment by Dell Loggis — February 21, 2012 @ 3:07 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: