Cloning Prod to QA
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Cloning Prod to QA

  1. #1
    Join Date
    Jul 2003
    Location
    Cincinnati
    Posts
    68

    Cloning Prod to QA

    Hi..

    We want to clone an existing Production database to QA database.What is the fastest and safest option?

    This is what I have in mind...

    Take a cold backup of PROD(DF's, no ctl files and logfiles)
    and restore on the QA box, create ctl files with new db name with reset logs as it automatically creates new redologs from #1 aswell. Will this work? What are the things to keep in mind?

    Are there any other options that people usually implement?

    Thanks, ST2003

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi,
    Take backup of the production db.

    Take a backup of the control file on production i.e,
    alter database backup controlfile to trace;
    u could also give an path instead of trace.
    Open this file will give the create database command. Just do this in QA and restore the backup.
    You will have a QA DB same as PRODUCTION db

    regards
    anandkl
    anandkl

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by anandkl
    Hi,
    Take backup of the production db.

    Take a backup of the control file on production i.e,
    alter database backup controlfile to trace;
    u could also give an path instead of trace.
    Open this file will give the create database command. Just do this in QA and restore the backup.
    You will have a QA DB same as PRODUCTION db

    regards
    anandkl
    The fastest is via RMAN.

    duplicate target database to QA_DB;
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi Julian,
    U mean fastest way to take a backup.

    regards
    anandkl
    anandkl

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