|
-
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: [email protected]
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
|