Announcement

Collapse

http://progeeking.com

See more
See less

TTS in Combination with RMAN backups on dataguard

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

    Reference http://bjornnaessens.wordpress.com/2...-on-dataguard/
Working...
X