RE: multiple logsource locations for recovery

From: George Leonard <leonarge_at_vodacom.co.za>
Date: Thu, 26 Feb 2004 22:36:40 +0200
Message-ID: <99CEA8FB33554B4BAC372CE602F9B7ED0370D671@zamdh02001.vodacom.corp>

Ok ok,

You actually done need a second location

Just use ln -s to create a symbolic link from where the file is to where oracle expects it.

And although you can only run one instance of recover tablespace <TBS #> you can run multiple instances of recover datafile <file #>

So this is how you improve on recovery time.

For whoever might have been interested.

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_at_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, Every Fool Has the Right to Kill or Injure Themselves as They See Fit!

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of George Leonard Sent: 26 February 2004 21:06 PM
To: oracle-l_at_freelists.org
Subject: multiple logsource locations for recovery

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

"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 "

“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 "

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

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------

Received on Thu Feb 26 2004 - 14:53:11 CST