Check the location or Status of the archive log in Oracle

Check the Status of the Archive mode is on or off in Oracle

Select NAME, LOG_MODE from V$DATABASE

NAME     LOG_MODE
----     -----------
ORCL     NOARCHIVELOG

Note:
NOARCHIVELOG means its disable or off.
ARCHIVELOG means its enable or on.

Check the location and status of the archive log in Oracle

SQL> Archive log list;

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     22
Next log sequence to archive   24
Current log sequence           24

Note: It show enabled or Disabled , with archive destination.

Check the location with the following parameters also:
LOG_ARCHIVE_DEST: Destination of archive files.
LOG_ARCHIVE_FORMAT: Define the format or naming convention of archive files.

SQL> Show parameter LOG_ARCHIVE_DEST

On or Off the archive mode for Oracle

1. Shutdown the database
Shutdown immediate;

2. Start the database in mount state:
startup mount

3. On or Off the archive mode, choose one of the following commands:
-- For enable or on
alter database archivelog;
--For disable or off
alter database noarchivelog;

4. Open the Database.
alter database open;