This discussion is archived
3 Replies Latest reply: Nov 26, 2012 6:08 AM by moreajays RSS

RAC to RAC CLONE FROM RMAN Cold Backup

859515 Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    Thanks !!

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

Legend

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