how the commit,logswitch,chkpoint happens without datafile
How are we able to commit without datafile .
Below, i have renamed the datafile where in the table table exists,
Now a log switch has to force check point which will make DBWR to write dirty blocks into Datafile which is renamed , in that case it has to error out that Db file is missing but it doesnt happen. No ORA errors on log switching or committing or manual check pointing the db.
Below, i have renamed the datafile where in the table table exists,
Now a log switch has to force check point which will make DBWR to write dirty blocks into Datafile which is renamed , in that case it has to error out that Db file is missing but it doesnt happen. No ORA errors on log switching or committing or manual check pointing the db.
I tried the same thing few times. I do receive the "DB file Missing error" only on shutting down the database, so is Oracle updating the image of datafile in the OS buffer all times until the db is up and running?
0