2 Replies Latest reply on Jun 13, 2014 10:57 AM by Arjun-Oracle

    RMAN Duplicate Database From RAC ASM To RAC ASM exadata

    2616580

      Hi,

       

      based on Doc ID 461479.1


      my source (dnsname : scanA) and target (dnsname : scanB) rac database on different machine.

      db version : 11.2.0.4.6


      parameter on target :

      cluster_database=false

      db_file_name_convert='+DATA_DG/PROD/','+DATA_DG/DEV'

      log_file_name_convert='+DATA_DG/PROD','+DATA_DG/DEV','+RECO_DG/PROD','+RECO_DG/DEV'


      running rman command from target :


      su - oracle

      . .dev_profile

      rman target sys/***@scanA:1521/PROD auxiliary sys/***

      rman> duplicate target database to DEV;

      ...

      starting recover at 10-JUN-14

      using channel ORA_AUX_DISK_1

       

      starting media recovery

      ..

      RMAN-06053: unable to perform media recovery because of missing log

      ...

       

      question : should I configure channel ORA_AUX_DISK_1 on target on rman parameter ?


      any help are very appreciated.


      Thanks and Regards,

      Yohanes Hany

        • 1. Re: RMAN Duplicate Database From RAC ASM To RAC ASM exadata
          tychos

          Hi Yohanes,

          If you didn't copy rman backup pieces between the hosts you could use active database duplication.

          Below you can see an example script.

          R,

          Tycho

          # This script will clone a target database

          # a password file and tns needs to be configured on the target side and source side

          # passwords need to be the same

           

          spool log to '/tmp/duplicate_scanB.txt'

           

          # Connect to the TARGET database

          connect target sys/**@scanA

           

          # Connect to the AUXILIARY database as set by ORACLE_SID

          connect auxiliary sys/**@scanB

           

          CONFIGURE DEVICE TYPE disk PARALLELISM 3;

           

           

          run

          {

             duplicate database to scanB

             from active database

              ;

           

          }

          1 person found this helpful
          • 2. Re: RMAN Duplicate Database From RAC ASM To RAC ASM exadata
            Arjun-Oracle

            review below two metalink notes.

             

            Creating Physical Standby using RMAN Duplicate Without Shutting down The Primary (Doc ID 789370.1)



            Creation Of Rman Duplicate Without Target And Recovery Catalog Connection. (Doc ID 1113713.1)


            -Thanks

            -Arjun B

            1 person found this helpful