Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

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 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index