Guenadi N Jilevski's Oracle BLOG

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

Using Oracle GoldenGate 11gR2 reverse utility to undo changes from OGG replication – Download

Using Oracle GoldenGate 11gR2 reverse utility to undo changes from OGG replication – Download

In the article you will have a look at an example of using the Oracle GoldenGate (OGG) 11gR2 reverse utility to back out changes replicated from the source database to the target database. In certain cases you need to back out the changes on the target database. For example:

  • undo replication changes committed on the target database
  • rollback an erroneous or accidently issued transaction replicated to the target
  • restore the target data to a state before the replication

Although you can use flashback features, in case of a target Oracle database, or simple backup and restore, OGG 11gR2 provides a generic reverse utility that helps you performing the back out. For you to implement a change back out you need to perform the following steps:

  1. Determine the start and end time for the transactions to be backed out
  2. Configure and start online extract to capture the changes from the source database for this period including the before images and use a trail format that does not compress deletes.
  3. Use the reverse utility to process the trail
  4. Configure and start replicat to apply the change records from the reversed trails and undo the changes that were already applied.

Read online from here or download Using OGG 11gr2 reverse utility to undo changes from OGG replication

November 24, 2012 Posted by | oracle | Leave a comment

Using Oracle GoldenGate 11gR2 reverse utility to undo changes from OGG replication

Using Oracle GoldenGate 11gR2 reverse utility to undo changes from OGG replication

In the article you will have a look at an example of using the Oracle GoldenGate (OGG) 11gR2 reverse utility to back out changes replicated from the source database to the target database. In certain cases you need to back out the changes on the target database. For example:

  • undo replication changes committed on the target database
  • rollback an erroneous or accidently issued transaction replicated to the target
  • restore the target data to a state before the replication

Although you can use flashback features, in case of a target Oracle database, or simple backup and restore, OGG 11gR2 provides a generic reverse utility that helps you performing the back out. For you to implement a change back out you need to perform the following steps:

  1. Determine the start and end time for the transactions to be backed out
  2. Configure and start online extract to capture the changes from the source database for this period including the before images and use a trail format that does not compress deletes.
  3. Use the reverse utility to process the trail
  4. Configure and start replicat to apply the change records from the reversed trails and undo the changes that were already applied.
    Continue reading

November 24, 2012 Posted by | oracle | 1 Comment

Deploy Oracle GoldenGate Veridata Version 3.0 for comparison between Oracle RDBMS databases replicated using OGG 11gR2 – Download

Deploy Oracle GoldenGate Veridata Version 3.0 for comparison between Oracle RDBMS databases replicated using OGG 11gR2 – Download

In the article you will have a look at the steps to install, configure and deploy OGG Veridata 3.0 for data comparison between two Oracle 11gR2 databases configured with OGG 11gR2 for data replication. The OGG 11gR2 setup that will be used for replication and subsequent verification with Veridata comparison is described here. The article will briefly cover the following topics

  • Brief overview of OGG Veridata concepts and architecture
  • OGG Veridata Server and OGG Veridata Web installation and management
  • OGG Veridata Agent for Oracle installation
  • Example of using OGG Veridata for comparison between running Oracle databases in active-active OGG 11gR2 configuration
  • Using OGG vericom

Read online from here or download Deploy Oracle GoldenGate Veridata Version 3

November 18, 2012 Posted by | oracle | Leave a comment

Deploy Oracle GoldenGate Veridata Version 3.0 for comparison between Oracle RDBMS databases replicated using OGG 11gR2

Deploy Oracle GoldenGate Veridata Version 3.0 for comparison between Oracle RDBMS databases replicated using OGG 11gR2

In the article you will have a look at the steps to install, configure and deploy OGG Veridata 3.0 for data comparison between two Oracle 11gR2 databases configured with OGG 11gR2 for data replication. The OGG 11gR2 setup that will be used for replication and subsequent verification with Veridata comparison is described here. The article will briefly cover the following topics

  • Brief overview of OGG Veridata concepts and architecture
  • OGG Veridata Server and OGG Veridata Web installation and management
  • OGG Veridata Agent for Oracle installation
  • Example of using OGG Veridata for comparison between running Oracle databases in active-active OGG 11gR2 configuration
  • Using OGG vericom
    Continue reading

November 18, 2012 Posted by | oracle | 3 Comments

Oracle GoldenGate Director 11gR2 (Server, Administrator, Client and Web) 11.2.1 installation and deployment – Download

Oracle GoldenGate Director 11gR2 (Server, Administrator, Client and Web) 11.2.1 installation and deployment – Download

In the article you will look at the steps for deploying Oracle Goldengate (OGG) Director on OEL 5.X using Oracle RDBMS as a repository. OGG Director consists of the following components:

  • OGG Director Server
  • OGG Director Admin
  • OGG Director Client
  • OGG Director Web

All of the above components will be installed and configured for you to monitor and manage the OGG environment.

The following software will be used.

  • OGG Director 11gR2 11.2.1.0 Server – download from here. OGG Director Client comes with the OGG Director Server and can be downloaded from the OGG Server or installed separately.
  • Oracle WebLogic Server (OWLS) 12c 12.1.1 – download from here
  • JDK 1.6.0_20 or later – download from here

Read online from here or download Oracle GoldenGate Director 11.2.1 installation and deployment

November 14, 2012 Posted by | oracle | Leave a comment

Oracle GoldenGate Director 11gR2 (Server, Administrator, Client and Web) 11.2.1 installation and deployment

Oracle GoldenGate Director 11gR2 (Server, Administrator, Client and Web) 11.2.1 installation and deployment

In the article you will look at the steps for deploying Oracle Goldengate (OGG) Director on OEL 5.X using Oracle RDBMS as a repository. OGG Director consists of the following components:

  • OGG Director Server
  • OGG Director Admin
  • OGG Director Client
  • OGG Director Web

All of the above components will be installed and configured for you to monitor and manage the OGG environment.

The following software will be used.

  • OGG Director 11gR2 11.2.1.0 Server – download from here. OGG Director Client comes with the OGG Director Server and can be downloaded from the OGG Server or installed separately.
  • Oracle WebLogic Server (OWLS) 12c 12.1.1 – download from here
  • JDK 1.6.0_20 or later – download from here
    Continue reading

November 14, 2012 Posted by | oracle | 5 Comments

Using Oracle GoldenGate (OGG) 11gR2 for Conflict Detection and Resolution (CDR) based on balance and timestamp in a bidirectional active-active configuration – Download

Using Oracle GoldenGate (OGG) 11gR2 for Conflict Detection and Resolution (CDR) based on balance and timestamp in a bidirectional active-active configuration – Download

In the article you will have a look at an example for CDR implementation based on a balance and timestamp column in a bidirectional active-active OGG setup. I will build an active-active bidirectional OGG replication between two sites (RACD, RACDB) each having identical tables (test5.account, test5.seat_assignment). I will emphasize on the requirements for CDR implementation and will outline CDR concepts and illustrate a step-by step CDR implementation, testing and troubleshooting. I will cover two cases

  • Use delta method for account balance CDR – An initial balance of 1000 will be simultaneously credited 200 on site B and debited 100 on site A. The result will be 1100 on both site A and site B.
  • Use USEMIN timestamp method for seat booking CDR – a seat ‘2A’ will be booked 1st by John Smith on site A and at about the same time will be booked by Pier Cardin on site B. The result will be the first user on both site A and site B.

Starting with OGG 11gR2 there are build in options in the MAP replicat parameter, such as COMPARECOLS, RESOLVECONFLICT, and in the TABLE extract parameter, such as GETBEFORECOLS, allowing easy, automatic and OGG driven CDR compared to the methods involving SQL or PLSQL code invoked from SQLEXEC used for CDR in versions of OGG prior to 11gR2.

Read online from here or download Using Oracle GoldenGate (OGG) 11gR2 for Conflict Detection and Resolution (CDR) based on balance and timestamp in a bidirectional active-active configuration

November 8, 2012 Posted by | oracle | 2 Comments

Using Oracle GoldenGate (OGG) 11gR2 for Conflict Detection and Resolution (CDR) based on balance and timestamp in a bidirectional active-active configuration

Using Oracle GoldenGate (OGG) 11gR2 for Conflict Detection and Resolution (CDR) based on balance and timestamp in a bidirectional active-active configuration

In the article you will have a look at an example for CDR implementation based on a balance and timestamp column in a bidirectional active-active OGG setup. I will build an active-active bidirectional OGG replication between two sites (RACD, RACDB) each having identical tables (test5.account, test5.seat_assignment). I will emphasize on the requirements for CDR implementation and will outline CDR concepts and illustrate a step-by step CDR implementation, testing and troubleshooting. I will cover two cases

  • Use delta method for account balance CDR – An initial balance of 1000 will be simultaneously credited 200 on site B and debited 100 on site A. The result will be 1100 on both site A and site B.
  • Use USEMIN timestamp method for seat booking CDR – a seat ‘2A’ will be booked 1st by John Smith on site A and at about the same time will be booked by Pier Cardin on site B. The result will be the first user on both site A and site B.

Starting with OGG 11gR2 there are build in options in the MAP replicat parameter, such as COMPARECOLS, RESOLVECONFLICT, and in the TABLE extract parameter, such as GETBEFORECOLS, allowing easy, automatic and OGG driven CDR compared to the methods involving SQL or PLSQL code invoked from SQLEXEC used for CDR in versions of OGG prior to 11gR2.
Continue reading

November 7, 2012 Posted by | oracle | 4 Comments