CDC Guide for Linux, UNIX, and Windows

10.0
- 10.2.2
- 10.2.1
- 10.2

Back Next

Step 1. Set Up Archive Logging

For PowerExchange to capture changes from archive logs, you must define the archive log destination and enable ARCHIVELOG mode in Oracle. By default, ARCHIVELOG mode is not enabled.

For a non-RAC environment, use the sample SQL statements in the Setup_Archive_Logging.sql file. For a RAC environment, use the statements in the Setup_Archive_Logging_rac.sql file. Both files include detailed comments.

First, specify the archive log destination in one of the following ways:

If you use the Oracle init.ora initialization parameter file, edit the appropriate parameters in this file to identify the archive log destination and file name format. For more information, see the Oracle database administrator’s guide for your Oracle version.

If you use a server parameter file (spfile), execute the ALTER SYSTEM SET SQL statements that are included in the sample .sql files. The specific SQL and configuration steps vary for RAC and non-RAC environments.

To enable ARCHIVELOG mode, issue the following statements:

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
SHUTDOWN IMMEDIATE:
STARTUP;

Rename Saved Search

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Step 1. Set Up Archive Logging

Step 1. Set Up Archive Logging