have you tried this syntax: recover tablespace tsname; instead of alter database recover ... -----Original Message----- From: George Leonard [mailto:leonarge@xxxxxxxxxxxxx] Sent: Thursday, February 26, 2004 8:25 AM To: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Eckermann Sent: 26 February 2004 18:07 PM To: oracle-l@xxxxxxxxxxxxx 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: change 6641427117202 generated at 02/24/2004 22:11:56 needed > for > thread 1 > ORA-00289: suggestion : > /data3/oradata/networks/archives/networks_t1_s8534.arc > ORA-00280: 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@xxxxxxxxxxxxx > 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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> "