Re: rman fail on backup control file
Date: Thu, 16 Aug 2018 16:00:08 +1000
Message-ID: <CAPqBzacwRwssdF_XRRK4YyVJDfn3D=30n5k182cixfC+KgqRVw_at_mail.gmail.com>
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-lReceived on Thu Aug 16 2018 - 08:00:08 CEST