Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Configuration Readme File and Script Files

Configuration Readme File and Script Files

To configure PowerExchange Oracle CDC with LogMiner, use the readme_oracapt.txt file and the sample SQL script files in the PowerExchange installation directory.
The readme_oracapt.txt file describes the following sample SQL script files that PowerExchange provides for preparing Oracle for CDC:
  • Setup_Archive_Logging.sql
    (non-RAC environments) or
    Setup_Archive_Logging_rac.sql
    (RAC environments). Defines the archive log destination and enables ARCHIVELOG mode.
  • Setup_Minimal_Supplemental_Logging.sql
    . Enables global minimal supplemental logging.
  • Setup_Logminer_Tablespace.sql
    . Creates a tablespace for exclusive LogMiner use.
  • Create_ORACAPT_user.sql
    . Defines an Oracle CDC user and grants user privileges.
  • Optional_GRANT_for_registrations.sql
    . Grants the privilege that the Oracle CDC user requires to run generated DDL for creating a supplemental log group at capture registration completion in the PowerExchange Navigator.
  • Copy_Oracle_Dictionary.sql
    . Copies the Oracle catalog to the archived redo logs.
  • DataGuard_Logon_Trigger.sql
    . Creates a Data Guard logon trigger for the Oracle CDC user to prevent database row test or PowerExchange Logger failures when capturing changes from an Oracle Data Guard logical standby database.

0 COMMENTS

We’d like to hear from you!