Re: rman fail on backup control file

On 08/15/2018 07:21 PM, Jeff Chirco wrote:

> I have an 10g XE database that is failing during rman backup.
> ORA-19624: operation failed, retry possible
> ORA-19599: block number 10014 is corrupt in control file
> C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SNCFXE.ORA
>
> I am not sure what SNCFXE.ORA is but I believe it is some snapshot
> control file backup.  Anybody know how to recover for this?  Do I need
> to do a full recovery from controlfile trace?

Hopefully, you have more than one control file? If you do, please copy the correct one over the corrupt
C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SNCFXE.ORA file. Check your control_files parameter in the instance. If you don't have more than one, try dumping it to trace (ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS 'C:\temp\ctlfile.sql' NORESETLOGS) then shutting down the instance and re-creating the control file.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

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