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@(protected)
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@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of David Eckermann
Sent: 26 February 2004 18:07 PM
To: oracle-l@(protected)
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 (See ORA-00279.ora-code.com): change 6641427117202 generated at 02/24/2004 22:11:56
needed
> for
> thread 1
> ORA-00289 (See ORA-00289.ora-code.com): suggestion :
> /data3/oradata/networks/archives/networks_t1_s8534.arc
> ORA-00280 (See ORA-00280.ora-code.com): 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@(protected)
> 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
?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 "
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML >
<HEAD >
<META http-equiv= "Content-Type " content= "text/html; charset=iso-8859-1 " >
<TITLE >Untitled </TITLE >
</HEAD >
<BODY >
The file is definitely there <br > <br >Taken the error string where the file name is displayed and did a <br > <br >ls /data3/oradata/networks/archives/networks_t1_s8534.arc <br > <br >and it returns the file. <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@(protected) <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 & Totally Aware of the Risk, <br >Every Fool Has the Right to Kill or Injure Themselves as They See Fit! <br > <br > <br > <br >-- --Original Message-- -- <br >From: oracle-l-bounce@(protected) <br >[mailto:oracle-l-bounce@(protected)] On Behalf Of David Eckermann <br >Sent: 26 February 2004 18:07 PM <br >To: oracle-l@(protected) <br >Subject: Re: recovery problem, what does this mean <br > <br >My 2 cents: <br > <br >It means that archived log is required for recovery. Most likely it is <br >not in the archived log destination fs. <br >Double check it exists , if it isn 't there restore it from tape and <br >retry the recovery. <br > <br > <br >George Leonard wrote: <br > <br > > SQL > alter database recover tablespace netstats_hourly_data5m1; <br > > alter database recover tablespace netstats_hourly_data5m1 <br > > * <br > > ERROR at line 1: <br > > ORA-00279 (See ORA-00279.ora-code.com): change 6641427117202 generated at 02/24/2004 22:11:56 <br >needed <br > > for <br > > thread 1 <br > > ORA-00289 (See ORA-00289.ora-code.com): suggestion : <br > > /data3/oradata/networks/archives/networks_t1_s8534.arc <br > > ORA-00280 (See ORA-00280.ora-code.com): change 6641427117202 for thread 1 is in sequence #8534 <br > > <br > > <br > > The file listed above def exist. <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@(protected) <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 <br >Activity! <br > > Once Informed & Totally Aware of the Risk, <br > > Every Fool Has the Right to Kill or Injure Themselves as They See Fit! <br > > <br > > "This e-mail is sent on the Terms and Conditions that can be accessed <br > > by Clicking on this link http://www.vodacom.net/legal/email.asp " <br > <br > <br >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <br >Please see the official ORACLE-L FAQ: http://www.orafaq.com <br >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <br >To unsubscribe send email to: oracle-l-request@(protected) <br >put 'unsubscribe ' in the subject line. <br >-- <br >Archives are at http://www.freelists.org/archives/oracle-l/ <br >FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html <br >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
?This e-mail is sent on the Terms and Conditions that can be accessed by
Clicking on this link <A
href= "http://www.vodacom.net/legal/email.asp " >http://www.vodacom.net/legal/email.asp </A >
"
</BODY > </HTML >
