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

Last updated: 2009-12-15 Tuesday

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

Last updated: 2009-12-15 Tuesday