Oraclue

Oracle internals, debugging and undocumented features

BUGMAN( RMAN) BUG: RMAN-20242 Duplicate from active database 11g

I was trying to duplicate  production database to development  using  11g feature DUPLICATE DATABASE … FROM ACTIVE DATABASE .

I did it in the past and worked every time but not today..

e.g.

RUN

  ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 
  ALLOCATE AUXILIARY CHANNEL ach1 DEVICE TYPE disk;
  duplicate target database to test from active database;
  }

Scripts will run fine until end and then RMAN will give error

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archived log in the recovery catalog

I tried few times but without success..  Then I have realized that must be issue with archive log destination parameters etc..

The reason my duplicate command  worked in the past is that I did not have data guard configured.RMAN does not like to have  standby archivelog destinations configured.

This is Oracle Bug 6603587.

Workaround:
  For DUPLICATE DATABASE FOR STANDBY FROM ACTIVE, simply avoid using the
  DORECOVER clause.  Logs will ship naturally as part of the standby log
  shipping.

  For DUPLICATE TARGET DATABASE foo FROM ACTIVE, defer all standby destinations
  prior to executing the command.

I think RMAN should be called BUGMAN.

Advertisements

3 responses to “BUGMAN( RMAN) BUG: RMAN-20242 Duplicate from active database 11g

  1. Laksiri September 1, 2009 at 11:15 am

    Please use the tool properly

    Please don’t insult RMAN
    it is a very powerful tool

  2. oraclue September 1, 2009 at 2:21 pm

    Hi Laksiri,

    RMAN is my favorite backup&recovery tool but it has plenty of bugs and I am just exposing them so Oracle development team can fix them.Hopefully you work for them so you can make this tool even better 🙂

    Miladin

  3. www.rmanbackup.com September 12, 2010 at 10:57 am

    Thank you for this precious information about RMAN Technology.

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

%d bloggers like this: