Search This Blog

Thursday, July 20, 2017

Configure Oracle ArchiveLog Mode

In this post, we are going to configure archive log mode before backup Oracle database using Veeam Backup & Replication

Open SQL Command Line

Execute below command to configure archivelog mode

1. Connect to Oracle
connect / as sysdba

2. View database log mode
Select log_mode from v$database;

3. Shutdown the database before configure archivelog mode
Shutdown immediate

4. Startup the database in mount mode
startup mount

5. Set ArchiveLog mode
alter database archivelog
alter database open

6. View status. Should in Archivelog mode
Select log_mode from v$database;

End result:-