Re: rman fail on backup control file

Yes I have 3 control files but this is not a control file, its the snapshot control file. I have deleted this snapshot file and it recreates it as corrupt. I am wondering which control file could be corrupt.

On Thu, Aug 16, 2018 at 1:19 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> 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
>
>
>

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