1. Oracle GoldenGate Classic Architecture Documentation
  2. Extract
  3. Configuring a Downstream Mining Database
  4. Example Downstream Mining Configuration
  5. Example 1: Capturing from One Source Database in Real-time Mode
  6. Prepare the Mining Database to Archive Redo Received in Standby Redo Logs from the Source Database

Prepare the Mining Database to Archive Redo Received in Standby Redo Logs from the Source Database

To prepare the mining database to archive the redo received in standby redo logs from the source database:

  1. At the downstream mining database, set log_archive_dest_2 as shown in the following example.
    ALTER SYSTEM SET
LOG_ARCHIVE_DEST_2='LOCATION=/home/arc_dest/srl_dbms1
VALID_FOR=(STANDBY_LOGFILE,PRIMARY_ROLE)'
  2. Enable log_archive_dest_2 as shown in the following example.
    ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE
  3. Set DG_CONFIG at the downstream mining database.
    ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(dbms1,dbmscap)'