RE: HP AutoRaid vol configuration

I gotta go with Scott here. Even though we've tweaked out our AutoRAID, it will still take about 12 HOURS to restore 24GB of datafiles from DLT tape. I think the time drops to little under 2 hours on a 4-wide stripe (w/mirror, of course). And you can glean from tbat why we've moved our online redos off of the A-Raid. That did help a lot, but we've got nowhere else to go with the control, temp, and rbs datafiles. Ick.

You'll need a lot of memory to help compensate for the A-Raid. Of course that ain't gonna do you squat when it comes time to restore. With 10 36GBs, I'm guessing your DB to be in the neighborhood of 100GB? Look for almost 2 *DAYS* of downtime to restore from tape. And it WILL happen!

Good luck!

Rich Jesse                          System/Database Administrator
Rich.Jesse_at_qtiworld.com             Quad/Tech International, Sussex, WI USA

-----Original Message-----
Sent: Wednesday, December 12, 2001 07:15 To: Multiple recipients of list ORACLE-L

Autoraid? Abandon all hope of achieveing anything resembling decent throughput. Other than that, go with HP's recommendations.

--Scott

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, December 11, 2001 11:20 PM

> HP 9000/L2000
>
> HP SureStore 12h AutoRaid
>
> 10-36G drives (useable space)
>
> Oracle 8.1.7 (Production box)
> Oracle Apps 11.0.3
> 2 OLTP db with web services
> 1 small data mart
>
> 1) HP recommends 4-6 LUNs. Do I just divide up the storage equally, or is
> there a reason to think about different size LUNs?
>
> 2) Are there reasons to have 4-5 lvols per LUN vs 1 or 2 lvols?
>
> Thanks.
>
> e: dondealy_at_teleport.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).