-
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
-
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
-
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,12c
email: ocp_9i@yahoo.com
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|