【RAC】Diskgroup shows offline after restart even it is mounted in ASM instance
Diskgroup resource shows status offline after restart even it is mounted in ASM instance
Applies to:
Oracle Server - Enterprise Edition - Version: 11.2.0.1.0 - Release: 11.2
Information in this document applies to any platform.
Symptoms
After restart the 11.2 HAS stack, the diskgroup (.dg) resource is showing "OFFLINE" status, but diskgroup is mounted in the ASM instance.
For example:
$ crsctl stat res ora.DATA.dg
NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
TARGET=OFFLINE, ONLINE
STATE=OFFLINE, ONLINE on host1
From ASM when you query , the diskgroup shows as mounted.
SQL> conn / as sysdba
Connected.
SQL> select name,state from v$asm_diskgroup;
NAME STATE
------------------------------ -----------
DATA MOUNTED
Changes
From the crsd.log:
2010-02-05 16:05:09.988: [AGFW][56] ora.DATA.dg host1 1 received state from probe request. Old state = UNKNOWN, New state = OFFLINE
From oraagent_oracle.log:
2010-02-05 16:05:09.799: [AGFW][9] ora.DATA.dg host1 1 state changed from: UNKNOWN to: OFFLINE
Cause
This is caused by an unpublished bug 8663101 11.2 DG RES OFFLINE, BUT DISKGROUP MOUNTED AFTER RESTART HAS STACK
The diskgroup is mounted in asm before crsd is up so crsd is never notified of the diskgroup resource start.
Solution
The bug has been fixed in 11.2.0.2 patchset.
Two workarounds available:
1. Manually start the diskgroup:
srvctl start diskgroup -g [-n ""]
或者:
2. Modify the attribute AUTO_START to "always"
crsctl modify resource ora..dg -attr AUTO_START=always
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-706682/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to restore ASM based OCR after complete loss of the CRS diskgroupRESTASM
- Why Archive, FRA Diskgroup Gets Mounted / DismountedHive
- ALERT.LOG for ASM Shows "WARNING: failed to online diskgroup resource ora.GI.dgASMAI
- ORA-15055 ASM Diskgroup Status Showing Dismounted From RDBMS InstanceASM
- rac one node、Single Instance HA(SIHA)、Oracle Restart的概念OracleREST
- Convert a Single-Instance to RAC with ASMASM
- Asm diskgroup 的修復ASM
- script of check repair ASM DISKGROUPAIASM
- How to Restore the Database Using AMDU after Diskgroup CorruptionRESTDatabase
- 給ASM例項增加diskgroupASM
- Oracle 11g RAC 建立例項DBCA無法發現ASM DiskgroupOracleASM
- Manage ASM instance-creating diskgroup,adding/dropping/resizing disks_270066.1ASM
- Login Oracle Instance Even When sysdba Cannot Do SoOracle
- LeetCode之Sum of Even Numbers After Queries(Kotlin)LeetCodeKotlin
- Keep processes running in the background and even after SSH session disconnectsSession
- ASM管理 - 如何重新命名diskgroupASM
- ASM Spfile Is Not Used when ASM Instance StartsASM
- Using FTP Transferring Non-ASM Datafiles to ASM diskgroupFTPASM
- 針對11.2 RAC丟失OCR和Votedisk所在ASM Diskgroup的恢復手段ASM
- To avoid to restart your pc after lotus notes crashed.REST
- oracle asm diskgroup add datafile error problemOracleASMError
- 學習ASM技術(三)--diskgroup管理ASM
- 學習ASM技術(二)--diskgroup管理ASM
- 新建或修改ASM diskgroup 的問題ASM
- How to move ASM database files from one diskgroup to anotherASMDatabase
- votedisk在ASM diskgroup上的存放規律ASM
- ORA-15055: unable to connect to ASM instance 造成 RAC的db不能啟動ASM
- asm 相容性、asm instance 主要引數管理ASM
- 檢查asm磁碟組狀態的檢視v$asm_diskgroupASM
- Linux 磁碟對應 ASM diskgroup 中的磁碟LinuxASM
- 在ASM Diskgroup間移動資料檔案ASM
- 向ASM diskgroup中新增磁碟的例行檢查ASM
- ASM Diskgroup Can Not Be Shown When Creating Database With DBCAASMDatabase
- solaris 10_oracle asm_diskgroup_failgroup_相關OracleASMAI
- 【RAC】11gR2 新特性: Rebootless RestartbootREST
- Failed to restart Polybase Data Movement service after running sp_polybase_join_groupAIREST
- RMAN Duplicate Database From RAC ASM To RAC ASM [ID 461479.1]DatabaseASM
- RAC筆記之instance recovery筆記