Prepare the Source Database to Send Redo to the Mining Database
Prepare the Source Database to Send Redo to the Mining Database
To prepare the source database to send redo to the mining database:
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.
Set DG_CONFIG at the source database.
ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(dbms1,dbmscap)';
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';