Re: rman fail on backup control file

Thanks everyone for your input. I ran a show all it listed that file as the snapshot controlfile. I altered the name to a new file and ran a backup spfile. Unfortunately I am still getting a corruption error.

RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1
channel at 08/16/2018 10:19:52
ORA-19599: block number 10014 is corrupt in control file C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SNCFXE1.ORA On Wed, Aug 15, 2018 at 11:00 PM LK <lkaing_at_gmail.com> wrote:

> If it's the snapshot controlfile you can simply point it to a new location
> and name, eg:
>
> RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'F:\DBA\SNAPCF_XE.F';
>
> And take a backup - this should genereate a new snapshot controlfile:
>
> RMAN> backup spfile;
>
> I'd also get the sysadmin to do hardware/os/firmware check of the server
> in case this is just the tip of the iceberg... is there corruption in the
> underlying hardware/storage/firmware etc.
>
>
> On Thu, Aug 16, 2018 at 2:22 PM, Tony <dedba_at_tpg.com.au> wrote:
>
>> Hi Jeff,
>>
>> You could try configuring a new name for the snapshot controlfile. To get
>> the command, just say
>>
>> RMAN> show all;
>>
>> It will be in de output. That should also confirm that it is indeed the
>> snapshot ctrl file.
>>
>> Cheers,
>> Tony
>>
>>
>> On 16 August 2018 9:21:37 am AEST, Jeff Chirco <backseatdba_at_gmail.com>
>> 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?
>>>
>>
>> --
>> Sent from my Android device with K-9 Mail. Please excuse my brevity.
>>
>
>

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