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 (ext2) to Capture Changes from Archived Logs Sent by DBMS2

Set up Extract (ext2) to Capture Changes from Archived Logs Sent by DBMS2

Perform the following steps on the DBMSCAP downstream mining database:

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