Control db instance crash or datafile offline parameter when non-system datafile cannot write

This digest from: MoS articles

Bug 7691270-crash The DB in case of write errors (rather than just offline files) (Doc ID 7691270.8)

Bug 7691270 Crash The DB in case of write errors (rather than just offline files) This note gives a brief overview of bug 7691270.
The content is last updated on:15-jul-2011
Click here for details on each of the sections below.

affects:

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions BELOW 11.2.0.2
Versions confirmed as being affected	11.1.0.7 10.2.0.3
Platforms affected	Generic (All/most platforms affected)

The fix for this bug introduces a notable change in behaviour thus:
Notable change of behaviour introduced in 11.2.0.2

Fixed:

This issue is a fixed in

11.2.0.2 (Server Patch Set)

Symptoms:	Related to:
Code Improvement Error may occur ORA-376	Recovery _datafile_write_errors_crash_instance

Description

This fix introduces a notable the behaviour in the from 11.2.0.2 onwards an I/O write error to a datafile willnow C Rash the instance.  Before this fix I/O errors to datafiles No in the system tablespace offline the respective datafiles when the database is In Archivelog mode. This behavior isn't always desirable. Some customers would prefer that the instance crash due to a datafile write error. This fix introduces a new hidden parameter to control if the Instanceshould crash on a write error or not: _datafile_writ E_errors_crash_instance with the Fix:if _datafile_write_errors_crash_instance = TRUE (default) then any write to a data  File which fails due to a IO error causes an instance crash. If _datafile_write_errors_crash_instance = FALSE Then the behaviour reverts to the previous behaviour (before this fix) s Uch that a write error to a datafile offlines the file (provided the DB is in Archivelog mode and the file are not in SYS TEM tablespace in which case the instance Is aborted)  

HOOKS parameter:_datafile_write_errors_crash_instance error:ora-376 likelyaffects xaffects_10.2.0.1 XAFFECTS_ V10020001 affects=10.2.0.1 xaffects_10.2.0.2 xaffects_v10020002 affects=10.2.0.2 xaffects_10.2.0.3 XAFFECTS_ V10020003 affects=10.2.0.3 xaffects_10.2.0.4 xaffects_v10020004 affects=10.2.0.4 xaffects_10.2.0.5 XAFFECTS_ V10020005 affects=10.2.0.5 xaffects_11.1.0.6 xaffects_v11010006 affects=11.1.0.6 xaffects_11.1.0.7 XAFFECTS_ V11010007 affects=11.1.0.7 xaffects_11.2.0.1 xaffects_v11020001 affects=11.2.0.1 xprodid_5 PRODUCT_ID=5 PRODID-5 RDBMS Xcomp_rdbms Component=rdbms tag_cb202 tag_enh tag_error tag_recovery CB202 ENH ERROR RECOVERY fixed_11.2.0.2

Please Note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does is confirm that is encountering this problem. For questions the This bug is consult Oracle support.

References

bug:7691270 (this link would only work for

PUBLISHED bugs)
note:245840.1 Information

on the sections in this article

Control db instance crash or datafile offline parameter when non-system datafile cannot write