O'Reilly logo

Instant Oracle GoldenGate by Tony Bruzzese

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating one-way replication (Simple)

Here we'll be utilizing the demo scripts included in the OGG software distribution to implement a basic homogenous (Oracle-to-Oracle) replication.

Getting ready

You need to ensure your Oracle database is in archivelog mode. If your database is not in archivelog mode, you won't be able to recover your database due to media corruption or user errors.

How to do it...

The steps for creating one-way replication are as follows:

  1. Check whether supplemental logging is enabled on your source database using the following command:
    SQL> select supplemental_log_data_min from v$database;
    

    The output of the preceding command will be as follows:

    SUPPLEME
    -----------------
    NO
    
  2. Enable supplemental logging using the following command: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required