Message-Id: <10702.123877@fatcity.com> From: Alex Hillman Date: Wed, 6 Dec 2000 19:14:47 -0500 Subject: RE: NetApp (was utl_file_dir) 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@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@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@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@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 RE: NetApp (was utl_file_dir)

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@galottery.org]<= /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@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: http://www.orafaq.com
--
Author: Ron Rogers
  INET: RROGERS@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@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 =