Wednesday, November 30, 2011

changes in 11gR2 compared to 10gR2 (1)

While preparing for the upgrade from 10.2.0.3 to 11.2.0.3  I noticed an

interesting change from  11.2.0.2 on ;
if a datafile is unavailable for write the  database performs a shutdown abort unless _datafile_write_errors_crash_instance is set.

Before  if the database was in running archive log and the datafile in question was not a "system" one the datafile would just be put offline.... now the database stops.

Will test it soon and put some excepts of the alert.log