oracle & NFS & backup & event & 10298
作者: 絃樂之花 | 可以轉載, 但必須以超連結形式標明文章原始出處和作者資訊及版權宣告
連結http://shiri512003.itpub.net/post/37713/499390
[@more@]摘自metalink:
From Oracle 10G R2 , Oracle checks the options with which a NFS mount is mounted on the filesystem. and this is done to ensure that no corruption of the database can happen as incorrectly mounted NFS volumes can result in data corruption.
There are no single set of NFS mount options that work across all Oracle platforms
Please ensure that you have the proper mount options specified by the NAS vendor /Vendor user guide
The exact checks used for an NFS mounted disk vary between platforms but in general the basic checks will include the following checks
a) The mount table (eg; /etc/mnttab) can be read to check the mount options
b) The NFS mount is mounted with the "hard" option
c) The mount options include rsize>=32768 and wsize>=32768
d) For RAC environments, where NFS disks are supported, the "noac" mount option is used.
Please refer the section -- NFS Mount Options in Oracle® Database Installation Guide10g Release 2 (10.2)
If you have ensured that the mount options are appropriate and still getting the errors then you are encountering symptoms as in Bug 5146667 Fixed In Ver: 11.0. 0.0
分析metalink相關文件,可以得出這個問題影響所有平臺,NFSmount引數可以參考文件提出的rsize=32k, wsize=32k, hard, actimeo=0 。
從相關文件描述看,還是不建議直接使用事件10298,因為這個事件會遮蔽所有的NFS檢查程式碼,這時候如果NFS載入選項不對則可能出現資料損壞的情況。
相關文件
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7591490/viewspace-1033024/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Windows2003 + NFS For RMAN Backup standbydbWindowsNFS
- Oracle Secure BackupOracle
- oracle full database backupOracleDatabase
- oracle cold backup scriptsOracle
- Oracle Backup and Recovery FAQOracle
- Oracle ASM擴容(NFS)OracleASMNFS
- ORACLE RAC with NFS installOracleNFS
- oracle event 2 (zt)Oracle
- 【Oracle】Oracle常用EVENT之三Oracle
- 【Oracle】Oracle常用EVENT之二Oracle
- 【Oracle】Oracle常用EVENT之一Oracle
- Oracle 學習(Rman Backup)Oracle
- ORACLE- Secure Backup DocumentationOracle
- oracle backup & recovery測試Oracle
- Oracle 10g RAC NFSOracle 10gNFS
- Oracle Linux 6.4配置NFSOracleLinuxNFS
- (轉)ORACLE RAC with NFS installOracleNFS
- ORACLE EVENT && ORADEBUGOracle
- ORACLE event和說明Oracle
- ORACLE 配置event引數Oracle
- oracle event 10513作用Oracle
- 設定 oracle event traceOracle
- Oracle常用Event參考Oracle
- ORACLE mount NFS NAS 正確方法OracleNFS
- 增加ORACLE歸檔位置到NFSOracleNFS
- Oracle使用NFS的mount選項OracleNFS
- oracle rac歸檔使用nfs 導致oracle hungOracleNFS
- 使用 oracle 10046 eventOracle
- oracle wait event 等待事件OracleAI事件
- Oracle System Event TriggersOracle
- Oracle V$event_name 整理Oracle
- Oracle EVENT用法參考列表Oracle
- (轉)Oracle EVENT && ORADEBUGOracle
- Oracle 跟蹤事件 set eventOracle事件
- oracle Database Event trace 設定OracleDatabase
- Oracle Wait Event - TuningOracleAI
- oracle 11g rman backup scriptOracle
- 初始 Oracle Secure Backup (OSB) Cloud ModuleOracleCloud