Re: Recreating Controlfile During Database Restore

haaa! talk about a DBA's nightmare.

I dont know how critical this database is to your business. I have heard about some of my colleagues using DUDE, DUL tools from someone in Belgium or Holland.

Oracle support couldnt help?

On Wed, Aug 30, 2017 at 2:14 PM, Ronan Merrick <merrickronan1_at_gmail.com> wrote:

> 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