How to Enable and disable ARCHIVE log mode. | Oracle database

 You need to restart database to turn on archive log mode.

Login as SYSDBA

sqlplus / as sysdba




SQL> archive log list




Database log mode                       No Archive Mode

Automatic archival                      Disabled

Archive destination                     USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence              14

Current log sequence                     16

                 
OR

SQL>select log_mode from v$database;

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

Decide how much you want to dedicate to flash recovery area.

alter system set db_recovery_file_dest_size = 10G;

system altered

SET FAST RECOVERY AREA DESTINATION

by default it will be under $ORACLE_BASE/flash_recovery_area/

alter system set db_recovery_file_dest='/u01/oracle11g/flash_recovery_area';

--------------------***-MOUNT YOUR DATABASE--***-----------------------------------------------

SQL>shutdown immediate

SQL>startup mount

SQL>alter database archivelog;

Database altered.

--------------------***-OPEN YOUR DATABASE--***-----------------------------------------------

alter database open;

Database altered.

Check now:

archive log list