CDC Guide for Linux, UNIX, and Windows

Back Next

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 for Oracle databases not in an Amazon RDS environment, issue the following SQL statements:

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

Back up your database after each SHUTDOWN command.

To confirm that ARCHIVELOG mode is set for the database, enter the following SQL statement:

SELECT LOG_MODE FROM SYS.V&DATABASE;

For an Amazon RDS for Oracle databases, set the backup retention period to place the database in ARCHIVELOG mode and enable automated backups.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.