 | | | recovery problem, what does this mean | recovery problem, what does this mean 2004-02-26 - By Niall Litchfield
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@(protected)
> Sent: 26 February 2004 15:50
> To: leonarge@(protected); oracle-l@(protected)
> 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 (See ORA-00279.ora-code.com): change 6641427117202 generated at 02/24/2004
> 22:11:56 needed
> for
> thread 1
> ORA-00289 (See ORA-00289.ora-code.com): suggestion :
> /data3/oradata/networks/archives/networks_t1_s8534.arc
> ORA-00280 (See ORA-00280.ora-code.com): 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@(protected)
> 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|