My Oracle Support Banner

RMAN Duplicate From Active Database Fails when Source Database is Standby and Patch 11715084 Applied (Doc ID 1522062.1)

Last updated on JUNE 22, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 12.1.0.2 [Release 11.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 10-Dec-2015***

Symptoms

On : 11.2.0.2 version, Recovery Manager

Patch for this bug applied

    <Bug 11715084>:  Active duplicate should work when connected to Standby as source DB

But the following duplicate database fails when the source database is Standby:
     DUPLICATE TARGET DATABASE TO <new database> FROM ACTIVE DATABASE


ERROR
-----------------------
RMAN-05531: a mounted database cannot be duplicated while datafiles are fuzzy

 

Note:
------

RMAN duplicate database using Standby as target - STANDBY to STANDBY or STANDBY to NORMAL.

- It works fine if MRP is "not" running on (source) STANDBY database.  Managed recovery stopped

- It fails if MRP is running on (source) STANDBY database. Managed recovery running

 With errors like:

   RMAN-05531: a mounted database cannot be duplicated while datafiles are fuzzy

  RMAN-06136: ORACLE error from auxiliary database: ORA-01152: file 2 was not restored from a sufficiently old backup
  ORA-01110: data file 2: '/<path>/sysaux.258.824118009'

------ 

 

 

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!


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