My Oracle Support Banner

RMAN fails due to corruption of snapshot controflile snapcf_<SID>.f (Doc ID 2001596.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

On E-Business Suite version 12.1.1, Production instance RMAN controlfile autobackup fails:

Autobackup failed with following error
ORA-19624: operation failed, retry possible
ORA-19599: block number 1025 is corrupt in control file /<oracle_home path>/dbs/snapcf_<SID>.f

Alert log shows:

Mon Apr 20 00:03:48 2015
Hex dump of (file 0, block 1025) in trace file /<path>/trace/<SID>_ora_21652.trc
Corrupt block relative dba: 0x00000401 (file 0, block 1025)
Bad header found during backing up controlfile
Data in bad block:
type: 48 format: 0 rdba: 0x333a3433
last change scn: 0x205b.2e383538 seq: 0x32 flg: 0x31
spare1: 0x3a spare2: 0x30 spare3: 0x325d
consistency value in tail: 0xcb021501
check value in block header: 0x3635
block checksum disabled
Reread of blocknum=1025, file=/<oracle_home path>/dbs/snapcf_PROD.f. found same corrupt data
Reread of blocknum=1025, file=/<oracle_home path>/dbs/snapcf_PROD.f. found same corrupt data
Reread of blocknum=1025, file=/<oracle_home path>/dbs/snapcf_PROD.f. found same corrupt data
Reread of blocknum=1025, file=/<oracle_home path>/dbs/snapcf_PROD.f. found same corrupt data
Reread of blocknum=1025, file=/<oracle_home path>/dbs/snapcf_PROD.f. found same corrupt data

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.