What is the use of archive log file? How will you apply archive log file? How does archive log file helps to make backup consistent?

ARUN BHUKKER

 Profile Answers by ARUN BHUKKER Questions by ARUN BHUKKER

• Oct 19th, 2012

A Archive log file is used to archive the filled redo log files. and used in recovery.

It is used in recovery but not in instance recovery.
Rest it is used to make database consistent after recovery by matching header of data file and control file checkpoint information.

rsona

 Profile Answers by rsona Questions by rsona

• Mar 2nd, 2011

Hello Ganesh,Q : What is the use of archive log file? A : It is used for Point In Time Database Instance Recovery.     Q : How will you apply archive log file? A : Archive Log need...

Answer Question  Select Best Answer