Q

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.

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

Dig deeper on Data management tools

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchSolidStateStorage

SearchVirtualStorage

SearchCloudStorage

SearchDisasterRecovery

SearchDataBackup

Close