How to enable Archivelog mode in Oracle Database

Archivelog mode is very important for database backup, recovery and Dataguard Environment. Without Archivelog mode, we cannot take online backups and point-in-time recovery is not possible.

Step 1: Check the current Archive log Mode

SQLPLUS / AS SYSDBA

Archive log list;

Step 2: Shutdown the database

shutdown immediate;

Step 3: Start Database in Mount mode.

startup mount;

Step 4: Enable Archivelog mode

alter database archivelog;

Step 5: Open the database

alter database open;

Step 6: Verify Archivelog mode

archive log list;

Set Archive log location

You can define a custom location for archive logs

show parameter log_archive_dest;

Alter system set log_archive_dest_1='location=C:\archivelog' scope=both;

Leave a Reply