"alter system kill session" can crash the instance if IO slaves used

9207下，如果BACKUP_TAPE_IO_SLAVES設定為TRUE，想使用LARGE POOL優化備份的話， 用ALTER SYSTEM KILL SESSION 殺RMAN程式不安全。

Bug 3996802  "alter system kill session" can crash the instance if IO slaves used

 This note gives a brief overview of bug 3996802.
 The content was last updated on: 08-AUG-2005
 Click here for details of each of the sections below.

Affects:

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions < 10.2
Versions confirmed as being affected	9.2.0.5 10.1.0.3
Platforms affected	Generic (all / most platforms affected)

Fixed:

This issue is fixed in

9.2.0.7 (Server Patch Set) 10.1.0.4 (Server Patch Set) 10.2.0.1 (Base Release)

Symptoms:	Related To:
Internal Error May Occur (ORA-600) Instance May Crash ORA-600 [1115]	(None Specified)

Description

It is possible for "alter system kill session" to cause corruption
in IO slave state objects. If this occurs then the following symptoms
can occur:
 - Dump in [ksfvidel]
 - Dump in other ksfv* routines
 - PMON crashign the instance with ORA-600[1115] cleaning up a state object 
    from the IO slave. (State Object of type "KSFV Adapator State").

Workaround: 
  Do not use "alter system kill session" when IO slaves are used.

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.

References

Bug:3996802 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8242091/viewspace-691946/，如需轉載，請註明出處，否則將追究法律責任。