Cloning Prod to QA

[st2003]

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

[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

[julian]

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;

[anandkl]

Hi Julian,
U mean fastest way to take a backup.

regards
anandkl