Friday, December 18, 2009

V$BACKUP_REDOLOG

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_REDOLOG displays information about archived logs in backup sets from the control file. Note that online redo logs cannot be backed up directly; they must be archived first to disk and then backed up. An archive log backup set can contain one or more archived logs.
Column
Datatype
Description
RECID
NUMBER
Record ID for this row; it is an integer that identifies this row
STAMP
NUMBER
Timestamp used with RECID to uniquely identify this row
SET_STAMP
NUMBER
One of the foreign keys for the row of the V$BACKUP_SET table that identifies this backup set
SET_COUNT
NUMBER
One of the foreign keys for the row of the V$BACKUP_SET table that identifies this backup set
THREAD#
NUMBER
Thread number for the log
SEQUENCE#
NUMBER
Log sequence number
RESETLOGS_CHANGE#
NUMBER
Change number of the last resetlogs before the log was written
RESETLOGS_TIME
DATE
Change time of the last resetlogs before the log was written. These will be the same for all logs in a backup set.
FIRST_CHANGE#
NUMBER
SCN when the log was switched into. The redo in the log is at this SCN and greater.
FIRST_TIME
DATE
Time allocated when the log was switched into
NEXT_CHANGE#
NUMBER
SCN when the next log in this thread was switched into. The redo in the log is below this SCN.
NEXT_TIME
DATE
Time when the next log in this thread was switched into
BLOCKS
NUMBER
Size of the log in logical blocks including the header block
BLOCK_SIZE
NUMBER
Size of the log blocks in bytes
TERMINAL
VARCHAR2(3)
???

Note:

1.       The corresponding RMAN catalog view is RC_BACKUP_REDOLOG.


Oracle data dictionary views

Oracle dynamic performance views
Last updated: 2009-12-15 Tuesday

Posted by Admin at 12/18/2009 11:39:00 AM 0 comments

Labels: ,

V$BACKUP_PIECE_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_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
Owning V$RMAN_STATUS record ID
RMAN_STATUS_STAMP
NUMBER
Owning V$RMAN_STATUS record stamp
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

Oracle dynamic performance views
Last updated: 2009-12-15 Tuesday

Posted by Admin at 12/18/2009 11:38:00 AM 0 comments

Labels: ,

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

Oracle dynamic performance views
Last updated: 2009-12-15 Tuesday


Posted by Admin at 12/17/2009 02:32:00 PM 0 comments

Labels: ,

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

Oracle dynamic performance views
Last updated: 2009-12-15 Tuesday


Posted by Admin at 12/17/2009 02:32:00 PM 0 comments

Labels: ,

Subscribe to: Posts (Atom)