RMAN DUPLICATE ERRORS WITH RMAN-5565 - SPFILE NO FOUND (Doc ID 874202.1)

Last updated on AUGUST 12, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

An attempt to perform a duplicate using 11GR2 feature of not connecting to a catalog or target can result in the following error:

DUPLICATE DATABASE TO dupdb
UNTIL TIME "TO_DATE('06/23/2009 14:45:00', 'MM/DD/YYYY HH24:MI:SS')"
SPFILE
BACKUP LOCATION '/recovery_area'
NOFILENAMECHECK;

Starting Duplicate Db at 2009/06/23 15:52:31
RMAN-571: ===========================================================
RMAN-569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-571: ===========================================================
RMAN-3002: failure of Duplicate Db command at 06/23/2009 15:52:31
RMAN-5565: SPFILE backup created before TO_DATE('06/23/2009 14:45:00', 'MM/DD/YYYY HH24:MI:SS') not found in /recovery_area



OR

RMAN-03002: failure of Duplicate Db command
RMAN-05579: CONTROLFILE backup not found in '/recovery_area'

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