Re: rman fail on backup control file

Space may be the issue.  While checking for space - check for space with quotas, including FRA

/Hans
disclaimer:  I currently work for Oracle. Opinions are my own, not necessarily those of my employer.

On 2018-08-16 4:38 PM, Andrew Kerber wrote:
> You may simply be out of space.
>
> Sent from my iPad
>
> On Aug 16, 2018, at 17:35, Jeff Chirco <backseatdba_at_gmail.com
> <mailto:backseatdba_at_gmail.com>> wrote:
>
>> 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 <mailto: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