Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

Dynamic Performance (V$) Views, 32 of 179


V$COPY_CORRUPTION

This view displays information about datafile copy corruptions from the control file.

Column  Datatype  Description 

RECID 

NUMBER 

Copy corruption record ID 

STAMP 

NUMBER 

Copy corruption record stamp 

COPY_RECID 

NUMBER 

Datafile copy record ID 

COPY_STAMP 

NUMBER 

Datafile copy record stamp 

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 copy 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index