How to enable ARCHIVELOG MODE in Oracle database

In order to set archivelog mode on or off in the Oracle database login as sysdba and do the following actions.

shutdown database
SQL> shutdown immediate;

startup database in mount mode

SQL> startup mount;

Change DB log mode

SQL> alter database archivelog;

Open DB for normal use

SQL> alter database open;

check archivelog status

SQL> archive log list

Default Archive log destination.

1. 10g introduces a new feature called FRA (flashback recovery area) so all archivelog files created in FRA.

2. If your not using FRA then all files created in $ORACLE_HOME/database

We can check database archivelog mode through below query

SQL> select log_mode from v$database;
or
SQL> archive log list