Re: RAC ASM question

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Tue, 6 Mar 2007 06:45:47 -0800 (PST)
Message-ID: <20070306144547.90165.qmail@web51301.mail.yahoo.com>

Thanks Rajeev and yes I had checked that very good paper. I know it has recommended that we should have only two DG for RACor Signle Instance like for DB file and one for FlashRecovey Area but the paper was written in 2004 with 10g Release 1 and so there might be any such recommendation for 10g Rel 2 or so.

Tx
Sanjay

Rajeev Prabhakar <rprabha01_at_gmail.com> wrote:

Sanjay,

If you haven't already, you may want to go through the ASM best practices whitepaper.

http://www.oracle.com/technology/products/database/asm/pdf/asm_bestpractices_9_7.pdf

-Rajeev

On 3/5/07, Sanjay Mishra <smishra_97_at_yahoo.com> wrote: Thanks Salem. Is there any benchmark or result or best practices that says that don't create more than x number of DG.

Sanjay

Ghassan Salem <salem.ghassan_at_gmail.com> wrote:

Sanjay,

You can do it either way. The right way depends on your disks and disk layout. If you'll end up with the same disks in different diskgroups, I do not see the utility of using several ones. Having one DG allows for better spread of I/O. Having several DGs allows for more control on when to use redundancy (depending on app requirement, ...) It's better to have a DG for FRA, as it's usage and redundancy req are different than 'normal' data. rgds

On 3/3/07, Sanjay Mishra <smishra_97_at_yahoo.com > wrote: Hi

I am building a RAC environment which will host 3 Application Database. I am planning to create 4 Oracle Home like one for each Database and 4th one for ASM. This way I can patch any one without affecting others.

Now in order to ceate the Database in ASM, Can I create seperate Disk Group for each Application Database or I should create one big Disk Group.
What are the advantage/disadvantage of creating multiple diskgroups.
Is it good to create seperate Diskgrroup for each Redolog, Archivelog, Flashback and Data

TIA
Sanjay

Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.

Don't be flakey. Get Yahoo! Mail for Mobile and always stay connected to friends.

Food fight? Enjoy some healthy debate
in the Yahoo! Answers Food & Drink Q&A.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 06 2007 - 08:45:47 CST