Why is the header of datafile and information of control file different at the time of inconsistant backup?

hari shankar

• Aug 5th, 2016

This will happen only one situation when we are taking backup when database is in open mode and we are taking data file in offline. In this situation data files header are block but control files are still open mode and updated by oracle process.

Sekaran Narsimhan

 Profile Answers by Sekaran Narsimhan Questions by Sekaran Narsimhan

• Jun 16th, 2011

Inconsistent backup means online backup . when v r doing the online backup the database will be running and query ill be hitting the server in that time scn no ill differ from header of the datafile and the control file . so the both the info will be differ from each other in inconsistent backup 

Answer Question  Select Best Answer