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

    Login

    When you register for SearchStorage.com, you’ll also receive targeted emails from my team of award-winning editorial writers. Our goal is to keep you informed on the hottest topics, the latest news and the biggest challenges you face as a storage professional today.

    Rich Castagna, Editorial Director

    By submitting your registration information to SearchStorage.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchStorage.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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