How can on tell if archivelog is turned on in the Oracle database

  • KM02736856
  • 17-Feb-2017
  • 09-Mar-2021

Archived Content: This information is no longer maintained and is provided "as is" for your convenience.

Summary

the command from sqlplus to tell if archivelog is turned on or not.

Question

How can one tell if archivelog is turned on in the Oracle database

Answer

After logging into the oracle instance in sqlplus, the command is :

        archive log list

The example out of issuing the command in sqlplus.  Here the output shows that archivelog is enabled :

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 15

Next log sequence to archive 17

Current log sequence 17