George, have you issued the command 'set auto on ' ? Or just hit return
in response to this prompt?
Lisa Koivu
Monkey Mama
Orlando, FL, USA
-- --Original Message-- --
From: George Leonard [mailto:leonarge@(protected)]
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 "
"The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender 's business entity is not liable for any loss or damage arising in any way from this message or its attachments. "
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<html >
<p class=MsoNormal > <font size=2 color=navy face=Arial > <span style= 'font-size:
10.0pt;font-family:Arial;color:navy ' >George, have you issued the command ‘set
auto on’ ? Or just hit return in response to this prompt? </span > </font > </p >
<p class=MsoNormal style= 'margin-left:.5in ' > <font size=3 face= "Times New Roman " > <span
style= 'font-size:12.0pt ' >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 >
" </span > </font > </p >
</div >
</body >
<P align=center > <FONT face=Tahoma size=2 > <FONT color=#0000ff > "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender 's business entity is not liable for any loss or damage arising in any way from this message or its attachments. " </FONT > </FONT > </P > </html >
