ASM Recovery on RAC

From: Ygnacy <ygnacy_at_poczta.onet.pl>
Date: Fri, 04 Sep 2009 10:28:29 +0200
Message-ID: <h7qj3f$adu$3_at_inews.gazeta.pl>



Hi,  

I have 2 instances of Oracle RAC.
All disk resources on which problem occured are exported via iSCSI and managed by ASM.
One of the iSCSI server had a power faiure, which last longer than 6h

DISKGROUP DATA is mirrored via ASM between /dev/raw/11 and /dev/raw/raw21

in v$asm_disk i have

DATA_0000	MEMBER	/dev/raw/raw11
_DROPPED_0001_DATA	UNKNOWN ''
''	MEMBER	/dev/raw/raw21


DATA_0001 should have path /dev/raw/raw21

To recover database, should i do :
alter diskgroup DATA DROP DISK _DROPPED_0001_DATA FORCE; and then
ALTER DISKGROUP DATA ADD DISK '/dev/raw/raw21' FORCE;

or just
ALTER DISKGROUP DATA ADD DISK '/dev/raw/raw21' FORCE;

or there is some other scenario for rocovery

-- 
Regards
Ygnacy
Received on Fri Sep 04 2009 - 03:28:29 CDT

Original text of this message