recovery problem, what does this mean 2004-02-26 - By Powell, Mark D
In my experience it means Oracle wants the file listed but was unable to
find it. If the file exists then verify that Oracle has OS level
permissions on the file, the file is located where Oracle is looking for it,
and that the file is not compressed.
Mark
-- --Original Message-- --
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]On
Behalf Of George Leonard
Sent: Thursday, February 26, 2004 10:50 AM
To: oracle-l@(protected)
Subject: recovery problem, what does this mean
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
<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.1400 " name=GENERATOR > </HEAD >
<BODY >
<DIV > <SPAN class=160002316-26022004 > <FONT face=Arial color=#0000ff >In my
experience it means Oracle wants the file listed but was unable to find
it. If the file exists then verify that Oracle has OS level permissions on
the file, the file is located where Oracle is looking for it, and that the file
is not compressed. </FONT > </SPAN > </DIV >
<DIV > <SPAN class=160002316-26022004 > <FONT face=Arial
color=#0000ff > </FONT > </SPAN > </DIV >
<DIV > <SPAN class=160002316-26022004 > <FONT face=Arial
color=#0000ff >Mark </FONT > </SPAN > </DIV >
<BLOCKQUOTE >
<DIV class=OutlookMessageHeader dir=ltr align=left > <FONT face=Tahoma
size=2 >-- --Original Message-- -- <BR > <B >From: </B >
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <B >On
Behalf Of </B >George Leonard <BR > <B >Sent: </B > Thursday, February 26, 2004 10:50
AM <BR > <B >To: </B > oracle-l@(protected) <BR > <B >Subject: </B > recovery problem,
what does this mean <BR > <BR > </FONT > </DIV >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 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 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 by Clicking on this link <A
href= "http://www.vodacom.net/legal/email.asp " >http://www.vodacom.net/legal/email.asp </A >
" </BLOCKQUOTE > </BODY > </HTML >
|
|
