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

westzq1984發表於2011-04-08
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
Platforms affected Generic (all / most platforms affected)

Fixed:

This issue is fixed in

Symptoms:

Related To:

  • (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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章