1. Oracle GoldenGate Classic Documentation
  2. Extract
  3. Configuring a Downstream Mining Database
  4. Example Downstream Mining Configuration
  5. Example 3: Capturing from Multiple Sources with Mixed Real-time and Archive-log-only Mode
  6. Prepare the Mining Database to Archive its Local Redo

Prepare the Mining Database to Archive its Local Redo

To prepare the mining database to archive its local redo:

  1. The downstream mining database must be in archive log mode. You can do this by issuing the following DDL.
    STARTUP MOUNT;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
  2. At the downstream mining database, set log_archive_dest_1 to archive local redo.
    ALTER SYSTEM SETLOG_ARCHIVE_DEST_1='LOCATION=/home/arc_dest/localVALID_FOR=(ONLINE_LOGFILE, PRIMARY_ROLE)'
  3. Enable log_archive_dest_1.
    ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=ENABLE