Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Configuring Oracle GoldenGate OGG 11gR2 downstream integrated capture – Download

Configuring Oracle GoldenGate OGG 11gR2 downstream integrated capture – Download

In the article you will have a look at an example configuration of an OGG downstream integrated capture extract in a RAC environment (RAC database is used for a source, downstream and target). You will briefly review some new OGG 11gR2 concepts and have a glimpse of the prerequisites and steps to configure a simple (one extract, one remote trail and one replicat) OGG replication using a downstream integrated capture. You will see how I resolved the problems that I encountered during the OGG configuration.

Read online from here or download Configuring Oracle GoldenGate OGG 11gR2 downstream integrated capture

October 31, 2012 Posted by | oracle | 3 Comments

Configuring Oracle GoldenGate OGG 11gR2 downstream integrated capture

Configuring Oracle GoldenGate OGG 11gR2 downstream integrated capture

In the article you will have a look at an example configuration of an OGG downstream integrated capture extract in a RAC environment (RAC database is used for a source, downstream and target). You will briefly review some new OGG 11gR2 concepts and have a glimpse of the prerequisites and steps to configure a simple (one extract, one remote trail and one replicat) OGG replication using a downstream integrated capture. You will see how I resolved the problems that I encountered during the OGG configuration.
Continue reading →

October 31, 2012 Posted by | oracle | 1 Comment

Configuring Oracle GoldenGate OGG 11gR2 local integrated capture and using OGG for mapping and transformations – DOWNLOAD

Configuring Oracle GoldenGate OGG 11gR2 local integrated capture and using OGG for mapping and transformations – DOWNLOAD

In the article you will have a look at an OGG configuration example for local integrated capture and discover how to deploy some of the powerful OGG features related to data mapping and transformation. Starting from OGG 11gR2 Oracle implemented an integrated capture, in addition to the already existing transaction log capture now a day called classic capture, only from Oracle RDBMS data sources by integrating the OGG extract with the database logmining server. OGG mapping and transformation is a feature that works with both classic and integrated capture enabling complex transactions to be replicated across heterogeneous environments. I will cover each topic separately in the following sub-sections.

  • Example of local integrated capture using OGG 11gR2
  • Example of mapping and transformation using OGG 11gR2

The article is based on OGG 11gR2 environment configuration previously described here.

Read online from here or download Oracle GoldenGate OGG 11gR2 local integrated capture

October 26, 2012 Posted by | oracle | Leave a comment

Configuring Oracle GoldenGate OGG 11gR2 local integrated capture and using OGG for mapping and transformations

Configuring Oracle GoldenGate OGG 11gR2 local integrated capture and using OGG for mapping and transformations

In the article you will have a look at an OGG configuration example for local integrated capture and discover how to deploy some of the powerful OGG features related to data mapping and transformation. Starting from OGG 11gR2 Oracle implemented an integrated capture, in addition to the already existing transaction log capture now a day called classic capture, only from Oracle RDBMS data sources by integrating the OGG extract with the database logmining server. OGG mapping and transformation is a feature that works with both classic and integrated capture enabling complex transactions to be replicated across heterogeneous environments. I will cover each topic separately in the following sub-sections.

  • Example of local integrated capture using OGG 11gR2
  • Example of mapping and transformation using OGG 11gR2

The article is based on OGG 11gR2 environment configuration previously described here.
Continue reading →

October 26, 2012 Posted by | oracle | 1 Comment

Oracle GoldenGate OGG 11gR2 with Oracle RDBMS – Fundamentals (PK/UK, substitute keys KEYCOLS, ADD TRANDATA, Before and After images and they how work together) – Download

Oracle GoldenGate OGG 11gR2 with Oracle RDBMS – Fundamentals (PK/UK, substitute keys KEYCOLS, ADD TRANDATA, Before and After images and they how work together) – Download

In this article you will have a look at some basic fundamentals related to keys, supplemental logging and before and after images related to deploying OGG for transactional data replication using Oracle RDBMS as a source and/or target database. I will cover some OGG related concepts and you will glimpse at some practical test as an illustration. The concepts covered in the article apply to both CLASSIC and INTEGRATED capture, introduced in OGG 11gR2, once the specifics and nature of each capture methods are understood and taken into account. For information related to OGG setup look at here.

Read online from here or download Oracle_GoldenGate_OGG_11gR2_with_Oracle_RDBMS_Fundamentals

October 15, 2012 Posted by | oracle | Leave a comment

Oracle GoldenGate OGG 11gR2 with Oracle RDBMS – Fundamentals (PK/UK, substitute keys KEYCOLS, ADD TRANDATA, Before and After images and they how work together)

Oracle GoldenGate OGG 11gR2 with Oracle RDBMS – Fundamentals (PK/UK, substitute keys KEYCOLS, ADD TRANDATA, Before and After images and they how work together)

In this article you will have a look at some basic fundamentals related to keys, supplemental logging and before and after images related to deploying OGG for transactional data replication using Oracle RDBMS as a source and/or target database. I will cover some OGG related concepts and you will glimpse at some practical test as an illustration. The concepts covered in the article apply to both CLASSIC and INTEGRATED capture, introduced in OGG 11gR2, once the specifics and nature of each capture methods are understood and taken into account. For information related to OGG setup look at here.
Continue reading →

October 15, 2012 Posted by | oracle | 2 Comments