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
Or clone it with the duplicate command.
Originally Posted by davey23uk
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
startup mount pfile=\INIT.ORA;
allocate channel ch1 type disk;
release channel ch1;
I am assuming you have same partitioning for PROD and DEV databases.
You don't want a new instance, you just want to restore your existing db and start a new instance of it.
Originally Posted by purirb
Click Here to Expand Forum to Full Width