This content has been marked as final. Show 5 replies
I am not sure about the database version you are using.
If on 10g or above, then refer this http://shivanandarao.wordpress.com/2012/04/19/duplicating-primary-database-to-a-new-host-without-connecting-to-the-primary-database-in-oracle-10g11g/
If on 11g and want to make use of the feature available in 11g, then refer this http://shivanandarao.wordpress.com/2012/04/28/duplicating-database-without-connecting-to-target-database-or-catalog-database-in-oracle-11g/
Thank you! The duplicatling database post in your blog is very useful. But i renamed the mount point name as /rmanbackup like in PROD server and copied the PROD Rman backup to test server & restored the database.
Keep writing replies in OTN forum.
This is not an exact match :
However with some minor changes it will work for you.
Scenario is like rman disk to disk cloning.
summary of steps:
1)Prepare pfile for target database and start in nomount mode
2) Restore controlfile from backuppiece present in /rmanbackup
rman target /
restore controlfile from '<backuppiece name in /rmanbackup where controlfile is present-----give full path>'
3)catalog all the backup pieces using CATALOG START WITH '/rmanbackup/*';
This command will register the new location of backup in CF as /rmanbackup
4) rman target /
5)Open the database and rename if you want using NID
Already I started the restore process as you mentioned.
Actually our restoration process is taking more than 10hours. Our DB size is 1.3 TB,
We have allocated 50 channels in RMAN & restoring.
RMAN 12 GB
Now My question is how to reduce restoration time? It is killing one full day for cloning.