Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

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

Dynamic Performance (V$) Views, 12 of 211


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 


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

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback