i have rman backup without control file of old database which was crashed now i created a database with same name of old one and catalog database.i want to recover from those rman backup but i can't tag them with rman to recover.is there any way to do that please help me out. right now i couldn't manage a control file of old one's.
Oracle Database 10g Enterprise Edition 10.2.0.3.0 on win7
Creating a new database doesn't help. Oracle matches databases by DBIDs that are unique -- the new database would have a different DBID from the old one so the old one can't be restored over the new database.
Furthermore, you do need the controlfile of the old database.
Hemant K Chitale