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

Specifying an Archive Log Destination

Specifying an Archive Log Destination

You must specify the archive log destination from which the Express CDC log reader selects archived redo log files.
Consult with your Oracle DBA. To configure the archived log destination, complete one of the following actions:
  • Edit the init.ora file to specify the archive log destination and file-name format. For more information about the init.ora file, see the Oracle database administrator guide.
  • Customize the appropriate server parameter file (spfile) to indicate the archived log destination, for example:
    CONNECT SYS/
    sys_pwd
    AS SYSDBA; ALTER SYSTEM SET log_archive_dest_1 = 'location=/
    oracle_path
    /
    arch
    ' SCOPE=SPFILE;
  • For Oracle databases deployed in an Amazon RDS for Oracle environment, create the directories ARCHIVELOG_DIR and ONLINELOG_DIR for the archived and online redo logs, respectively. Use the following exec statements:
    exec rdsadmin.rdsadmin_master_util.create_archivelog_dir; exec rdsadmin.rdsadmin_master_util.create_onlinelog_dir;
    Also define an appropriate retention policy for the archived redo logs. Use the following exec statement:
    exec rdsadmin.rdsadmin_util.set_configuration('archivelog retention days',
    number_of_days
    );
    The Express CDC for Oracle user will require read-only access to the online and archived redo log files in these directories.

0 COMMENTS

We’d like to hear from you!