RMAN DUPLICATE FROM Active Database From Standby ends with ORA-01671

Hi.

Quite interesting question was asked by one of our customers:

“Is it possible/supported to do RMAN DUPLICATE FOR STANDBY FROM ACTIVE DATABASE when TARGET is STANDBY ?”

It’s really seasonable question, especially when You already have standby database and wanna refresh a development environment using standby as a source/target to not stress primary database .

There are no such restriction in 11.2 “Prerequisites Specific to Active Database Duplication”, so why not ? 😉

But even Oracle wanted to provide mentioned functionality it’s not often used(tested), so let’s see what we get as a result

You may follow Complete Step by Step process of RMAN DUPLICATE FROM… Active Standby.

Here I’ll post only relevant steps with resulting error messages.

run {
allocate channel prmy1 type disk;
allocate auxiliary channel stby type disk;

duplicate target database for standby from active database


}

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/23/2012 15:10:56
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on prmy1 channel at 03/23/2012 15:10:56
ORA-01671: control file is a backup, cannot make a standby control file

So RMAN wants to do one more backup control file, but is unable to do it because we already have one because of connected to standby as a target…

So what says MOS ?

OK, there is a NOTE: 1343515.1 RMAN ACTIVE DUPLICATE WHEN CONNECTED TO STANDBY AS TARGET

“The DUPLICATE FROM ACTIVE DATABASE using a Standy database as TARGET is  fixed by

Bug 11715084 ACTIVE DUPLICATE SHOULD WORK WHEN CONNECTED TO STANDBY AS SOURCE DB
and is fixed in 12.1 and 11.2.0.3 and some one-off patches are available for 11.2.0.2. : Patch 11715084

BUG:11715084 actually describes another situation because of different error message:

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

but You may read latest update for this post at the bottom where I confirm that fix for this BUG also fix my original error(ORA-01671)

So what we have?

  • it’s intended behaviour in 11.2 to support such case of DUPLICATE – that’s good!
  • someone has tested it with 11.2.0.2 and filled SR after failure (Someone has mentioned this issue with 11.2.0.1 here, but without any luck)
  • MOS NOTE states that it’s fixed in 12.1 and 11.2.0.3. I haven’t seen 12.1 yet, but it definitely doesn’t work with 11.2.0.3 – like in my environment.
  • BUG 11715084 is not among the Bugs fixed in the 11.2.0.3 Patch Set, so I suspect that NOTE have to state about 11.2.0.4 patchset
  • current(as of 23-MAR-2012) status on BUG:11715084 is “80 – Development to Q/A“, so how can it be fixed in 11.2.0.3 released in September-2011 ?

PS:

  • it’s really very interesting/useful feature when it will work as intended
  • it’s not critical issue and different workarounds may be used

UPDATE(9-JUL-2012):

  • according to changes in document Bug 11715084 – Active duplicate should work when connected to Standby as source DB, this BUG will be fixed in 11.2.0.4, but now there are already some backports over 11.2.0.2 and one over 11.2.0.3.2 for Linux x86-64 – check PATCH:11715084I’ll check it and provide feedback here

UPDATE(25-JUL-2012):

  • I have checked proposed fix and confirm that it works fine after applying PATCH:11715084, so mentioned issue has working fix now and may be used as the procedure of creating cascading standbys.
Advertisements

5 thoughts on “RMAN DUPLICATE FROM Active Database From Standby ends with ORA-01671

  1. I’d like to install this patch on 11.2.0.3.3. I wonder what is proper order of installation?
    a) 11.2.0.3 + 11.2.0.3.3 + 11715084
    b) 11.2.0.3 + 11.2.0.3.2 + 11715084 +11.2.0.3.3 ( hope the patch 11715084 will not be uninstalled ) + and in the future 11.2.0.3.4 ….

    • Grzegorz,
      You can’t go with installation of 11715084 over 11.2.0.3.3 right now, because it requires 11.2.0.3.2
      installing 11.2.0.3.3[4] will require rolling back of 11.2.0.3.2 with 11715084
      So, you have to fill SR with request of ‘Patch:11715084 on top of 11.2.0.3.3[4]’ for your platform
      or just wait for 11.2.0.4 – I think it will be available in a 2-3 months or even earlier.

      • Scenario

        a) 11.2.0.3 + 11.2.0.3.3 + 11715084

        has been confirmed by Oracle Support.
        I’ve installed it without problems.

        I’m going to test it now.

  2. Pingback: RMAN DUPLICATE FROM Active Standby Database | Asian DBA

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s