Determine if oracle archive logging is enabled

This is some handy SQL that you can run without necessarily being a DBA or having a SYS role:

A database that has archive logging enabled will look like:

SELECT GROUP#, ARCHIVED
   FROM V$LOG;

4              YES
5              YES
6              YES
7              NO

SELECT LOG_MODE FROM V$DATABASE;
ARCHIVELOG

 

A database without archive logging enabled will look like:

SELECT GROUP#, ARCHIVED
   FROM V$LOG;

4              NO
5              NO
6              NO
7              NO
8              NO
9              NO

And
SELECT LOG_MODE FROM V$DATABASE;

NOARCHIVELOG