This discussion is archived
3 Replies Latest reply: Dec 27, 2012 9:07 AM by jcnars RSS

Create a new Standby db from a backup taken in an existing standby.

jcnars Newbie
Currently Being Moderated
Existing 2 sites: PROD (primary)), Local-standby.
Planning to add a 3rd site: Remote-standby

How do you use a full backup taken in the Local-standby (not the primary) to create the Remote-standby?
Any pointers will be appreciated...essentially creating a standby from a standby.

It may be of interest to note that running the "BACKUP CURRENT CONTROLFILE FOR STANDBY" in the Local-standby will error out with:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dupdb_ch1 channel at 11/30/2012 19:49:44
ORA-01671: control file is a backup, cannot make a standby control file

Thanks
  • 1. Re: Create a new Standby db from a backup taken in an existing standby.
    mseberg Guru
    Currently Being Moderated
    Options

    Go to the Primary database and then create "CONTROLFILE FOR STANDBY" and transfer it to the 2nd standby database.

    Check this MOS note :

    1343515.1 RMAN ACTIVE DUPLICATE WHEN CONNECTED TO STANDBY AS TARGET

    Understanding ORA-01671 error during controlfile creation / backup [ID 461121.1]

    Best Regards

    mseberg
  • 2. Re: Create a new Standby db from a backup taken in an existing standby.
    jcnars Newbie
    Currently Being Moderated
    Thanks for the response.

    I did that ("backup current control file for standby") from prim and ftp to standby.
    In which case, the duplicate doesn't see the backup that was taken in the primary.

    The Primary does not know about the backup triggered from the Local-standby.

    Tried "catalog resync from DB_UNIQUE_NAME all" and still, when i run the duplicate command, it tries to find the backup that was triggred from the Primary node.
  • 3. Re: Create a new Standby db from a backup taken in an existing standby.
    jcnars Newbie
    Currently Being Moderated
    For folks who may stumble on this thread.
    2 hosts - 1 - primary, 2 - local stby
    3rd host was being added in the mix.
    So, we want to build standby number 3 - DR stby

    Aim was to create the DR stby from a backup taken from local stby, W/O affecting primary.

    Create backup pieces from local stby (to be made available in DR stby) using "backup device type disk format '/u01/backups' database plus archivelog;"
    As mseberg pointed out, take a "backup current controlfile for standby" from primary & make it available in DR stby
    startup nomount the DR stby
    restore controlfile in DR from step2
    catalog the backup taken in step 1
    Run the duplicate command from DR as usual, connecting to the primary as target and the DR as auxiliary

    Enjoy

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points