How to repair a disk in a diskgroup


SUMMARY
========

"DG01" diskgroup cannot be mounted due to one disk member is missing:
======================================================
SQL> ALTER DISKGROUP DG01 MOUNT /* asm agent *//* {1:16801:2} */
NOTE: cache registered group DG01 number=1 incarn=0x2929b317
NOTE: cache began mount (first) of group DG01 number=1 incarn=0x2929b317
NOTE: Assigning number (1,1) to disk (/dev/asm-disk5)
Sat Feb 14 06:41:49 2015
ERROR: no read quorum in group: required 1, found 0 disks
NOTE: cache dismounting (clean) group 1/0x2929B317 (DG01)
NOTE: messaging CKPT to quiesce pins Unix process pid: 7194, image: oracle@SLSLMEDIDBOP01 (TNS V1-V3)
NOTE: dbwr not being msg'd to dismount
NOTE: lgwr not being msg'd to dismount
NOTE: cache dismounted group 1/0x2929B317 (DG01)
NOTE: cache ending mount (fail) of group DG01 number=1 incarn=0x2929b317
NOTE: cache deleting context for group DG01 1/0x2929b317
GMON dismounting group 1 at 18 for pid 29, osid 7194
NOTE: Disk in mode 0x8 marked for de-assignment
ERROR: diskgroup DG01 was not mounted
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DG01" cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DG01"
======================================================


RESEARCH
==========

1) One (“/dev/asm-disk4”) of the disks members shows HEADER_STATUS = PROVISIONED instead of HEADER_STATUS = MEMBER:
======================================================
GROUP_NUMBER DISK_NUMBER MOUNT_S HEADER_STATU MODE_ST OS_MB TOTAL_MB FREE_MB PATH
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
0 0 CLOSED MEMBER ONLINE 512000 0 0 /dev/asm-disk5
0 5 CLOSED PROVISIONED ONLINE 512000 0 0 /dev/asm-disk4
======================================================

2) This is an 11.2.0.3 ASM Standalone configuration:
======================================================
BANNER
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
======================================================

ACTION PLAN
===========

3) Please connect as the grid user and fix the disk as follows:
======================================================
$> id

$> kfed read /dev/asm-disk4 | head -30

$> kfed repair /dev/asm-disk4

$> kfed read /dev/asm-disk4 | head -30
======================================================

4) Mount the diskgroup:
======================================================
SQL> alter diskgroup DG01 mount;
======================================================

Comments

Post a Comment

Popular posts from this blog

How to resolve - ORA-09925: Unable to create audit trail file

When audit directory adump get filled, it prevents application from further connection and throw below error : ERROR: ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 28: No space left on device Additional information: 9925 ORA-02002: error while writing to audit trail ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 28: No space left on device Additional information: 9925 At this stage, as a DBA, you need to urgently resolve the issue because everyone will be calling that they cannot access the database. The first thing to do is to check if the file syste is filled up which might not show you 100% because is only the size defined for audit location is reached when you run df -h. However, the inode of the filesystem has reached 100% and that is why it cannot create further login audit files and so could not allow anyone login to the database until the space is freed. To find out if the inode is filled, run df -ih command on the linux syste
Read more
How to resolve error ORA-15032,ORA-15031,ORA-15025,ORA-15056 when adding a disk to asm. SQL> ALTER DISKGROUP ASM_FRA ADD DISK '/dev/dm-51'; ALTER DISKGROUP ASM_FRA ADD DISK '/dev/dm-51' * ERROR at line 1: ORA-15032: not all alterations performed ORA-15031: disk specification '/dev/dm-51' matches no disks ORA-15025: could not open disk "/dev/dm-51" ORA-15056: additional error message Linux-x86_64 Error: 13: Permission denied Additional information: 42 Additional information: 1927546192 I wanted to add  the following disk: (/dev/dm-51,/dev/dm-52,/dev/dm-53) First check the permissions on this files after the Unix admin has provision it. $ls -lrt /dev/dm* brw-rw---- 1 root disk 253, 19 Jan 31 13:46 /dev/dm-19 brw-rw---- 1 root disk 253, 53 Mar 2 21:04 /dev/dm-53 brw-rw---- 1 root disk 253, 52 Mar 2 21:04 /dev/dm-52 brw-rw---- 1 root disk 253, 51 Mar 2 21:04 /dev/dm-51 brw-rw---- 1 root disk 253, 46 Mar 2 21:12 /dev/dm-46 brw-r
Read more