Prepare the Source Database to Send Redo to the Mining Database

To prepare the source database to send redo to the mining database:

  1. Make sure that the source database is running with the required compatibility.
    select name, value from v$parameter where name = 'compatible';
    
    NAME            VALUE
    ---------       ---------------------
    compatible      11.1.0.7.0
    

    The minimum compatibility setting required from integrated capture is 11.1.0.0.0.

  2. Set DG_CONFIG at the source database.
    ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(dbms1,dbmscap)';
    
  3. Set up redo transport at the source database.
    ALTER SYSTEM
    SET LOG_ARCHIVE_DEST_2='SERVICE=DBMSCAP.EXAMPLE.COM ASYNC OPTIONAL NOREGISTER 
    VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=dbmscap';
    
  4. Enable the downstream destination.
    ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;