Tag Archives: database tutorial

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;