Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: recovery problem, what does this mean
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of George Leonard
Sent: Thursday, February 26, 2004 10:50 AM
To: oracle-l_at_freelists.org
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: 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_at_za.didata.com
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> "
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Thu Feb 26 2004 - 10:29:58 CST
-----------------------------------------------------------------
![]() |
![]() |