RMAN-06094 ON DUPLICATED DATABASE FOR RO FILES DURING RECOVERY (Doc ID 1934420.1)

Last updated on OCTOBER 31, 2016

Applies to:

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

Symptoms

Recovery of a database that was created by duplicating from another database with RO tablespaces fails if the controlfile has also been restored:

RMAN-03090: Starting recover at 28-jul-14 16:40:10
RMAN-12016: using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/28/2014 16:40:15
RMAN-06094: datafile 6 must be restored


Where the file# identified is the first RO datafile.

If the controlfile is NOT restored ie it is a CURRENT controlfile then recovery is successful:

RMAN> recover database;

Starting recover at 29-jul-14 10:35:37
using channel ORA_DISK_1
datafile 6 not processed because file is read-only

starting media recovery
..
Finished recover at 29-jul-14 10:35:41

 

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