This content has been marked as final. Show 3 replies
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;