Vishal desai’s Oracle Blog

February 24, 2011

Oracle Golden Gate

Filed under: Golden Gate, Replication — vishaldesai @ 12:44 am

Lot of people have already blogged about Oracle Golden Gate so in this blog I will just give pointers to those links.

High level overview of Oracle Golden Gate

http://sai-oracle.blogspot.com/2010/09/what-is-oracle-goldengate.html

Quick overview and demos to setup Golden Gate

http://gavinsoorma.com/2010/02/oracle-goldengate-an-introduction/ (To start with and there are various other tutorials on Gavin’s blog)

Troubleshooting

http://deciphercorp.wordpress.com/2010/08/05/using-oracle-goldengates-logdump-utility/

While testing golden gate I ran into lot of issues and logdump utility helped me a lot to read trail files and fix issues.

Performance & Exception Handler

http://www.oracle11ggotchas.com/articles/DefiningMultipleReplicatstoIncreaseGoldenGatePerformance.htm

http://www.oracle11ggotchas.com/articles/CreatingaGoldenGateExceptionHandlertotrapandlogOracleErrors.htm

Extract Internals

http://www.pythian.com/news/7225/oracle-goldengate-extract-internals-part-i/

http://www.pythian.com/news/7459/oracle-goldengate-extract-internals-part-ii/

http://www.pythian.com/news/7617/oracle-goldengate-extract-internals-part-iii/

Oracle Golden Gate by example

http://apex.oracle.com/pls/apex/f?p=44785:24:2096163966240098::::P24_CONTENT_ID,P24_PREV_PAGE:5153,24

Upcoming Golden Gate Books

https://www.packtpub.com/oracle-goldengate-11g-implementers-guide/book

http://apress.com/book/view/9781430235668

Important Metalink notes and Documentation

1194273.1 – How to de normalize data using Golden Gate

1099523.1 – TimesTen replication using Golden Gate

http://download.oracle.com/docs/cd/E18101_01/index.htm

About these ads

2 Comments »

  1. Hi Vishal,

    Could you please let me know where oracle goldengate data (statisitcs etc..) infomation stored.

    Comment by Kishore — February 28, 2014 @ 9:31 am

    • Hi Kishore,

      Use stats command and reportcount parameter.

      Thanks,
      Vishal

      Comment by vishaldesai — February 28, 2014 @ 4:49 pm


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

The Silver is the New Black Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: