3 Replies Latest reply: Nov 26, 2012 8:08 AM by moreajays RSS

    RAC to RAC CLONE FROM RMAN Cold Backup

    859515
      Hi All,

      I need your kind assistance in Cloning my Oracle RAC 11.2.0.2 Environment to remote host. Following is Disk layout

      DGVOT (ASM Disk group holding OCR and Voting Disk)
      DGDATA (ASM Disk Group Holding Data FIles)
      DGFRA (ASM Disk Group Holding Fast Recovery FIles)

      Remote Host is on different location so cannot use RMAN duplicate with auxiliary channel.
      Have luxury of downtime so I want to take RMAN Consistent( Cold Backup)

      SAME Disk layout is available to remote hosts.

      11.2.0.2 CLusterware (GI) Plus the oracle binaries are already installed.

      Can any body tell me the steps to
      1) How to take cold backup to disk so that I can tar and copy to remote host
      2) clone the database on remote host
      3) How i will add the database listener and other resources of this databasee to clusterware.

      actually this is my first RAC clone so i am not much aware of detail steps.


      I have gone though many metalink notes but no one is matching with my requirements. your expert advice will help me a lot

      Regards,
        • 1. Re: RAC to RAC CLONE FROM RMAN Cold Backup
          moreajays
          Hi

          1) How to take cold backup to disk so that I can tar and copy to remote host.
          Use Rman for cold backup
          In mount stage execute
          RMAN>backup database plus archivelog format '<disk_path>/dbp%U';
          RMAN> backup current controlfile format '<disk_path>/ctl%U';

          Copy thse backup sets to remote host

          2) clone the database on remote host

          Create Similar ASM Disk groups as on source
          create pfile/spifile, startup instance in nomount mode
          catalog backup set

          RMAN> catalog start with '<backup_set location>';

          Restore controlfile

          RMAN>restore controlfile;

          RMAN> restore database;

          RMAN> recover database;

          On successfull recovery

          RMAN>sql 'alter database open';

          3) How i will add the database listener and other resources of this databasee to clusterware.

          User srvctl to add resources

          Usage: srvctl <command> <object> [<options>]
          commands: enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config|convert|upgrade
          objects: database|instance|service|nodeapps|vip|network|asm|diskgroup|listener|srvpool|server|scan|scan_listener|oc4j|home|filesystem|gns|cvu
          For detailed help on each command and object and its options use:
          srvctl <command> -h or
          srvctl <command> <object> -h



          Thanks,
          Ajay More
          • 2. Re: RAC to RAC CLONE FROM RMAN Cold Backup
            859515
            Thanks,

            I installed the Clusterware and Database on two new machines and followed same steps as you mentioned and every thing went fine.

            thanks a lot for your great support and knowledge sharing.

            Have a very nice time.

            Best regards,
            • 3. Re: RAC to RAC CLONE FROM RMAN Cold Backup
              moreajays
              Thanks !!

              -Ajay More
              http://moreajays.blogspot.com