Enable and Disabling Archive Log Mode In Oracle

 

Checking Archivelog Mode:

SQL> archive log list;

You can also use below command

SQL> SELECT LOG_MODE FROM V$DATABASE;

Set Archivelog Destination:

You must set a destination for archivelog files

SQL> alter system set log_archive_dest_1='location=/u01/app/oracle/archivelogs';

Enable Archivelog Mode:

SQL> Shut immediate;

SQL> Startup mount;

SQL> alter database archivelog;

SQL> alter database open;

SQL> archive log list;

Disable Archivelog Mode:

SQL> shut immediate;

SQL> startup mount;

SQL> alter database noarchivelog;

SQL> alter database open;

SQL> archive log list;

How to Estimate Archive Destination Space:

SELECT A.*, 

Round(A.Count#*B.AVG#/1024/1024/1024) Daily_Avg_gb 

FROM 

(SELECT 

To_Char(First_Time,'YYYY-MM-DD') DAY, 

Count(1) Count#, 

Min(RECID) Min#, 

Max(RECID) Max# 

FROM v$log_history 

GROUP 

BY To_Char(First_Time,'YYYY-MM-DD') 

ORDER 

BY 1 

) A, 

(SELECT 

Avg(BYTES) AVG#, 

Count(1) Count#, 

Max(BYTES) Max_Bytes, 

Min(BYTES) Min_Bytes 

FROM 

v$log ) B;