Ask the Expert

Setting up databases

I am trying to set up Oracle databases with size 30GB, 35GB and 20GB on the IBM ESS. Any best practices or suggestions are needed. ESS only allows RAID-5 and I'm planning to use PPRC and Flash Copy.

    Requires Free Membership to View

With only RAID-5 available for your database, your layout is straight-forward. You should separate your indexes and logs while spreading your data archives evenly across physical drives. If you have different size physical drives within the array, you will want to put data, index and logs on the smaller drives to reduce your access density. There is not much more you can do.

With a more advanced array such as HDS Lightning or EMC Symmetrix you would have the option to mix protection schemes. Data, index and logs would be best suited for RAID-1 while archives could be placed on RAID-3/5.

Jim

Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our .bphAaR2qhqA^0@/searchstorage>discussion forums.


This was first published in June 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: