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