Previous Topic: Perform Post-Installation TasksNext Topic: Start ARCHIVELOG Mode


Check ARCHIVELOG mode

You must enable the ARCHIVELOG mode to archive the redo logs.Use the following procedure to check if the ARCHIVELOG mode is enabled.

To check if the ARCHIVELOG mode is enabled

  1. Log into Oracle server as an Oracle user with SYSDBA equivalent privileges.
  2. Enter the following command at the SQL*Plus prompt:
    ARCHIVE LOG LIST;
    

    Check ARCHIVELOG mode

    This command displays Oracle's archive log settings for this instance. For the agent to function properly, the following should be set:

    Database log mode: Archive Mode

    Automatic archival: Enabled