This content has been marked as final. Show 3 replies
Better close this thread here and move it to this part of the forum
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/
You need to restore it as the same name as you have it in the production and later change the dbname using the NID utility.
If you do not want to go with this method, then I would suggest you to go with the RMAN duplicate method.
rman target sys/<pwd>@prod auxiliary sys/<pwd>@tst RMAN>duplicate target database to 'prderp' nofilenamecheck;
Kindly close the thread my problem has been solved.
Thanks to all of you.