When archive log generates in Oracle?
- April 16, 2019
- Posted by: Ankush Thavali
- Category: Oracle DBA
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