Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: recovery problem, what does this mean

RE: recovery problem, what does this mean

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 26 Feb 2004 11:25:09 -0500
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AA18@USAHM018.amer.corp.eds.com>


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



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

-----------------------------------------------------------------
Received on Thu Feb 26 2004 - 10:29:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US