Verifying the Current Archive Setting of the Redo Logs

Verify that redo logging, which Oracle uses to maintain a log infrastructure, is turned on 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.