RE: recovery problem, what does this mean

From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 26 Feb 2004 16:09:54 +0000
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@xxxxxxxxxxxxx 
> Sent: 26 February 2004 15:50
> To: leonarge@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> 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@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 "
> 
> 



**********************************************************************
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@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
-----------------------------------------------------------------
RE: recovery problem, what does this mean

Other related posts:
