Cloning DB with Hot backups!Possible!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Cloning DB with Hot backups!Possible!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    Query:

    1.Is it possible to clone a DB with Hot backups!

    If yes,what are the detailed steps please!

    Thanks & Regards,

    Amit.

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Yes, the steps are the same as in cold backup:

    1. Copy files to the same or other path(is change the path, you shall change parameters control files in the init.ora and make alter database rename file 'XXXXX' to 'New Path'
    2. Open the database.
    3. Run.

    Hope that helps

    Angel

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sure, you can do it.
    1. place tablespace in backup mode
    2. copy datafiles to new host, same location
    3. take tablespace out of backup mode
    4. repeat for all tablespaces
    5. copy archived redo logs to new host
    6. backup controlfile and copy to new host
    7. on new host, recover database using backup controlfile
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Oct 2000
    Posts
    467
    This is quite easy if you use RMAN
    Vinit

  5. #5
    Join Date
    Jul 2000
    Posts
    521
    You do not have to copy the datafiles at the 'same' location on dest server/disk. If the absolute path names are not same, you can always create a control file and then recover the db.
    svk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width