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

Last updated on OCTOBER 11, 2016

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>/dbs/snapcf_PROD.f

Alert log shows:

Mon Apr 20 00:03:48 2015
Hex dump of (file 0, block 1025) in trace file /u01/PROD/db/tech_st/11.1.0/admin/PROD_erpprddb/diag/rdbms/prod/PROD/trace/PROD_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=/u01/PROD/db/tech_st/11.1.0/dbs/snapcf_PROD.f. found same corrupt data
Reread of blocknum=1025, file=/u01/PROD/db/tech_st/11.1.0/dbs/snapcf_PROD.f. found same corrupt data
Reread of blocknum=1025, file=/u01/PROD/db/tech_st/11.1.0/dbs/snapcf_PROD.f. found same corrupt data
Reread of blocknum=1025, file=/u01/PROD/db/tech_st/11.1.0/dbs/snapcf_PROD.f. found same corrupt data
Reread of blocknum=1025, file=/u01/PROD/db/tech_st/11.1.0/dbs/snapcf_PROD.f. found same corrupt data

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms