Verifying the Current Archive Setting of the Redo Logs

Verify that redo logging, which Oracle uses to maintain a log infrastructure, is turned on. Turn redo logging on only in the primary database.

1. Use SQLPLUS to connect to Oracle as a system administrator.
2. From SQLPLUS, run:

   select log_mode from v$database;

   • If the archive log is on, you should see:

     LOG_MODE

     --------

     ARCHIVELOG

3. To turn on log archiving:

   shutdown;

   startup mount;

   alter database archivelog;

   alter database open;

   See the Replication Agent Primary Database Guide.