• Arun Kumar

Database Archivelog Mode

In this article we will look at enabling and disabling database archivelog mode.


Check Archivelog Mode


You can use any of the below queries to check database archivelog mode status

SQL> archive log list;
SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

You must set log_archive_dest_1 to specific location where you want archives to be stored

alter system set log_archive_dest_1='location=/u01/proddb/arch'


Enable Archivelog Mode


You must shutdown the database in order to enable archivelog mode

SQL> Shut immediate;
SQL> Startup mount;
SQL> alter database archivelog;
SQL> alter database open;
SQL> archive log list

Perform a force log switch

SQL> alter system switch logfile


Disable Archivelog Mode


For disabling also you must bounce the database

SQL> shut immediate;
SQL> startup mount;
SQL> alter database noarchivelog;
SQL> alter database open;
SQL> archive log list;



Recent Posts

See All

MySQL Installation on Linux

This article demonstrates MySQL installation on Oracle Enterprise Linux 6.5 version. Installation of MySQL Make sure you are able to connect internet via virtual machine. Try to ping google.com and pr

Add ISO image storage repository on XenServer

If you have used VMware ESXI, its very easy to upload ISO files to the data store and create VMs. With XenServer, you must create your own ISO repository to upload ISO files. Create ISO directory Acce

Perform Manual Switchover on Physical Standby

Connect to proddb database via client: Take a new putty session and connect to proddb database via client machine. Keep querying below sqlplus sys/sys@proddb as sysdba SQL> select name, open_mode, db

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback