savitha_pl

 Profile Answers by savitha_pl 

• Jul 14th, 2009

 

When we start datafile backup with begin backup command which will freeze the datafile headers and SCN cannot be updated only in controlfile SCN will update.  This process is till end backup.

narendra05

 Profile Answers by narendra05 

• Apr 23rd, 2010

 

When begin backup command is issued the datafile header's are blocked. While the controlfile SCN does gets changed. During startup of the database the database has to do a rollforward based on the SCN between the header of datafile and control file.

Thanks
Narendra

Sekaran Narsimhan

 Profile Answers 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 

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.