Wednesday, November 30, 2011

changes in 11gR2 compared to 10gR2 (1)

While preparing for the upgrade from to  I noticed an

interesting change from 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