Home What is Oracle? Oracle Training Tutorials for Beginners Difference Between Oracle 11g and 12c and 10g Import 12c Oracle Dump to 11g Ora 28001 The Password Has Expired Error Cache and Nocache in Oracle Sequence BR*Tools Documentation ORA-01455: Converting Column Overflows Integer Datatype Oracle Wait Events Interview Questions Difference Between Primary, Secondary and Clustered Indexes in DBMS Difference Between Hot and Cold Backup Oracle Partitioning Interview Questions Update Statement Works in Oracle Architecture Differences Between SAP HANA and Oracle Group Functions Ignore Null Values in Processed Column ORA-10458: Standby Database Requires Recovery Oracle Interview Questions

Reason of Archivelog Generating?

Updated May 19, 2018

Hello Experts,

Sometimes I am unable to understand that why more archivelog is Generating? what was the reason for it if anyone from you guys familiar with it then please share with me here so that I can work as per your suggestion.

Thanks in advance!

Comments

16 Sep 2015 4:28 pm Nitesh Singh

Archive is generated due to log switches. In fact dependent on the redo generated. Cause of redo generation is any change in the database like, insert, delete or update query. Let say you have a redo log size log 10MB and there are three group each has only one member (LOG A, LOG B and LOG C).
Suppose there is an import going on, this will generate lot of redo log. Once the log A i.e of 10M is filled it will move to next group log B. And similarly once the Log B of 10MB is full it ill move to group 3 i.e log C. and similarly once the log C is fulled it will over write the LOG A . "ARCHIVE LOG MODE enable means" before overwriting any Log it will be stored in a offline redo i.e the archive. That means every switch will generate an archive of 10 MB.
You can check the number of switches per hour that happened in your database from V$log_history view. Also using the number of switch you can calculate the total archive generated per hour of per day.

16 Sep 2015 4:29 pm Abhijeet Mudgal

Huge operations occured, like insert update so more archivelog is Generating.

16 Sep 2015 4:30 pm Romil Tripathi

More archivelog means your application is write intensive more the change, so is the redo generation and so is your offline redo logs.