Re: recovery problem, what does this mean

  • From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 26 Feb 2004 11:12:41 -0500

Very simple: you have autorecovery set to on and oracle cannot find the 
requested archive on ARCHIVE_LOG_DEST. You can either restore the file from
tape, CD or DVD to the archive destination and re-run the command or 
restore it somewhere else and set autorecovery to off, which will cause oracle
to start prompting you for each archive file. If the backup that you used
to restore files is not from the period before 07/04/1776, then there shouldn't 
be too many files to type in for a single tablespace. If your backup is older
then that, you should change your LANG variable to en_GB before starting 
reccovery.

On 02/26/2004 10:50:11 AM, George Leonard wrote:
> 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 "
> 
----------------------------------------------------------------
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
-----------------------------------------------------------------

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2004