TTS in Combination with RMAN backups on dataguard

At a Customer’s site we recently upgraded a database from 10.2.0.5 to 11.2.0.3 by using Transportable Tablespace ( TTS ). This worked flawlessly but we ran into an issue taking backups at the dataguard location of this database.

We followed the normal procedures for being able to take backups on Dataguard and use them for Primary

      • Use a RMAN catalog
      • Register the Primary database
        RMAN> REGISTER DATABASE;
      • Configure the DB Unique Names
        RMAN> CONFIGURE DB_UNIQUE_NAME DB CONNECT IDENTIFIER 'DB_PRIM';
        RMAN> CONFIGURE DB_UNIQUE_NAME DB_DG CONNECT IDENTIFIER 'DB_DG';
        
        RMAN> LIST DB_UNIQUE_NAME OF DATABASE;
        
        List of Databases
        DB Key  DB Name  DB ID            Database Role    Db_unique_name
        ------- ------- ----------------- ---------------  ------------------
        1       DB       336860753        PRIMARY          DB
        1       DB       336860753        STANDBY          DB_DG

At this moment, we can take backups on DB_DG and make them available to DB by changing the unique name in the catalog

RMAN> change backup for db_unique_name DB_DG reset db_unique_name to DB;

However for this one database we can’t seem to do anything with it inside RMAN.

RMAN> show all; 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 04/26/2013 13:58:11
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of partial resync command on default channel at 04/26/2013 13:58:11
RMAN-20999: internal error

RMAN> backup database; 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 04/26/2013 14:05:11
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of partial resync command on default channel at 04/26/2013 14:05:11
RMAN-20999: internal error

This turns out to be Bug 13000553 ( Metalink Id. 13000553.8 ) that occurs when you

  • take backups on dataguard 
  • use TTS
  • Add a datafile to the Tablespace you transported

At the moment of writing there is no fix for this. The only workaround is to take RMAN backups on the Primary Database.

Advertisements