Dynamic Performance (V$) Views, 11 of 179

V$BACKUP_CORRUPTION

This view displays information about corruptions in datafile backups from the control file. Note that corruptions are not tolerated in the control file and archived log backups.

Column Datatype Description

RECID

NUMBER

Backup corruption record ID

STAMP

NUMBER

Backup corruption record stamp

SET_STAMP

NUMBER

Backup set stamp

SET_COUNT

NUMBER

Backup set count

PIECE#

NUMBER

Backup piece number

FILE#

NUMBER

Datafile number

BLOCK#

NUMBER

First block of the corrupted range

BLOCKS

NUMBER

Number of contiguous blocks in the corrupted range

CORRUPTION_CHANGE#

NUMBER

Change# at which the logical corruption was detected. Set to 0 to indicate media corruption

MARKED_CORRUPT

VARCHAR2(3)

YES | NO. If set to YES the blocks were not marked corrupted in the datafile, but were detected and marked as corrupted while making the datafile backup

Column	Datatype	Description
`RECID`	`NUMBER`	Backup corruption record ID
`STAMP`	`NUMBER`	Backup corruption record stamp
`SET_STAMP`	`NUMBER`	Backup set stamp
`SET_COUNT`	`NUMBER`	Backup set count
`PIECE#`	`NUMBER`	Backup piece number
`FILE#`	`NUMBER`	Datafile number
`BLOCK#`	`NUMBER`	First block of the corrupted range
`BLOCKS`	`NUMBER`	Number of contiguous blocks in the corrupted range
`CORRUPTION_CHANGE#`	`NUMBER`	Change# at which the logical corruption was detected. Set to 0 to indicate media corruption
`MARKED_CORRUPT`	`VARCHAR2(3)`	`YES` \| `NO`. If set to `YES` the blocks were not marked corrupted in the datafile, but were detected and marked as corrupted while making the datafile backup