Oracle 视图 V$COPY_CORRUPTION 官方解释，作用，如何使用详细说明

网络编程 Oracle 视图 V$COPY_CORRUPTION 官方解释，作用，如何使用详细说明 10-17

本站中文解释

：

Oracle视图V$COPY_CORRUPTION是用来报告当前控制文件的备份拷贝可能遭到破坏信息的视图。V$COPY_CORRUPTION仅显示控制文件还没有被弃用的备份拷贝中可能遭受损坏的信息。

使用方式：

1. 在SQL*Plus中输入查询语句：SELECT * FROM V$COPY_CORRUPTION;

2. 对查询结果分析，查看是否有备份拷贝可能遭受损坏的信息，并采取相应的措施进行处理。

官方英文解释

V$COPY_CORRUPTION displays information about data file copy corruptions from the control file.

Column	Datatype	Description
`RECID`	`NUMBER`	Copy corruption record ID
`STAMP`	`NUMBER`	Copy corruption record stamp
`COPY_RECID`	`NUMBER`	Data file copy record ID
`COPY_STAMP`	`NUMBER`	Data file copy record stamp
`FILE#`	`NUMBER`	Data file number
`BLOCK#`	`NUMBER`	First block of the corrupted range
`BLOCKS`	`NUMBER`	Number of contiguous blocks in the corrupted range
`CORRUPTION_CHANGE#`	`NUMBER`	Change number 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 data file, but were detected and marked as corrupted while making the data file copy
`CORRUPTION_TYPE`	`VARCHAR2(9)`	Type of block corruption in the data file: `ALL ZERO` – Block header on disk contained only zeros. The block may be valid if it was never filled and if it is in an Oracle7 file. The buffer will be reformatted to the Oracle8 standard for an empty block. `FRACTURED` – Block header looks reasonable, but the front and back of the block are different versions. `CHECKSUM` – optional check value shows that the block is not self-consistent. It is impossible to determine exactly why the check value fails, but it probably fails because sectors in the middle of the block are from different versions. `CORRUPT` – Block is wrongly identified or is not a data block (for example, the data block address is missing) `LOGICAL` – Block is logically corrupt `NOLOGGING` – Block does not have redo log entries (for example, `NOLOGGING` operations on primary database can introduce this type of corruption on a physical standby)
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

编辑：广州鸿名健康科技有限公司