Disks of Dismounted DG Are Still Hold/Lock By Oracle Process 11.2.0.3_1485163.1
In this Document
Applies to:Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.3 [Release 11.1 to 11.2]Information in this document applies to any platform. SymptomsYou are on 11.2.0.3 or have the fix for the same issue on 11.2.0.2 as described in MOS Doc ID 1306574.1 Still, you are seeing that the disks of the dismounted diskgroup are held by processes. This is not allowing you to copy the VGs of the dismounted diskgroup
In the ASM alert.log you might see the followings
ORA-27061: waiting for async I/Os failed and in the OS logs
May 16 12:59:12 myoda1 kernel: Buffer I/O error on device dm-35, logical block 8
CauseThe diskgroup DATA, used for the test, has these disks:
NOTE: cache opening disk 0 of grp 2: DATA_0000 path:/dev/vgvbsdb1r/rlvol1 There is another diskgroup SYSTEM that has the OCR and Votefiles.
The command lsof/fuser shows the disks are still used:
$ lsof
$ fuser /dev/vgvbsdb1r/rlvol1
IMPORTANT : Note that 'asmcmd lsod' does not list these devices are locked. It just lists the disks of SYSTEM diskgroup that is mounted.
This process keeping the descriptor is: oracle 11920 1 0 Mar 26 ? 0:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
From system state dump the process is seen and it is 'oraagent.bin'
This is discussed in Bug 13869294 : DISMOUNTING DISKGROUP IN ASM BUT DEVICE STILL IN USE BY AN ASM PROCESS closed as duplicate of
Bug 14223113 : ASM DISK NOT RELEASED BY CRSD.BIN PROCESS AFTER DROPPING DISK SolutionBug 14223113 is fixed in 11.2.0.4 onwards The fix for defect 14223113 is not backportable on lower version due to complexity, therefore you should use the mentioned workarounds. This issue is also known to affect 11.1.0.7, although the fix cannot be backported. WORKAROUNDS 1) One workaround is to restart the clusterware. 2) Another workaround is stated below: 2.1] Use the fuser command to find the process which still holds the dismounted disk. 2.2] Run the following SQL in the local ASM instance to ID the corresponding clusterware daemon process responsible
select p.spid FG_OSPID, s.process CL_OSPID, s.program CL_NAME
2.3] Take the following corrective action to close the stale FD's. This can be done while the database is running.
$ crsctl stop res ora.crsd -init
$ crsctl start res ora.crsd -init
o If the daemon process is oraagent.bin, verify whether the agent is a CRSD agent or an OHASD agent by running the following:
$ grep $ORACLE_HOME/log/`hostname`/agent/*/*/*pid
(CL_OSPID is taken from the query output above)
o If the agent is a CRSD agent (pid file found in the agent/crsd/* directory), restarting crsd.bin using the above commands should resolve the issue.
IMPORTANT : If the process is any other process, like background process, then a restart of the instance might be needed. ReferencesNOTE:402526.1 - Asm Devices Are Still Held Open After Dismount or DropBUG:14223113 - ASM DISK NOT RELEASED BY CRSD.BIN PROCESS AFTER DROPPING DISK BUG:13869294 - DISMOUNTING DISKGROUP IN ASM BUT DEVICE STILL IN USE BY AN ASM PROCESS |
|
|
- close_fdpl(3.31 KB)
- readme(0.34 KB)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1442634/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [Oracle Script] ASM Disks Performance metricOracleASMORM
- Oracle ASM Renaming Disks GroupsOracleASM
- Another app is currently holding the yum lock解決方法APP
- oracle??邏輯DG同步卡住,session等待row cache lock的處理過程OracleSession
- Oracle backgroud ProcessOracle
- How to Find which Session is Holding a Particular Library Cache LockSession
- Oracle dedicated server process and shared server processOracleServer
- [Oracle Script] latch holderOracle
- Another app is currently holding the yum lock; waiting for it to exit...APPAI
- yum命令遇到holding 的lock程式 解決辦法
- ORACLE SESSION 和 PROCESSOracleSession
- oracle中修改processOracle
- 【OH】3 Managing Oracle Cluster Registry and Voting DisksOracle
- oracle lock鎖_v$lock_轉Oracle
- I. Disks
- Python多程式之Process、Pool、Lock、Queue、Event、Semaphore、PipePython
- 在oracle裡把backugroupd process叫做oracle的deamon process咋樣Oracle
- [Oracle Script] LockOracle
- About Oracle LockOracle
- oracle enqueue lockOracleENQ
- Oracle Latch & LockOracle
- Oracle:DG 的 switchoverOracle
- oracle dg報錯Oracle
- Why Archive, FRA Diskgroup Gets Mounted / DismountedHive
- yum 提示 Another App is currently holding the yum lock; waiting for it to exit...APPAI
- Find which Session is Holding a Particular Library Cache Lock_122793.1Session
- ORACLE LOCK,LATCH,PINOracle
- ORACLE LOCK MODE 1.2.3.4.5.6Oracle
- Oracle Lock Information QueriesOracleORM
- Dead lock - oracleOracle
- ORACLE lock 轉貼Oracle
- ORACLE查LOCK表Oracle
- oracle lock系列一Oracle
- Oracle DG管理Broker配置Oracle
- Oracle DG 日常點檢Oracle
- Oracle RAC+DG搭建Oracle
- oracle 11gR2 對CRS dg做映象dgOracle
- Oracle backgroud Process【Blog 搬家】Oracle