when you want to restore the database with NEWSID then you need to manually create the control file. If you restore the control file from backup it obviously have ORIGSID which is != NEWSID.
tons of documents available in internet to tell you how to do that.
Thanks,




Reply With Quote