How to enable ARCHIVELOG MODE in Oracle 10g

In 10g, enabling Archivelog mode is much easier because all you really need to do is turn on DB log mode. There is really no parameter setting in the init.ora which is nice.

1) Shutdown the Database

SQL> shutdown immediate;

2) Startup the Database in mount mode

SQL> startup mount;

3) Change DB log mode

SQL> alter database archivelog;

4) Open DB for normal use

SQL> alter database open;

5) Check the Archivelog Status

SQL> archive log list

6) Default Archive log destination.

1. 10g introduce 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

7) We can check database archivelog mode through below query

SQL> select log_mode from v$database;

or

SQL> archive log list