My Oracle Support Banner

RMAN / SQLplus - Recovery Asking for Very Old Archivelog (Doc ID 837598.1)

Last updated on FEBRUARY 06, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 to 10.2.0.4 [Release 9.2 to 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

 

While RMAN restore and recovery of database in another host failed at recovery
because the archivelog required by RMAN do no longer exist.

Then we use SQLplus for recover and get similar error requesting an very old archivelog which does not exist anymore (archivelog aged out )

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 7996826754 generated at 02/18/2009 15:44:02 needed for thread 1
ORA-00289: suggestion : /PATH/FILE_NAME.log
ORA-00280: change 7996826754 for thread 1 is in sequence #50709          <<--- this is the very old log seq# requested



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.