-
Refresh dev database from prod using RMAN
I have hotbackups, archivelog backup and controlfile back up from prod using RMAN. On another box I already have a dev instance running of this database. How can I refresh dev database using backup files provided. I do not want to use duplicate command. Please help.
-
use the restore command then
-
Originally Posted by davey23uk
use the restore command then
Or clone it with the duplicate command.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
run {
startup mount pfile=\INIT.ORA;
allocate channel ch1 type disk;
restore database;
recover database;
release channel ch1;
}
I am assuming you have same partitioning for PROD and DEV databases.
-
Originally Posted by purirb
On another box I already have a dev instance running of this database.
You don't want a new instance, you just want to restore your existing db and start a new instance of it.
Jeff Hunter
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
|