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

or use command prompt to access sqlplus
sqlplus / as sysdba
SQL > connect / as sysdba 

1. Connect to Oracle
connect / as sysdba

or type sqlplus / 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:-