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'; 

   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;