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 -----------------------------------------------------------------