Recreating Controlfile During Database Restore

Hi Listers,

Database is 12.1.0.2 RAC on Linux.

Somebody restored the database, then discovered there are no controlfile or archivelog backups and the archivelogs from the time of the backup are gone.

The backup appears to have been a consistent backup. V$datafile_header shows all files with the same checkpoint_change#. RMAN shows all files having the same SCN in the backup.

I thought it would be possible to recreate the controlfile and open the database but when I try to open with RESETLOGS, it fails, saying datafile 1 needs more recovery. I tried simulating recovery with CANCEL but it still failed.

Have I missed something? Shouldn't it be possible in this case to recreate the controlfile and open resetlogs if the backup was consistent?

Any insights would be greatly appreciated.

Regards,

Ronan

--
http://www.freelists.org/webpage/oracle-l