From oracle-l-bounce@freelists.org Thu Feb 26 10:29:58 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1QGTwT31600 for ; Thu, 26 Feb 2004 10:29:58 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i1QGTwo31594 for ; Thu, 26 Feb 2004 10:29:58 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 47D3F3952B6; Thu, 26 Feb 2004 11:29:17 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 26 Feb 2004 11:27:50 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from ahmler1.mail.eds.com (ahmler1.mail.eds.com [192.85.154.71]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E464D397834 for ; Thu, 26 Feb 2004 11:22:14 -0500 (EST) Received: from ahmlir1.mail.eds.com (ahmlir1-2.mail.eds.com [192.85.154.131]) by ahmler1.mail.eds.com (8.12.10/8.12.9) with ESMTP id i1QGPA7I010191 for ; Thu, 26 Feb 2004 11:25:10 -0500 Received: from ahmlir1.mail.eds.com (localhost [127.0.0.1]) by ahmlir1.mail.eds.com (8.12.10/8.12.10) with ESMTP id i1QGPA4V016665 for ; Thu, 26 Feb 2004 11:25:10 -0500 Received: from USAHM102.amer.corp.eds.com ([207.37.138.190]) by ahmlir1.mail.eds.com (8.12.10/8.12.10) with ESMTP id i1QGPAe8016660 for ; Thu, 26 Feb 2004 11:25:10 -0500 Received: by USAHM102.amer.corp.eds.com with Internet Mail Service (5.5.2657.72) id <19SZK0W5>; Thu, 26 Feb 2004 11:25:12 -0500 Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AA18@USAHM018.amer.corp.eds.com> From: "Powell, Mark D" To: "'oracle-l@freelists.org'" Subject: RE: recovery problem, what does this mean Date: Thu, 26 Feb 2004 11:25:09 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C3FC84.CD0BF964" X-archive-position: 2097 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mark.powell@eds.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C3FC84.CD0BF964 Content-Type: text/plain; charset="iso-8859-1" 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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of George Leonard Sent: Thursday, February 26, 2004 10:50 AM To: oracle-l@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@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 " ------_=_NextPart_001_01C3FC84.CD0BF964 Content-Type: text/html; charset="iso-8859-1" Untitled
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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of George Leonard
Sent: Thursday, February 26, 2004 10:50 AM
To: oracle-l@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@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 "
------_=_NextPart_001_01C3FC84.CD0BF964-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------