UntitledIt means you need the archivelog containing the scn which is in the
archivelog /data3/oradata/networks/archives/networks_t1_s8534.arc. If you
don 't have it you won 't be able to open the database with the current
recovery scenerio.
Ruth
-- --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 "
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML > <HEAD > <TITLE >Untitled </TITLE >
<META http-equiv=Content-Type content= "text/html; charset=iso-8859-1 " >
<META content= "MSHTML 6.00.2800.1400 " name=GENERATOR > </HEAD >
<BODY >
<DIV > <SPAN class=242351216-26022004 > <FONT face=Arial size=2 >It means you need
the archivelog containing the scn which is in the archivelog <FONT
face= "Times New Roman "
size=3 >/data3/oradata/networks/archives/networks_t1_s8534.arc. If you
don 't have it you won 't be able to open the database with the current recovery
scenerio. </FONT > </FONT > </SPAN > </DIV >
<DIV > <SPAN class=242351216-26022004 > </SPAN > </DIV >
<DIV > <SPAN class=242351216-26022004 > <FONT face=Arial
size=2 >Ruth </FONT > </SPAN > </DIV >
<BLOCKQUOTE
style= "PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid " >
<DIV class=OutlookMessageHeader > <FONT 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 >
