Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I inherited a production system with the following setup:

  • Disk A, Failgroup AB
  • Disk B, Failgroup AB
  • Disk C, Failgroup CD
  • Disk D, Failgroup CD

Diskgroups AB and CD are configured with normal redundancy.

All disks are the same size. A and B share a common failure point, that is, it'd be unsafe for physical config reasons to make B a redundant version of A. Same for disks C and D.

If A and B's common failure point occurs and I lose disks A and B, what will happen to my database instance?

I've heard conflicting things:

  1. ASM will halt the database because it can't maintain it's redundancy configuration.
  2. ASM will attempt to use C and D and somehow rebalance the data from A and B.
  3. ASM will issue an alert and continue to allow things to run.

So what will happen? Is the result configurable?

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.