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: NetApp (was utl_file_dir)

RE: NetApp (was utl_file_dir)

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>

<P><FONT SIZE=3D2>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.</FONT></P>

<P><FONT SIZE=3D2>Alex Hillman</FONT>
</P>

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

<P><FONT SIZE=3D2>Using &quot;time&quot; 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?&nbsp; Knowing = that the database can be available to the user community without = indexes but the &quot;service&quot; 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.</FONT></P>

<P><FONT SIZE=3D2>2 bits worth.</FONT>
<BR><FONT SIZE=3D2>ROR&nbsp; m=AA=BF=AAm</FONT>
</P>

<P><FONT SIZE=3D2>&gt;&gt;&gt; Winnie_Liu_at_infonet.com 12/04/00 07:55PM =
&gt;&gt;&gt;</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>I will agree that both TEMP and INDEX are =
&quot;easy&quot; to rebuild.</FONT>
<BR><FONT SIZE=3D2>You sure that they don't require you to backup RBS? =
It is not easy to</FONT>
<BR><FONT SIZE=3D2>rebuild it at all! :D</FONT>
</P>

<P><FONT SIZE=3D2>Winnie</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Ron Rogers</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: RROGERS_at_galottery.org</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =

California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =

SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from).&nbsp; You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
Received on Wed Dec 06 2000 - 18:14:47 CST

Original text of this message

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