• 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

How to find fresher DBA jobs?

One of the best part about being an Oracle DBA is – Database ownership! As a DBA, you actually own the database. That being said, one big question arises – which company would handover critical databa

15 Things fresher DBA must know

This blog post is a quick summary of How to become a DBA course – A 100% free course which speaks about everything you need to become an Oracle DBA. Learning SQL is just not enough to become an Oracle

Database normalization

Database normalization is the process of refining the data in accordance with a series of normal forms. This is done to reduce data redundancy and improve data integrity. This process divides large ta

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback