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, 15 of 211


V$BACKUP_PIECE

This view displays information about backup pieces from the control file. Each backup set consist of one or more backup pieces.

Column  Datatype  Description 

RECID 

NUMBER 

Backup piece record ID 

STAMP 

NUMBER 

Backup piece record stamp 

SET_STAMP 

NUMBER 

Backup set stamp 

SET_COUNT 

NUMBER 

Backup set count 

PIECE# 

NUMBER 

Backup piece number (1-N) 

COPY# 

NUMBER 

Indicates the copy number for backup pieces created with duplex enabled. 1 if the backup piece is not duplexed. 

DEVICE_TYPE 

VARCHAR2(17) 

Type of the device on which the backup piece resides. Set to DISK for backup sets on disk.

See Also: V$BACKUP_DEVICE 

HANDLE 

VARCHAR2(513) 

Backup piece handle identifies the backup piece on restore 

COMMENTS 

VARCHAR2(81) 

Comment returned by the operating system or storage subsystem. Set to NULL for backup pieces on disk. This value is informational only; not needed for restore. 

MEDIA 

VARCHAR2(65) 

Name of the media on which the backup piece resides. This value is informational only; not needed for restore. 

MEDIA_POOL 

NUMBER 

The media pool in which the copy resides. This is the same value that was entered in the POOL operand of the Recovery Manager backup command. 

CONCUR 

VARCHAR2(3) 

(YES | NO) Indicates whether the piece on a media that can be accessed concurrently 

TAG 

VARCHAR2(32) 

Backup piece tag. The tag is specified at backup set level, but stored at piece level. 

STATUS 

VARCHAR2(1) 

Indicates the status of the piece: A (available), D (deleted), or X (expired) 

START_TIME 

DATE 

The starting time 

COMPLETION_TIME 

DATE 

The completion time 

ELAPSED_SECONDS 

NUMBER 

The number of elapsed seconds 

DELETED 

VARCHAR2(3) 

(YES/NO) NO indicates that the file still exists. YES indicates the file no longer exists because it has been deleted. 


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