Tech Help: How to Put Oracle database to Archivelog Mode

You can check log_mode using following command

SQL> select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG

Step01

If not shutdown database, you have to shutdown the database

SQL> shutdown immediate ;

Step02

stratup database mount stage

SQL> startup mount;

Step03

Alter database archivelog mode

SQL> alter database archivelog;

Step04

Database open

SQL>alter database open;

check again log_mode ,

SQL> select log_mode from v$database;

LOG_MODE
------------

ARCHIVELOG

ATEST