3 Replies Latest reply: Dec 27, 2012 11:07 AM by jcnars RSS

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

    jcnars
      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
          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
            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
              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