From oracle-l-bounce@freelists.org  Thu Feb 26 14:53:11 2004
Return-Path: <oracle-l-bounce@freelists.org>
Received: from air189.startdedicated.com (root@localhost)
 by orafaq.com (8.11.6/8.11.6) with ESMTP id i1QKrAB14343
 for <oracle-l@orafaq.com>; Thu, 26 Feb 2004 14:53:10 -0600
X-ClientAddr: 206.53.239.180
Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180])
 by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i1QKrAo14338
 for <oracle-l@orafaq.com>; Thu, 26 Feb 2004 14:53:10 -0600
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP
 id 4BED0394EE5; Thu, 26 Feb 2004 15:53:44 -0500 (EST)
Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 26 Feb 2004 15:52:38 -0500 (EST)
X-Original-To: oracle-l@freelists.org
Delivered-To: oracle-l@freelists.org
Received: from mfwj032.mfw.is.co.za (mfwj032.mfw.is.co.za [196.35.77.38])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3602539500D
 for <oracle-l@freelists.org>; Thu, 26 Feb 2004 15:52:32 -0500 (EST)
Received: from 168.210.128.88 (Not Verified[168.210.128.88]) by mfwj032.mfw.is.co.za with NetIQ MailMarshal (v5.5.4.16)
 id <BC003ddd7a>; Thu, 26 Feb 2004 22:42:48 +0200
Received: from localhost.localdomain (localhost.localdomain [127.0.0.1])
 by 168.210.128.88 (8.11.6/8.11.6) with SMTP id i1QKT9o27395
 for <oracle-l@freelists.org>; Thu, 26 Feb 2004 22:29:09 +0200
Received: from zamdh02001.vodacom.corp ([10.111.7.52]) by zamdh02002.vodacom.corp with Microsoft SMTPSVC(5.0.2195.6713);
	 Thu, 26 Feb 2004 22:36:41 +0200
X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C3FCA8.3D449C40"
Subject: RE: multiple logsource locations for recovery
Date: Thu, 26 Feb 2004 22:36:40 +0200
Message-ID: <99CEA8FB33554B4BAC372CE602F9B7ED0370D671@zamdh02001.vodacom.corp>
Thread-Topic: multiple logsource locations for recovery
Thread-Index: AcP8m3Jw1V8LVU1WQr6J8ycbZ0A2cAAAAmKgAAMfffA=
From: "George Leonard" <leonarge@vodacom.co.za>
To: <oracle-l@freelists.org>
X-OriginalArrivalTime: 26 Feb 2004 20:36:41.0105 (UTC) FILETIME=[3D621810:01C3FCA8]
Mime-Version: 1.0
X-Mailer-Rocketseed: MTY4LjIxMC4xMjguODg=
X-Mailer-Rocketseed-Counter: 1
X-archive-position: 2166
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-To: oracle-l-bounce@freelists.org
X-original-sender: leonarge@vodacom.co.za
Precedence: normal
Reply-To: oracle-l@freelists.org
X-list: oracle-l
------_=_NextPart_001_01C3FCA8.3D449C40
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Ok ok,
=20
You actually done need a second location
=20
Just use ln -s to create a symbolic link from where the file is to where
oracle expects it.
=20
And although you can only run one instance of recover tablespace <TBS #>
you can run multiple instances of recover datafile <file #>
=20
So this is how you improve on recovery time.
=20
For whoever might have been interested.
=20
George
=20
________________________________________________
=20
George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:george.leonard@za.didata.com
Web:   http://www.didata.co.za
=20
You Have The Obligation to Inform One Honestly of the risk, And As a
Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed & Totally Aware of the Risk,=20
Every Fool Has the Right to Kill or Injure Themselves as They See Fit!
=20
=20
-----Original Message-----
From: oracle-l-bounce@freelists.org
[mailto:oracle-l-bounce@freelists.org] On Behalf Of George Leonard
Sent: 26 February 2004 21:06 PM
To: oracle-l@freelists.org
Subject: multiple logsource locations for recovery
=20
Hi there

Is it possible to set multiple logsource locations.

Say the default location as per the init file and a second location
where you moved files?

George

________________________________________________

George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:george.leonard@za.didata.com
Web: http://www.didata.co.za

You Have The Obligation to Inform One Honestly of the risk, And As a
Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed & Totally Aware of the Risk,=20
Every Fool Has the Right to Kill or Injure Themselves as They See Fit!

"This e-mail is sent on the Terms and Conditions that can be accessed by
Clicking on this link http://www.vodacom.net/legal/email.asp "=20


=93This e-mail is sent on the Terms and Conditions that can be accessed b=
y Clicking on this link http://www.vodacom.net/legal/email.asp "

------_=_NextPart_001_01C3FCA8.3D449C40
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:=
schemas-microsoft-com:office:word" xmlns:st1=3D"urn:schemas-microsoft-com=
:office:smarttags" xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-asci=
i">


<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C3FCB9.0081C600">
<title>Untitled</title>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttag=
s"
=20name=3D"PersonName"/>
<!--[if gte mso 9]><xml>
=20<o:OfficeDocumentSettings>
=20 <o:DoNotRelyOnCSS/>
=20</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
=20<w:WordDocument>
=20 <w:SpellingState>Clean</w:SpellingState>
=20 <w:GrammarState>Clean</w:GrammarState>
=20 <w:DocumentKind>DocumentEmail</w:DocumentKind>
=20 <w:EnvelopeVis/>
=20 <w:Compatibility>
=20  <w:ApplyBreakingRules/>
=20 </w:Compatibility>
=20 <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
=20</w:WordDocument>
</xml><![endif]--><!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
=20/* Font Definitions */
=20@font-face
=09{font-family:Tahoma;
=09panose-1:2 11 6 4 3 5 4 4 2 4;
=09mso-font-charset:0;
=09mso-generic-font-family:swiss;
=09mso-font-pitch:variable;
=09mso-font-signature:1627421319 -2147483648 8 0 66047 0;}
=20/* Style Definitions */
=20p.MsoNormal, li.MsoNormal, div.MsoNormal
=09{mso-style-parent:"";
=09margin:0cm;
=09margin-bottom:.0001pt;
=09mso-pagination:widow-orphan;
=09font-size:12.0pt;
=09font-family:"Times New Roman";
=09mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
=09{color:blue;
=09text-decoration:underline;
=09text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
=09{color:blue;
=09text-decoration:underline;
=09text-underline:single;}
span.EmailStyle17
=09{mso-style-type:personal-reply;
=09mso-style-noshow:yes;
=09mso-ansi-font-size:10.0pt;
=09mso-bidi-font-size:10.0pt;
=09font-family:Arial;
=09mso-ascii-font-family:Arial;
=09mso-hansi-font-family:Arial;
=09mso-bidi-font-family:Arial;
=09color:navy;}
span.SpellE
=09{mso-style-name:"";
=09mso-spl-e:yes;}
span.GramE
=09{mso-style-name:"";
=09mso-gram-e:yes;}
@page Section1
=09{size:612.0pt 792.0pt;
=09margin:72.0pt 90.0pt 72.0pt 90.0pt;
=09mso-header-margin:35.4pt;
=09mso-footer-margin:35.4pt;
=09mso-paper-source:0;}
div.Section1
=09{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
=20/* Style Definitions */=20
=20table.MsoNormalTable
=09{mso-style-name:"Table Normal";
=09mso-tstyle-rowband-size:0;
=09mso-tstyle-colband-size:0;
=09mso-style-noshow:yes;
=09mso-style-parent:"";
=09mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
=09mso-para-margin:0cm;
=09mso-para-margin-bottom:.0001pt;
=09mso-pagination:widow-orphan;
=09font-size:10.0pt;
=09font-family:"Times New Roman";}
</style>
<![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dblue style=3D'tab-interval:36.0pt'=
>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Ok <span class=3DSpellE>ok</span>,<o=
:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>You actually done need a second loca=
tion<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Just use <span class=3DSpellE>ln</sp=
an> &#8211;s
to create a symbolic link from where the file is to where oracle expects =
it.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>And although you can only run one in=
stance
of recover <span class=3DSpellE>tablespace</span> &lt;TBS #&gt; you can r=
un
multiple instances of recover <span class=3DSpellE>datafile</span> &lt;fi=
le #&gt;<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>So this is how you improve on recove=
ry
time.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><span class=3DGramE><font size=3D2 color=3Dnavy face=
=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>For whoever might=
=20have
been interested.</span></font></span><font size=3D2 color=3Dnavy face=3DA=
rial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy'><o:p></o:p></span=
></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'>George</span></font=
><font
color=3Dnavy><span style=3D'color:navy;mso-no-proof:yes'><o:p></o:p></spa=
n></font></p>

<div>

<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New Roman"=
><span
style=3D'font-size:12.0pt;color:navy;mso-no-proof:yes'>&nbsp;<o:p></o:p><=
/span></font></p>

</div>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'>___________________=
_____________________________</span></font><font
color=3Dnavy><span style=3D'color:navy;mso-no-proof:yes'><o:p></o:p></spa=
n></font></p>

<div>

<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New Roman"=
><span
style=3D'font-size:12.0pt;color:navy;mso-no-proof:yes'>&nbsp;<o:p></o:p><=
/span></font></p>

</div>

<p class=3DMsoNormal><st1:PersonName><font size=3D2 color=3Dnavy face=3DA=
rial><span
=20style=3D'font-size:10.0pt;font-family:Arial;color:navy;mso-no-proof:ye=
s'>George
=20Leonard</span></font></st1:PersonName><font size=3D2 color=3Dnavy face=
=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'>=
<br>
Oracle Database Administrator<br>
Dimension Data (Pty) Ltd<br>
(Reg. No. 1987/006597/07)<br>
Tel: (+27 11) 575 0573<br>
Fax: (+27 11) 576 0573<br>
E-mail:</span></font><u><font size=3D2 color=3D"#3366ff" face=3DArial><sp=
an
style=3D'font-size:10.0pt;font-family:Arial;color:#3366FF;mso-no-proof:ye=
s'>george.leonard@za.didata.com</span></font></u><font
size=3D2 color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;font-f=
amily:Arial;
color:navy;mso-no-proof:yes'><br>
Web:&nbsp;&nbsp; <a href=3D"http://www.didata.co.za">http://www.didata.co=
.za</a></span></font><font
color=3Dnavy><span style=3D'color:navy;mso-no-proof:yes'><o:p></o:p></spa=
n></font></p>

<div>

<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New Roman"=
><span
style=3D'font-size:12.0pt;color:navy;mso-no-proof:yes'>&nbsp;<o:p></o:p><=
/span></font></p>

</div>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy;mso-no-proof:yes'>You Have The Obliga=
tion
to Inform One Honestly of the risk, And As a Person<br>
You Are Committed to Educate Yourself to the Total Risk In Any Activity!<=
br>
Once Informed &amp; Totally Aware of the Risk, <br>
Every Fool Has the Right to Kill or Injure Themselves as They See Fit!</s=
pan></font><font
color=3Dnavy><span style=3D'color:navy;mso-no-proof:yes'><o:p></o:p></spa=
n></font></p>

<div>

<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New Roman"=
><span
style=3D'font-size:12.0pt;color:navy;mso-no-proof:yes'>&nbsp;<o:p></o:p><=
/span></font></p>

</div>

<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Times New Roman"=
><span
style=3D'font-size:12.0pt;color:navy;mso-no-proof:yes'>&nbsp;</span></fon=
t><o:p></o:p></p>

</div>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 face=3DT=
ahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<=
br>
<b><span style=3D'font-weight:bold'>From:</span></b>
oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] <b><=
span
style=3D'font-weight:bold'>On Behalf Of </span></b></span></font><st1:Per=
sonName><font
=20size=3D2 face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tah=
oma'>George
=20Leonard</span></font></st1:PersonName><font size=3D2 face=3DTahoma><sp=
an
style=3D'font-size:10.0pt;font-family:Tahoma'><br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 26 February 2004 21:=
06 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> oracle-l@freelists.org=
<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> multiple logsourc=
e
locations for recovery</span></font></p>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'><o:p>&nbsp;</o:=
p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>Hi there<br>
<br>
Is it possible to set multiple logsource locations.<br>
<br>
Say the default location as per the init file and a second location<br>
where you moved files?<br>
<br>
George<br>
<br>
________________________________________________<br>
<br>
George Leonard<br>
Oracle Database Administrator<br>
Dimension Data (Pty) Ltd<br>
(Reg. No. 1987/006597/07)<br>
Tel: (+27 11) 575 0573<br>
Fax: (+27 11) 576 0573<br>
E-mail:george.leonard@za.didata.com<br>
Web: http://www.didata.co.za<br>
<br>
You Have The Obligation to Inform One Honestly of the risk, And As a<br>
Person<br>
You Are Committed to Educate Yourself to the Total Risk In Any Activity!<=
br>
Once Informed &amp; Totally Aware of the Risk, <br>
Every Fool Has the Right to Kill or Injure Themselves as They See Fit!<br=
>
<br>
&#8220;This e-mail is sent on the Terms and Conditions that can be access=
ed by
Clicking on this link&nbsp;<a href=3D"http://www.vodacom.net/legal/email.=
asp">http://www.vodacom.net/legal/email.asp</a>
&quot; <o:p></o:p></span></font></p>

</div>


=93This e-mail is sent on the Terms and Conditions that can be accessed b=
y=20
Clicking on this link&nbsp;<A=20
href=3D"http://www.vodacom.net/legal/email.asp">http://www.vodacom.net/le=
gal/email.asp</A>=20
"
</body>

</html>
=00

------_=_NextPart_001_01C3FCA8.3D449C40--


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------