RE: recovery problem, what does this mean

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 26 Feb 2004 16:09:54 +0000
Message-Id: <s03e1a66.014@bristol21.bristol.ac>

It's telling you that the next redo log had a sequence number of 8534. based on your naming convention it expects the redo to be in networks_t1_s8534.arc. If that file is there then I'd be a little bit concerned that it might be unreadable. Obviously the first thing to check would be permissions on that file. I'd also look at the alert log to see if there were any errors relating to archiving at 22:11 last night.

Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805

> -----Original Message-----
> From: leonarge_at_vodacom.co.za
> Sent: 26 February 2004 15:50
> To: leonarge_at_vodacom.co.za; 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 "
>
>

---

This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or
professional privilege. Any dissemination, distribution, copyright or use of this
communication without prior permission of the sender is strictly prohibited.

---

---

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 - 11:20:25 CST