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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Shared Disk Requirement for Oracle 11g R2 RAC on Windows

User_A7RKTSep 3 2014 — edited Sep 4 2014

Hi,

We are planning for installing Oracle 11g R2 (11.2.0.4) RAC on Windows 2008 R2 servers. We consider using ASM for the shared server.

To my understanding, we need three disks: OCRVoting, FRA, and Data.

The System Admin guy has provided us a single large LUN to the nodes, which is seen by Windows as a single disk.

Is this configuration fair enough? Can we divide the LUN into partitions and care disk groups for ASM on those paritions?

Please advise.

Cheers!

Comments

Levi Pereira

Yes you can, but not recommended for many reasons.


Check docs recommendation:

...

To use direct-attached storage (DAS) or storage area network (SAN) disks for Oracle ASM, each disk must have a partition table.

Oracle recommends creating exactly one partition for each disk that encompasses the entire disk.

Oracle recommends that you limit the number of partitions you create on a single disk to prevent disk contention. Therefore, you may prefer to use extended partitions rather than primary partitions.

...


Refer: http://docs.oracle.com/cd/E11882_01/install.112/e48194/storage.htm#CHDDDBDH


User_A7RKT

Thanks for pointing that out to me.

Now, my intention is to ask our Storage Admin to provide three LUNs as follows:

- OCRVoting Disk: of 3 GB size

- FRA Disk: of 4 GB (we aren't going to enable the DB flashback

- Data disk: depends on the db size.

Is my understanding right?


Thanks in advance.

BPeaslandDBA

The FRA is not required. But it is helpful. If you are going to run in archive log mode, then you will want the FRA or some other archive log destination.

I also create a +REDO disk to separate that from the data. Typically, with ASM, I have the following disk groups at a minimum:

+VOTE  (also holds OCR)

+REDO

+DATA

and then the optional:

+FRA

Cheers,
Brian

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 2 2014
Added on Sep 3 2014
3 comments
1,190 views