RE: NetApp (was utl_file

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Wed, 6 Dec 2000 19:14:47 -0500
Message-Id: <10702.123877@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C05FE2.B51AE940
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

If you have enough memory to give the session sort_area_size 1gig = memeory
and temp, data and index tablespaces on the different spindles and = create
indes as nologging - it will be done in minutes.

Alex Hillman

-----Original Message-----
From: Ron Rogers [mailto:RROGERS_at_galottery.org] Sent: Tuesday, December 05, 2000 9:06 AM To: Multiple recipients of list ORACLE-L Subject: RE: NetApp (was utl_file_dir)

Using "time" as a factor that we all are judged by... Is it quicker to backup the INDX datafiles and restore them if needed OR create the = indexes
after a restore? Knowing that the database can be available to the = user
community without indexes but the "service" will be degraded and poor = at
best. The creation of some indexes can take longer than the restore = from
backup along with the data restore. It takes 4 =BD hrs to backup 68 GIG = to
tape and takes 4 =BD hrs to do a full restore. It takes approx 6 hrs = just to
do 1 of the large indexes on the 6 GIG table.

2 bits worth.
ROR m=AA=BF=AAm

>>> Winnie_Liu_at_infonet.com 12/04/00 07:55PM >>>

I will agree that both TEMP and INDEX are "easy" to rebuild. You sure that they don't require you to backup RBS? It is not easy to rebuild it at all! :D

Winnie

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
Author: Ron Rogers
INET: RROGERS_at_galottery.org

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).

------_=_NextPart_001_01C05FE2.B51AE940
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: NetApp (was utl_file_dir)</TITLE>
</HEAD>
<BODY>

If you have enough memory to give the session =
sort_area_size 1gig memeory and temp, data and index tablespaces on the = different spindles and create indes as nologging - it will be done in = minutes.

Alex Hillman


-----Original Message-----
 From: Ron Rogers [<A =
HREF=3D"mailto:RROGERS_at_galottery.org">mailto:RROGERS_at_galottery.org</A>]<= /FONT>
 Sent: Tuesday, December 05, 2000 9:06 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: NetApp (was utl_file_dir)

 

Using "time" as a factor that we all are =
judged by... Is it quicker to backup the INDX datafiles and restore = them if needed OR create the indexes after a restore?  Knowing = that the database can be available to the user community without = indexes but the "service" will be degraded and poor at best. = The creation of some indexes can take longer than the restore from = backup along with the data restore. It takes 4 =BD hrs to backup 68 GIG = to tape and takes 4 =BD hrs to do a full restore. It takes approx 6 hrs = just to do 1 of the large indexes on the 6 GIG table.

2 bits worth.
 ROR  m=AA=BF=AAm


>>> Winnie_Liu_at_infonet.com 12/04/00 07:55PM =
>>>

 

I will agree that both TEMP and INDEX are =
"easy" to rebuild.
 You sure that they don't require you to backup RBS? =
It is not easy to
 rebuild it at all! :D


Winnie

 

-- 
 Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>
 -- 
 Author: Ron Rogers
   INET: RROGERS_at_galottery.org


Fat City Network Services    -- (858) =
538-5051  FAX: (858) 538-5051
 San Diego, =

California        -- Public Internet = access / Mailing Lists
 <FONT =

SIZE=3D2>---------------------------------------------------------------=

-----
 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 =
Received on Wed Dec 06 2000 - 18:14:47 CST