1. Oracle GoldenGate Classic Documentation
  2. Extract
  3. Configuring a Downstream Mining Database
  4. Example Downstream Mining Configuration
  5. Example 3: Capturing from Multiple Sources with Mixed Real-time and Archive-log-only Mode
  6. Set up Extracts at Downstream Mining Database
  7. Set up Extract (ext3) to Capture Changes in Real-time Mode from Online Logs Sent by DBMS3

Set up Extract (ext3) to Capture Changes in Real-time Mode from Online Logs Sent by DBMS3

Perform the following steps on the DBMSCAP downstream mining database.

  1. Register Extract with the mining database for source database DBMS3. In the credential store, the alias name of ggadm3 is linked to a user connect string of ggadm3@dbms3.The alias name of ggadmcap is linked to a user connect string of ggadmcap@dbmscap.
    GGSCI> DBLOGIN USERID ggadm3
GGSCI> MININGDBLOGIN USERID ggadmcap
GGSCI> REGISTER EXTRACT ext3 DATABASE
  2. Create Extract at the mining database.
    GGSCI> ADD EXTRACT ext3 INTEGRATED TRANLOG, BEGIN NOW
  3. Edit the Extract parameter file ext3.prm. To enable real-time mining, you must specify downstream_real_time_mine. In the credential store, the alias name of ggadm3 is linked to a user connect string of ggadm3@dbms3.The alias name of ggadmcap is linked to a user connect string of ggadmcap@dbmscap.
    USERIDALIAS ggadm3
TRANLOGOPTIONS MININGUSERALIAS ggadmcap
TRANLOGOPTIONS INTEGRATEDPARAMS (downstream_real_time_mine Y)
  4. Start Extract.
    GGSCI> START EXTRACT ext3

Note:

You can create multiple Extracts running in real-time integrated capture mode in the downstream mining database, as long as they all are capturing data from the same source database, such as all capturing for database DBMS3 in the preceding example.