Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ASM Diskgroup Destructive Test

601894Oct 17 2007
I am just going through the DOC..

Should a disk failure occur, ASM automatically rebalances to restore full redundancy for files that had extents on the failed disk. When you replace
the failed disk with a new disk, ASM rebalances the disk group to spread data
evenly across all disks, including the replacement disk.

## Schnario Lost one Failure Group##

If I format means dd one of Disk in diskgroup let's suppose we have

DATADG Diskgroup
it has 2 disk..

/dev/san01_asm_db_01 Failgroup1
/dev/san02_asm_db_01 Failgroup2

While database is running if some one has format /dev/san02_asm_db_01

dd if=/dev/zero of=/dev/san02_asm_db_01 bs=8192

what would be the impact on database?? How do I verify that Diskgroup
is become active with only one failure group.

Since we have formated the disk which is same as plug out and plug-in of disk
so Do I need to add same disk in diskgroup as failure group 2.

using
alter diskgroup add failgroup2 disk =/dev/san02_asm_db_01 ...


## Storage Failure SAN-2
In my second test

If we plug-out SAN-2 which consist all the disk of failgroup 2
then after plug-in Do i need to manullay add all disk in releavent diskgroup/failgroup using
alter diskgroups commands ??

I understand since we have normal redundancy every thing will be operational but I want to know How do I finally fix/recover this disk fail schenario.

Could anyone pls explain this with steps!!
Bharat
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 14 2007
Added on Oct 17 2007
0 comments
827 views