Need to configure Oracle ASM to mirror accross 2 external storage arrays.

Posted on 2012-08-10
Last Modified: 2012-10-16
I am looking for instruction on how to configure Oracle ASM to be redundant across 2 direct attached storage arrays.

DB server design:
ASM is configured for a stand alone rac or cluster.
The server has 2 direct attached SAS storage arrays.
Each external array is connected to its own HBA card in the server.

ASM design:
We want to have ASM be redundant across the 2 external arrays...the goal is to not lose the DB in case one of the arrays fails (for whatever reason).

Please please please do not suggest other designs. This design is locked in stone for the project I am working on and can't be changed.

I am looking only for instructions on how to make ASM be mirrored across the 2 external arrays.

Thanks in advance to any who post answers.
I am not a DBA, just a poor sysadmin who got stuck making this work.
Any help is greatly appreciated.
Question by:afcnoc
    LVL 34

    Accepted Solution

    ASM is not my strong suit.  I haven't worked with it that much.  I will point you to the documentation:

    What you are looking for is failure groups.  I believe you should set up 2 failure groups, one for each array.  In that case, my understanding is that the data will be mirrored in such a way that you can lose one and keep running.

    Author Comment

    Thanks for the comment.
    I'll take a look at that link today.

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now