1. Oracle GoldenGate Microservices Documentation
  2. Extract
  3. Downstream Extract for Downstream Database Mining
  4. Use Cases for Downstream Mining Configuration
  5. Case 3: Capturing from Multiple Sources with Mixed Real-time and Archive-log-only Mode
  6. Prepare the Third Source Database to Send Redo to the Mining Database
  7. Set up Extracts at Downstream Mining Database
  8. Set up Extract (ext1) to Capture Changes from Archived Logs Sent by DBMS1

Set up Extract (ext1) to Capture Changes from Archived Logs Sent by DBMS1

Perform the following steps on the DBMSCAP downstream mining database:

  1. Register Extract with DBMSCAP for the DBMS1 source database. In the credential store, the alias name of ggadm1 is linked to a user connect string of ggadm1@dbms1.The alias name of ggadmcap is linked to a user connect string of ggadmcap@dbmscap. 
    DBLOGIN USERIDALIAS ggadm1 
MININGDBLOGIN 
USERIDALIAS ggadmcap 
REGISTER EXTRACT ext1 DATABASE
  2. Add Extract at the mining database DBMSCAP:
    ADD EXTRACT ext1 INTEGRATED TRANLOG BEGIN NOW
  3. Edit the Extract parameter file ext1.prm. In the credential store, the alias name of ggadm1 is linked to a user connect string of ggadm1@dbms1. The alias name of ggadmcap is linked to a user connect string of ggadmcap@dbmscap:
    USERIDALIAS ggadm1 TRANLOGOPTIONS MININGUSERALIAS  
ggadmcap TRANLOGOPTIONS INTEGRATEDPARAMS (downstream_real_time_mine N)
  4. Start Extract: 
    START EXTRACT ext1