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 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 SET
LOG_ARCHIVE_DEST_1='LOCATION=/home/arc_dest/local
VALID_FOR=(ONLINE_LOGFILE, PRIMARY_ROLE)'
  3. Enable log_archive_dest_1.
    ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=ENABLE