Thank you for visiting Spatial DBA - Oracle and ArcSDE.
I have stopped updating the blog.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
===============================================================
V$BACKUP_PIECE_DETAILS displays information about all available backup pieces.
Column | Datatype | Description |
SESSION_KEY | NUMBER | Session identifier |
SESSION_RECID | NUMBER | Session recid |
SESSION_STAMP | NUMBER | Session stamp |
BS_KEY | NUMBER | Backup set identifier |
BP_KEY | NUMBER | Backup piece key |
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. The value is 1 if the backup piece is not duplexed. |
DEVICE_TYPE | VARCHAR2(17) | Type of device on which the backup piece resides. Set to DISK for backup sets on disk. |
HANDLE | VARCHAR2(513) | Backup piece handle identifies the backup piece on restore |
COMMENTS | VARCHAR2(64) | Comments returned by the operating system or storage subsystem. Set to NULL for backup pieces on disk. This value is informational only. It is not needed for restore. |
MEDIA | VARCHAR2(65) | Name of the media on which the backup piece resides. This value is informational only. It is 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 or not the piece is 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 | Starting time |
COMPLETION_TIME | DATE | Completion time |
ELAPSED_SECONDS | NUMBER | Number of elapsed seconds |
DELETED | VARCHAR2(3) | NO indicates that the file still exists. YES indicates that the file no longer exists because it has been deleted. |
BYTES | NUMBER | Size of the backup piece, in bytes |
IS_RECOVERY_DEST_FILE | VARCHAR2(3) | Indicates whether or not the file was created in the flash recovery area (YES) or not (NO) |
RMAN_STATUS_RECID | NUMBER | |
RMAN_STATUS_STAMP | NUMBER | |
COMPRESSED | VARCHAR2(3) | Indicates whether the backup piece is compressed (YES) or not (NO) |
BACKED_BY_VSS | VARCHAR2(3) | Whether or not the file has been backed up by Volume Shadow Copy Service (VSS). This column is reserved for internal use. |
PIECES_PER_SET | NUMBER | Number of backup pieces per set |
SIZE_BYTES_DISPLAY | VARCHAR2(4000) | Size (in bytes) of the backup piece to display |
Note:
1. The corresponding RMAN catalog view is RC_BACKUP_PIECE_DETAILS.
Oracle data dictionary views
Last updated: 2009-12-15 Tuesday |
No comments:
Post a Comment