Recreating Controlfile During Database Restore

From: Ronan Merrick <>
Date: Wed, 30 Aug 2017 20:14:15 +0100
Message-ID: <>

Hi Listers,

Database is 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.



Received on Wed Aug 30 2017 - 21:14:15 CEST

Original text of this message