RC_COPY_CORRUPTION

This view lists corrupt block ranges in datafile copies. It corresponds to the V$COPY_CORRUPTION view.

Column	Datatype	Description
`DB_KEY`	`NUMBER`	The primary key for the target database. Use this column to form a join with almost any other catalog view.
`DBINC_KEY`	`NUMBER`	The primary key for the incarnation of the target database. Use this column to form a join with `RC_DATABASE_INCARNATION`.
`DB_NAME`	`VARCHAR2(8)`	The `DB_NAME` of the database incarnation to which this record belongs.
`RECID`	`NUMBER`	The record identifier from `V$COPY_CORRUPTION`. `RECID` and `STAMP` form a concatenated primary key that uniquely identifies this record in the target database control file.
`STAMP`	`NUMBER`	The stamp from `V$COPY_CORRUPTION`. `RECID` and `STAMP` form a concatenated primary key that uniquely identifies this record in the target database control file.
`CDF_KEY`	`NUMBER`	The primary key of the datafile copy in the recovery catalog. If you issue the `LIST` command while connected to the recovery catalog, this value appears in the `KEY` column of the output. Use this column to form a join with `RC_DATAFILE_COPY`.
`COPY_RECID`	`NUMBER`	The `RECID` from `RC_DATAFILE_COPY`. This value is propagated from the control file.
`COPY_STAMP`	`NUMBER`	The `STAMP` from `RC_DATAFILE_COPY`. This value is propagated from the control file.
`FILE#`	`NUMBER`	The absolute file number of the datafile.
`CREATION_CHANGE#`	`NUMBER`	The creation SCN of this data file. Because file numbers can be reused, `FILE#` and `CREATION_CHANGE#` are both required to uniquely identify a specified file over the life of the database.
`BLOCK#`	`NUMBER`	The block number of the first corrupted block in the file.
`BLOCKS`	`NUMBER`	The number of corrupted blocks found beginning with `BLOCK#`.
`CORRUPTION_CHANGE#`	`NUMBER`	For media corrupt blocks, this value is zero. For logically corrupt blocks, this value is the lowest SCN in the blocks in this corrupt range.
`MARKED_CORRUPT`	`VARCHAR2(3)`	`YES` if this corruption was not previously detected by the database server or `NO` if it was already known by the database server.
`CORRUPTION_TYPE`	`VARCHAR2(9)`	Same as `RC_DATABASE_BLOCK_CORRUPTION.CORRUPTION_TYPE`.