Prepare the First Source Database to Send Redo to the Mining Database
To prepare the first source database to send redo to the mining database:
- Make certain that DBMS1 source database is running with the required
compatibility.
select name, value from v$parameter where name = 'compatible';
- Set
DG_CONFIG at DBMS1
source database:ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(dbms1, dbmscap)';
- Set up redo transport at
DBMS1
source database. TheTEMPLATE
clause is mandatory if you want to send redo data directly to foreign archived logs at the downstream mining database.ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=DBMSCAP.EXAMPLE.COM ASYNC OPTIONAL NOREGISTER TEMPLATE='/usr/orcl/arc_dest/dbms1/dbms1_arch_%t_%s_%r.log VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=dbmscap';
- Enable the downstream
destination:
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;