Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Configuring Oracle with RAID and OFA

RE: Configuring Oracle with RAID and OFA

From: <maheswara.rao_at_sungard.com>
Date: Thu, 27 Mar 2003 13:44:18 -0800
Message-ID: <F001.00574C64.20030327134418@fatcity.com>


Rich,

How did you manage to take hot backups in 90 seconds for 6 GB db size?

If you could shed light on the technique, it would be helpful to us. We might also consider your approach, if feasible on our systems.

TIA, Rao

-----Original Message-----
Sent: Thursday, March 27, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L

FWIW, we've got an 8.1.7 system set up on Solaris8. The whole whopping 6GB of datafiles are spread across a 6-wide RAID 0+1, with redos and archives on their own 0+1s.

Our hotbacks take 90 seconds.

OTOH, our 28GB ERP system on an HP AutoRAID 12H takes over 2.5 hours. I'd like to be done with that in 7 minutes, extrapolating from our other system, not to mention the performance increase for our users (system-wide waits average in the 100s during the day due to physical I/O, but that's a whole other kettle of worms).

:)

Rich

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



--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <maheswara.rao_at_sungard.com
  INET: maheswara.rao_at_sungard.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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). Received on Thu Mar 27 2003 - 15:44:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US