RE: recovery problem, what does this mean

From: "George Leonard" <leonarge@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 26 Feb 2004 18:42:29 +0200
Hi all
 
Making progress,
 
I changed the command to recover datafile 309 
 
This is one of the datafiles from the tablespace.
 
It is working, (it even applied changes that was in the problem archive
log file ?? strange) once this file is done I will do the other.
 
Thanks for the help so far,
 
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of George Leonard
Sent: 26 February 2004 18:25 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: recovery problem, what does this mean
 
The file is definitely there

Taken the error string where the file name is displayed and did a

ls /data3/oradata/networks/archives/networks_t1_s8534.arc

and it returns the file.

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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Eckermann
Sent: 26 February 2004 18:07 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: recovery problem, what does this mean

My 2 cents:

It means that archived log is required for recovery. Most likely it is 
not in the archived log destination fs.
Double check it exists , if it isn't there restore it from tape and 
retry the recovery.


George Leonard wrote:

> SQL> alter database recover tablespace netstats_hourly_data5m1;
> alter database recover tablespace netstats_hourly_data5m1
> *
> ERROR at line 1:
> ORA-00279: change 6641427117202 generated at 02/24/2004 22:11:56
needed
> for
> thread 1
> ORA-00289: suggestion :
> /data3/oradata/networks/archives/networks_t1_s8534.arc
> ORA-00280: change 6641427117202 for thread 1 is in sequence #8534
>
>
> The file listed above def exist.
>
> 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@xxxxxxxxxxxxx
> 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!
>
> "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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
----------------------------------------------------------------- "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 "
RE: recovery problem, what does this mean

Other related posts:
