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

Enabling ARCHIVELOG Mode

Enabling ARCHIVELOG Mode

PowerExchange Express CDC for Oracle requires Oracle to be running in ARCHIVELOG mode.
By default, ARCHIVELOG mode is not enabled.
To enable ARCHIVELOG mode, issue the following statements:
SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN; SHUTDOWN IMMEDIATE; STARTUP;
Back up your database after each SHUTDOWN command.

0 COMMENTS

We’d like to hear from you!