This discussion is archived
6 Replies Latest reply: Jan 9, 2013 2:17 AM by ggiulian RSS

Best way for clone db

ggiulian Newbie
Currently Being Moderated
hi All,

I've a simple question about clone DB.

I've a big (5TB) production database. I need to clone this database for test environment on second server.

I'm think to use rma DUPLICATE command. Both of server have can read and write on the same file system

oracle is 11 2.0.2 version and database use asm

Can I create a new rac instance on the second server and use it for restore db? How? Normaly I restore on single instance and after create DB and service for rac.....
Have you any tech doc for this ?

Regards
Giovanni
  • 1. Re: Best way for clone db
    rcc50886 Journeyer
    Currently Being Moderated
    1) you can take BACKUP of SOURCE database and use RMAN DUPLICATE DATABASE (or) RESTORE method
    as you have a shared file system between SOUREC and TARGET servers

    2) you can use RMAN DUPLICATE FROM ACTIVE DATABASE

    3) Once i used the ASMCMD CP command to copy the datafiles directly to TARGET ASM and recovered it
    (it worked even our SOURCE DB is up and running )

    -Thanks
  • 2. Re: Best way for clone db
    ggiulian Newbie
    Currently Being Moderated
    Thanks very much for your help.....

    I'd like use rman DUPLICATE command, but I read is possible to use only with auxiliary single istance on second server. Is it possible duplicate into RAC istances directly?
  • 3. Re: Best way for clone db
    rcc50886 Journeyer
    Currently Being Moderated
    I guess you are trying do following:

    source: 2-node RAC
    Target: 2-node RAC

    you create spfile for your TARGET RAC database and nomount the database on one node. No need to worry about other node at this time. All you need to make sure you have correct prameters in the pfile.

    connect to auxiliary instance (i.e nomount database on the first node) and run RMAN DUPLICATE command.

    once database is up and running, start the instance on other node.
  • 4. Re: Best way for clone db
    user11210018 Newbie
    Currently Being Moderated
    Just note.. 5 TB is a huge volume for DUplicate cmd to handle.. esp if the same network is being used by your production databases.
    We once ran a duplicate restore for 1 TB data.. that ate up the entire bandwidth.. ran for hours .. and had to benally killed.. as it was impacting Production Performkance.
  • 5. Re: Best way for clone db
    Pinela Journeyer
    Currently Being Moderated
    Hi,

    yes. you can. you simply need to shutdown one of the nodes (target nodes), alter the init for cluster_database=false, and then do a normal duplicate.

    yes, you need an auxiliary, because you are going to be connected to both DBs: target (production) and auxiliary (test).
    No problem there.
    Regarding time on network. you will only use the network heavily if you run a duplicate from active database.
    if you run a normal duplicate, the command uses already existing backup pieces, with minor network communication between the target and auxiliary.
    RMAN only connects to get the CF information.

    From a recent experience, I duplicated a 4TB database in 23hours with no noticeable burden on production. So you have a baseline.
    hope this helps.

    br,
    jpinela.
  • 6. Re: Best way for clone db
    ggiulian Newbie
    Currently Being Moderated
    Thanks very much.

    I dplicated the db between two exadata.

    On production exadata, i use rman to backup on zfssa storage. I mount the zfssa by nfs on second (test) exadata.

    on second (test) exadata, I create a sample rac database and start nomount only one instance. I start rman and connect to target (production), auxiliary (local test) and catalog.
    start simple duplicate command. After 11h dupicate finished and test db works fine.

    Thanks and regards.

    Giovanni

Legend

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