When archive log generates in Oracle?

In this blog we will try to understand generation of archivelog in Oracle database.

if our database is an article of mode and on the database if there are many transactions are happening to the database changes will be recorded in archivelog . all DML and DDL operations are get recorded into archivelog mode.

1 ) Huge Insertion of data

whenever we are inserting huge amount of data into the database then there is chances of archive log generation.

2)Update query on database

whenever we are updating you all the changes will be recorded into the redo log and the copy of redo log we called it as archive log.

Please reach out to me if you are looking oracle database training. I am always here to help you out. Please do subscribe my youtube channel.

Ankush Thavali Contact : +91 9960262955 Email : Ankush.Thavali@gmail.com

3 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *