DISKGROUP RESOURCE ora.DATA.dg FAILED TO ONLINE ISSUE

I found that my DATA.dg resource was missing and not started.

[oracle@oraASMDR1 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FLASH.dg
               ONLINE  ONLINE       oraasmdr1
ora.LISTENER.lsnr
               ONLINE  ONLINE       oraasmdr1
ora.OCR_VOTE.dg
               ONLINE  ONLINE       oraasmdr1

........ Only  above dg started but DATA dg was missing but in ASM it was mounted.


In ASM alert log file i found below Warning for DATA dg.

SUCCESS: ALTER DISKGROUP ALL MOUNT /* asm agent call crs *//* {0:0:2} */
SQL> ALTER DISKGROUP ALL ENABLE VOLUME ALL /* asm agent *//* {0:0:2} */
SUCCESS: ALTER DISKGROUP ALL ENABLE VOLUME ALL /* asm agent *//* {0:0:2} */
NOTE: Attempting voting file refresh on diskgroup OCR_VOTE
NOTE: Voting file relocation is required in diskgroup OCR_VOTE
NOTE: Attempting voting file relocation on diskgroup OCR_VOTE
Tue May 21 20:56:47 2013
WARNING: failed to online diskgroup resource ora.DATA.dg (unable to communicate with CRSD/OHASD)
Tue May 21 20:56:47 2013




I tried to check with SRVCTL and startup the resource DATA.dg


[oracle@oraASMDR1 trace]$ srvctl status DISKGROUP -g DATA -a
PRCA-1000 : ASM Disk Group DATA does not exist
PRCR-1001 : Resource ora.DATA.dg does not exist
[oracle@oraASMDR1 trace]$ srvctl status DISKGROUP -g +DATA -a
PRCR-1070 : Failed to check if resource ora.+DATA.dg is registered
Invalid resource name
[oracle@oraASMDR1 trace]$ srvctl status DISKGROUP -g DATA -a
PRCA-1000 : ASM Disk Group DATA does not exist
PRCR-1001 : Resource ora.DATA.dg does not exist

Cause


In contrast to previous version of CRS, 11gR2 ASM does not depend on CRSD anymore; rather if OCR is located on ASM, ASM will start before CRSD while clusterware is coming up, and stops after CRSD while clusterware is going down. Due to the new startup sequence, ASM can not update diskgroup resource status in CRSD either during clusterware startup or shutdown, thus above message is logged.

Solution

The message can be ignored, the status of diskgroup and diskgroup resource will be synchronize by oraagent once clusterware is fully up.

To find out diskgroup resource status:

$GRID_HOME/bin/srvctl status diskgroup -g diskgroupname -a

To start or sync diskgroup resource:

$GRID_HOME/bin/srvctl start diskgroup -g diskgroupname



But Still above Solution did not worked  .............
So I have  dimounted and mounted the diskgroup again and then the dg resource were up.



SQL> alter diskgroup data dismount;
Diskgroup altered.
SQL> alter diskgroup data mount;
Diskgroup altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[oracle@oraASMDR1 ~]$ srvctl status diskgroup -g data
Disk Group data is running on oraasmdr1
[oracle@oraASMDR1 ~]$








 

No comments:

Post a Comment