RE: Recreating Controlfile During Database Restore

Do you have online redo logs from the time of backup. I believe You will need these for recovery.

From: Ram Raman <veeeraman_at_gmail.com<mailto:veeeraman_at_gmail.com>> Date: Friday, Sep 01, 2017, 17:50
To: merrickronan1_at_gmail.com <merrickronan1_at_gmail.com<mailto:merrickronan1_at_gmail.com>>, ORACLE-L <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: 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<mailto: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

--

Please visit our website at
http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html for important disclosures and information about our e-mail policies. For your protection, please do not transmit orders or instructions by e-mail or include account numbers, Social Security numbers, credit card numbers, passwords, or other personal information.
--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 01 2017 - 23:54:19 CEST