RMAN Fails to find Long Term Archival Backup older than retention policy (Doc ID 2001582.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

A long term archival backup is created with  "KEEP UNTIL TIME" specifying a date 10 years ahead in time.
No recovery catalog is used.  A subsequent attempt to restore from this backup fails:

 

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/14/2015 05:40:05
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
..etc

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms