Hi
Does anyone know if datafile can contain data that are not validated but are written to the datafile by DBWR because the data buffer is full?
Cheers
Printable View
Hi
Does anyone know if datafile can contain data that are not validated but are written to the datafile by DBWR because the data buffer is full?
Cheers
Pando,
Of course it can. By validate, I take it that you mean "comitted".
Ireespective of data bring comitted or not (the dirty buffer write que) DBWR writes them back to disk. If they are rolled back, data is reconstructed using the SCN and the RBS.
The Oracle fast commit mechanism commits the data only in the redolog buffer and files.
Nizar.
well I am just puzzled that in an instance failure the redo logs protects changes made to database buffers in memory that have not been written to the datafiles, what happen to those data which are not validated but written to the datafile in an instance failure? Since there arent any rollback or commit.
aps got it they will be rolled back since last checkpoint