-- --Original Message-- --
From: George Leonard [mailto:leonarge@(protected)]
Sent: Thursday, February 26, 2004 8:25 AM
To: oracle-l@(protected)
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@(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
<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 >
<META content= "MSHTML 6.00.2800.1106 " name=GENERATOR > </HEAD >
<BODY >
<DIV > <SPAN class=367184218-26022004 > <FONT face=Arial color=#0000ff size=2 >have
you tried this syntax: </FONT > </SPAN > </DIV >
<DIV > <SPAN class=367184218-26022004 > <FONT face=Arial color=#0000ff
size=2 > </FONT > </SPAN > </DIV >
<DIV > <SPAN class=367184218-26022004 >recover tablespace tsname; </SPAN > </DIV >
<DIV > <SPAN class=367184218-26022004 > </SPAN > </DIV >
<DIV > <SPAN class=367184218-26022004 >instead of </SPAN > </DIV >
<DIV > <SPAN class=367184218-26022004 > </SPAN > </DIV >
<DIV > <SPAN class=367184218-26022004 > </SPAN > </DIV >
<DIV > <SPAN class=367184218-26022004 >alter database recover ... <BR > </DIV > </SPAN >
<DIV class=OutlookMessageHeader dir=ltr align=left > <FONT face=Tahoma
size=2 >-- --Original Message-- -- <BR > <B >From: </B > George Leonard
[mailto:leonarge@(protected)] <BR > <B >Sent: </B > Thursday, February 26, 2004 8:25
AM <BR > <B >To: </B > oracle-l@(protected) <BR > <B >Subject: </B > RE: recovery problem,
what does this mean <BR > <BR > </FONT > </DIV >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 >
