Database Backup and Recovery (MOSC)

MOSC Banner

V$BACKUP_DATAFILE show corruption on controlfile rows

edited Apr 20, 2022 1:54PM in Database Backup and Recovery (MOSC) 5 commentsAnswered ✓

Hi, we did an RMAN backup to our database using this script:

BACKUP TAG = Backup_Full FORMAT = '/oracle/backup/S2N/rmanbck/DataFile_%d_%Y%M%D_%U' AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG TAG = Backup_Full FORMAT = '/oracle/backup/S2N/rmanbck/ArcLogFull_%d_%Y%M%D_%U' NOT BACKED UP;

V$backup_datafile shows corruption for the controlfile row:

select controlfile_type, marked_corrupt, media_corrupt form v$backup_datafile where file# = 0;
CONTROLFILE_TYPE, MARKED_CORRUPT,MEDIA_CORRUPT
B                 2022           420

I'm not sure what to check, db works fine, no error in the alert, v$backup_corruption show no rows, rman command

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center