Oracle-L: Re:

From: <JApplewhite_at_austin.isd.tenet.edu>
Date: Wed, 19 Feb 2003 05:58:37 -0800
Message-ID: <F001.00551319.20030219055837@fatcity.com>

Ken,

Do all the following as a way to minimize MTTR (Mean Time To Recovery) for a variety of scenarios and, by the way, they happen to use a lot of disk: ;-)

Mirror your online and archived redo logs to multiple drives
Put backup copies of drive A' datafiles on drive B (or C) and vice versa. Do this on multiple drives as well to guard against multi-disk failure.
Do frequent exports to support object-level recovery.

All that chews up disk and, actually, comes in pretty handy when you need them.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
JApplewhite_at_austin.isd.tenet.edu

                                                                                                           
                      "Ken Heng"                                                                           
                      <kheng_at_au1.ibm.co        To:       Multiple recipients of list ORACLE-L              
                      m>                        <ORACLE-L_at_fatcity.com>                                     
                      Sent by:                 cc:                                                         
                      root_at_fatcity.com         Subject:                                                    
                                                                                                           
                                                                                                           
                      02/18/2003 05:23                                                                     
                      PM                                                                                   
                      Please respond to                                                                    
                      ORACLE-L

Hi,

I was wondering how DBAs are coping with these new large disks that are available....you can purchase 36gb, 72gb, etc. You can fit a whole database on one of these. But with all the performance and redundancy considerations, you wouldn't....so what do you do with the free space? Or how do you tell your bean counter that out of that 72gb you are only going to use 10gb so you need a couple of these?

Rgds, Ken Heng

--

Author: Ken Heng
INET: kheng_at_au1.ibm.com

--

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

Author:
INET: JApplewhite_at_austin.isd.tenet.edu

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 Wed Feb 19 2003 - 07:58:37 CST