Thursday, December 17, 2009

V$BACKUP_SET_SUMMARY

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_SET_SUMMARY provides summary information for a backup set.
Column
Datatype
Description
NUM_BACKUPSETS
NUMBER
Total number of backup sets created
OLDEST_BACKUP_TIME
DATE
Oldest backup start time
NEWEST_BACKUP_TIME
DATE
Newest backup start time
OUTPUT_BYTES
NUMBER
Number of output bytes (not including multiple copies)
ORIGINAL_INPUT_BYTES
NUMBER
Number of input bytes when backup sets were created
ORIGINAL_INPRATE_BYTES
NUMBER
Average input rate
OUTPUT_RATE_BYTES
NUMBER
Average output rate
COMPRESSION_RATIO
NUMBER
Compression ratio
ORIGINAL_INPUT_BYTES_DISPLAY
VARCHAR2(4000)
Displayable format for input bytes
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
Displayable format for output bytes
ORIGINAL_INPRATE_BYTES_DISPLAY
VARCHAR2(4000)
Displayable format for input rate
OUTPUT_RATE_BYTES_DISPLAY
VARCHAR2(4000)
Displayable format for output rate

Note:

1.       The corresponding RMAN catalog view is RC_BACKUP_SET_SUMMARY.


Oracle data dictionary views

Last updated: 2009-12-15 Tuesday


V$BACKUP_SET_DETAILS

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_SET_DETAILS provides detailed information about the backup set. This view will contain an extra row for each backup session that invokes BACKUP BACKUPSET (that is, creates new copies for the same backup set or copies backup set information from disk to tape). However, the remaining values of other columns belong to the complete backup set.
Column
Datatype
Description
SESSION_KEY
NUMBER
Session identifier
SESSION_RECID
NUMBER
Identifies the job, together with SESSION_STAMP.
SESSION_STAMP
NUMBER
Identifies the job, together with SESSION_RECID
BS_KEY
NUMBER
Backup set identifier
RECID
NUMBER
RECID from V$BACKUP_SET record
STAMP
NUMBER
Stamp from V$BACKUP_SET record
SET_STAMP
NUMBER
Backup set stamp
SET_COUNT
NUMBER
Backup count number
BACKUP_TYPE
VARCHAR2(1)
Type of backup (same as in V$BACKUP_SET)
CONTROLFILE_INCLUDED
VARCHAR2(3)
Control file included in backup set (same as in V$BACKUP_SET)
INCREMENTAL_LEVEL
NUMBER
Incremental level (same as in V$BACKUP_SET)
PIECES
NUMBER
Number of pieces (same as in V$BACKUP_SET)
START_TIME
DATE
Start time of the backup set (same as in V$BACKUP_SET)
COMPLETION_TIME
DATE
Completion time of the backup set (same as in V$BACKUP_SET)
ELAPSED_SECONDS
NUMBER
Time taken for backup set creation (same as in V$BACKUP_SET)
BLOCK_SIZE
NUMBER
Block size (same as in V$BACKUP_SET)
KEEP
VARCHAR2(3)
Keep value (same as in V$BACKUP_SET)
KEEP_UNTIL
DATE
Keep Until time (same as in V$BACKUP_SET)
KEEP_OPTIONS
VARCHAR2(10)
Keep options (same as in V$BACKUP_SET)
DEVICE_TYPE
VARCHAR2(17)
Type of device. If the backup set exists on more than one device type, an * is indicated here.
COMPRESSED
VARCHAR2(3)
YES, if backup is compressed
NUM_COPIES
NUMBER
Number of identical copies
OUTPUT_BYTES
NUMBER
Size of the backup set
ORIGINAL_INPUT_BYTES
NUMBER
Amount of data backed up when the backup set was created
COMPRESSION_RATIO
NUMBER
Compression ratio (input size/output size)
STATUS
CHAR(1)
The status of the backup set. It is always A (all backup pieces available), because this view only reflects available backup sets.
ORIGINAL_INPRATE_BYTES
NUMBER
Number of bytes read per second when backup set was initially created
OUTPUT_RATE_BYTES
NUMBER
Number of bytes written per second when the backup set was initially created
ORIGINAL_INPUT_BYTES_DISPLAY
VARCHAR2(4000)
Input rate to display
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
Size of backup set to display
ORIGINAL_INPRATE_BYTES_DISPLAY
VARCHAR2(4000)
Input rate per second for display
OUTPUT_RATE_BYTES_DISPLAY
VARCHAR2(4000)
Output rate per second for display
TIME_TAKEN_DISPLAY
VARCHAR2(4000)
Elapsed time in hh:mm:ss format

Note:

1.       The corresponding RMAN catalog view is RC_BACKUP_SET_DETAILS.


Oracle data dictionary views

Last updated: 2009-12-15 Tuesday


V$BACKUP_SET

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_SET displays information about backup sets from the control file. A backup set record is inserted after the backup set is successfully completed.
Column
Datatype
Description
RECID
NUMBER
Backup set record ID
STAMP
NUMBER
Backup set record stamp
SET_STAMP
NUMBER
Backup set stamp. The backup set stamp and count uniquely identify the backup set.
Primary key for the V$BACKUP_SET table, and the foreign key for the following tables: V$BACKUP_PIECE, V$BACKUP_DATAFILE, V$BACKUP_REDOLOG, V$BACKUP_CORRUPTION.
SET_COUNT
NUMBER
Backup set count. The backup set count is incremented by one every time a new backup set is started (if the backup set is never completed the number is "lost"). If the control file is re-created then the count is reset to 1. Therefore the count must be used with the stamp to uniquely identify a backup set.
Primary key for the V$BACKUP_SET table, and the foreign key for the following tables: V$BACKUP_PIECE, V$BACKUP_DATAFILE, V$BACKUP_REDOLOG, V$BACKUP_CORRUPTION
BACKUP_TYPE
VARCHAR2(1)
Type of files that are in this backup. If the backup contains archived redo logs, the value is L. If this is a datafile full backup, the value is D. If this is an incremental backup, the value is I.
CONTROLFILE_INCLUDED
VARCHAR2(3)
Set to YES if there is a control file included in this backup set, otherwise set to NO
INCREMENTAL_LEVEL
NUMBER
Location where this backup set fits into the database's backup strategy. Set to zero for full datafile backups, nonzero for incremental datafile backups, and NULL for archivelog backups.
PIECES
NUMBER
Number of distinct backup pieces in the backup set
START_TIME
DATE
Starting time
COMPLETION_TIME
DATE
Time that this backup set completed
ELAPSED_SECONDS
NUMBER
The number of elapsed seconds
BLOCK_SIZE
NUMBER
Block size of the backup set
INPUT_FILE_SCAN_ONLY
VARCHAR2(3)
YES indicates no actual backup is performed, but the datafiles are read. NO indicates a normal backup is performed.
KEEP
VARCHAR2(3)
(YES/NO) Indicates whether or not this backup set has a retention policy that is different than the value for the configure retention policy
KEEP_UNTIL
DATE
If KEEP_UNTIL_TIME is specified, this is the date after which the backup becomes obsolete. If this column is null, then the backup never expires.
KEEP_OPTIONS
VARCHAR2(10)
Lists additional retention options for this backup set. Possible values are:
LOGS - The logs need to recover this backup are kept
NOLOGS - The logs needed to recover this backup will not be kept
BACKUP_LOGS - An archive log backup exists to support this backup set
MULTI_SECTION
VARCHAR2(3)
Indicates whether or not this backup set is a multi-section backup. Valid values are YES and NO. A multi-section backup is a backup in which multiple backup pieces are produced independently in parallel by multiple channels.

Note:

1.       The corresponding RMAN catalog view is RC_BACKUP_SET.


Oracle data dictionary views

Last updated: 2009-12-15 Tuesday