Attempting to restore database to same server with different name.
I have just restored my production database to an earlier backup to recover from a major application error.
I now need to reatore a second copy of the database to recover some data which was lost as a result of the restore. The only place I can do this is on the same server.
I can't use duplicate database because the time I want is before the resetlogs time of the current version.
I don't think I can use recover using backup controlfile because restoring the control file will have the old database name. Can I restore the control file, rename the database and still use the rman backups of the original database?
If so how?
Can use set incarnation to get round the resetlogs issue without affecting the current database?
10gR2
Windows 2008 64-bit
Edited by: Jim Smith on Oct 27, 2011 8:54 PM