4 Replies Latest reply: Jan 7, 2013 7:22 AM by Rudi RSS

    Can Split Mirror backups be used for RMAN database duplication?

    Rudi
      Hi
      We running Oracle 11gR2 EE.
      We have storage backup procedures in place,which use Split Mirror technology, i.e BCV
      We want to use RMAN to duplicate the source DB, using the BCV copy
      Is this possible/feasible?
      Rudi
        • 1. Re: Can Split Mirror backups be used for RMAN database duplication?
          Levi Pereira
          Rudi wrote:
          Hi
          We running Oracle 11gR2 EE.
          We have storage backup procedures in place,which use Split Mirror technology, i.e BCV
          We want to use RMAN to duplicate the source DB, using the BCV copy
          Is this possible/feasible?
          Yes is certified.

          Check documentation (withepaper) with your vendor (BCV) about perform backup using BCV and RMAN.

          See this example.
          http://www.emc.com/collateral/software/white-papers/h4262-red-backup-wndw-rcvry-time-oracle-11g-rman-timefinder-clone-wp.pdf

          Is recommended read note below:
          RMAN and Split Mirror Disk Backups [ID 302615.1]

          Regards,
          Levi Pereira
          • 2. Re: Can Split Mirror backups be used for RMAN database duplication?
            mseberg
            Hello;

            Never done it, but since you can detach and mount the storage, you should be able to start the database and use it as a source for duplicate.

            My concern would be conflicts with the tnsnames and listener that is needed for duplicate. If you can account for them you should be good.

            On our SAN we use to do a swap copy. Then I would just change the DBID and I had a copy.

            Best Regards

            mseberg
            • 3. Re: Can Split Mirror backups be used for RMAN database duplication?
              Rudi
              Hi
              Thanks for the reply.
              My intention is not to backup using RMAN from the BCV.Instead I want RMAN to use this BCV as the storage for our reporting DB
              I will elaborate further my intended workflow.
              Btw,the reporting DB will have a new name and all the SqlNet files will be in place.
              Please let me know what you think.
              On the target
              In the existing production server (source) :
              1.Put the DB in backup mode
              2.Split the disks
              3.End backup
              4.Keep record of SCN
              4.Register the new backups as datafile copy
              On the target server (target)
              1.Mount the report DB
              2.perform incomplete recovery the report DB until the SCN
              3.Open resetlogs
              2 issues I'm not sure about :
              a.How to I sync the report DB controlfile,so it will "see" the new backup?
              b.Do I need a RMAN repository?
              Rudi

              Edited by: Rudi on Jan 7, 2013 5:12 AM
              • 4. Re: Can Split Mirror backups be used for RMAN database duplication?
                Rudi
                Just to complete the picture :
                The BCV will be mounted on the reporting server.