Tuesday, December 15, 2009

V$BACKUP_CONTROLFILE_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_CONTROLFILE_DETAILS contains information about restorable control files. It will include all the control files backed up in the backup set, image copies, and proxy copies.
Column
Datatype
Description
BTYPE
CHAR(9)
Backup type container. Possible values are BACKUPSET, IMAGECOPY, PROXYCOPY.
BTYPE_KEY
NUMBER
Unique identifier for the backup type, either BS_KEY or COPY_KEY.
SESSION_KEY
NUMBER
Session identifier
SESSION_RECID
NUMBER
Session recid
SESSION_STAMP
NUMBER
Session stamp
ID1
NUMBER
If BACKUPSET, it contains SET_STAMP
If IMAGECOPY or PROXYCOPY, it is RECID from the control file
ID2
NUMBER
If BACKUPSET, it contains SET_COUNT
If IMAGECOPY or PROXYCOPY, it is STAMP
CREATION_TIME
DATE
File creation time
RESETLOGS_CHANGE#
NUMBER
Resetlogs change SCN
RESETLOGS_TIME
DATE
Resetlogs change time
CHECKPOINT_CHANGE#
NUMBER
Checkpoint change SCN
CHECKPOINT_TIME
DATE
Checkpoint change time
FILESIZE
NUMBER
File size, in bytes, for the output of backing up this control file
COMPRESSION_RATIO
NUMBER
Compression ratio for this backup
FILESIZE_DISPLAY
VARCHAR2(4000)
Same value as the FILESIZE column, but converted to a user-displayable format, for example nM, nG, nT, nP, and so on

Note:

1.       The corresponding RMAN catalog view is RC_BACKUP_CONTROLFILE_DETAILS.


Oracle data dictionary views

Last updated: 2009-12-15 Tuesday

V$BACKUP_CONTROLFILE_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_CONTROLFILE_SUMMARY provides control file summary information, based on either a backup set of files, image copies, or proxy copies.
Column
Datatype
Description
NUM_FILES_BACKED
NUMBER
Number of files backed up for specific criteria
NUM_DISTINCT_FILES_BACKED
NUMBER
Number of distinct files backed up
MIN_CHECKPOINT_CHANGE#
NUMBER
Minimum checkpoint change number of the datafile for specified criteria
MAX_CHECKPOINT_CHANGE#
NUMBER
Maximum checkpoint change number of the datafile for specified criteria
MIN_CHECKPOINT_TIME
DATE
Minimum checkpoint time of the datafile for specified criteria
MAX_CHECKPOINT_TIME
DATE
Maximum checkpoint time of the datafile for specified criteria
INPUT_BYTES
NUMBER
Total input bytes of files read
OUTPUT_BYTES
NUMBER
Total output bytes written
COMPRESSION_RATIO
NUMBER
Compression ratio
INPUT_BYTES_DISPLAY
VARCHAR2(4000)
Displayable format for input bytes
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
Displayable format for output bytes

Note:

1.       The corresponding RMAN catalog view is RC_BACKUP_CONTROLFILE_SUMMARY.


Oracle data dictionary views

Last updated: 2009-12-15 Tuesday

RMAN Recovery Catalog Views (Oracle 10gR2)

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.


===============================================================

Recovery Catalog View
Corresponding V$ View
Catalog View Describes ...
RC_ARCHIVED_LOG
Archived and unarchived redo logs
RC_BACKUP_ARCHIVELOG_DETAILS
Details about archived redo log backups for Enterprise Manager
RC_BACKUP_ARCHIVELOG_SUMMARY
Summary of information about archived redo log backups for Enterprise Manager
RC_BACKUP_CONTROLFILE
V$BACKUP_CONTROLFILE
Control files backed up in backup sets
RC_BACKUP_CONTROLFILE_DETAILS
V$BACKUP_CONTROLFILE_DETAILS
Details about control file backups for Enterprise Manager
RC_BACKUP_CONTROLFILE_SUMMARY
V$BACKUP_CONTROLFILE_SUMMARY
Summary of information about control file backups for Enterprise Manager
RC_BACKUP_COPY_DETAILS
V$BACKUP_COPY_DETAILS
Details about datafile image copy backups for Enterprise Manager
RC_BACKUP_COPY_SUMMARY
V$BACKUP_COPY_SUMMARY
Summary of information about datafile image copy backups for Enterprise Manager
RC_BACKUP_CORRUPTION
Corrupt block ranges in datafile backups
RC_BACKUP_DATAFILE
Datafiles in backup sets
RC_BACKUP_DATAFILE_DETAILS
V$BACKUP_DATAFILE_DETAILS
Details about datafile backups for Enterprise Manager
RC_BACKUP_DATAFILE_SUMMARY
V$BACKUP_DATAFILE_SUMMARY
Summary of information about datafile backups for Enterprise Manager
RC_BACKUP_FILES
RMAN backups and copies known to the repository.
RC_BACKUP_PIECE
Backup pieces
RC_BACKUP_PIECE_DETAILS
V$BACKUP_PIECE_DETAILS
Details about backup pieces for Enterprise Manager
RC_BACKUP_REDOLOG
V$BACKUP_REDOLOG
Archived redo logs in backup sets
RC_BACKUP_SET
V$BACKUP_SET
Backup sets for all incarnations of databases registered in the catalog
RC_BACKUP_SET_DETAILS
V$BACKUP_SET_DETAILS
Details about backup sets for Enterprise Manager
RC_BACKUP_SET_SUMMARY
V$BACKUP_SET_SUMMARY
Summary of information about backup sets for Enterprise Manager
RC_BACKUP_SPFILE
Server parameter files in backups
RC_BACKUP_SPFILE_DETAILS
Details about SPFILE backups for Enterprise Manager
RC_BACKUP_SPFILE_SUMMARY
Summary of information about SPFILE backups for Enterprise Manager
RC_CHECKPOINT
n/a
Deprecated in favor of RC_RESYNC
RC_CONTROLFILE_COPY
V$CONTROLFILE_COPY
Control file copies on disk
RC_COPY_CORRUPTION
Corrupt block ranges in datafile copies
RC_DATABASE
Databases registered in the recovery catalog
RC_DATABASE_BLOCK_CORRUPTION
Database blocks marked as corrupted in the most recent RMAN backup or copy
RC_DATABASE_INCARNATION
Database incarnations registered in the recovery catalog
RC_DATAFILE
Datafiles registered in the recovery catalog
RC_DATAFILE_COPY
Datafile copies on disk
RC_LOG_HISTORY
Online redo log history indicating when log switches occurred
RC_OFFLINE_RANGE
V$OFFLINE_RANGE
Offline ranges for datafiles
RC_RMAN_OUTPUT
Output from RMAN commands for use in Enterprise Manager
RC_PROXY_ARCHIVEDLOG
V$PROXY_ARCHIVEDLOG
Archived log backups taken with the proxy copy functionality
RC_PROXY_ARCHIVELOG_DETAILS
V$PROXY_ARCHIVELOG_DETAILS
Details about proxy archived redo logs for Enterprise Manager
RC_PROXY_ARCHIVELOG_SUMMARY
V$PROXY_ARCHIVELOG_SUMMARY
Summary of information about proxy archived redo logs for Enterprise Manager
RC_PROXY_CONTROLFILE
V$PROXY_CONTROLFILE
Control file backups taken with the proxy copy functionality
RC_PROXY_COPY_DETAILS
V$PROXY_COPY_DETAILS
Details about datafile proxy copies for Enterprise Manager
RC_PROXY_COPY_SUMMARY
V$PROXY_COPY_SUMMARY
Summary of information about datafile proxy copies for Enterprise Manager
RC_PROXY_DATAFILE
V$PROXY_DATAFILE
Datafile backups that were taken using the proxy copy functionality
RC_REDO_LOG
Online redo logs for all incarnations of the database since the last catalog resynchronization
RC_REDO_THREAD
All redo threads for all incarnations of the database since the last catalog resynchronization
RC_RESYNC
n/a
Recovery catalog resynchronizations
RC_RMAN_BACKUP_JOB_DETAILS
Details about backup jobs for Enterprise Manager
RC_RMAN_BACKUP_SUBJOB_DETAILS
Details about backup subjobs for Enterprise Manager
RC_RMAN_BACKUP_TYPE
V$BACKUP_TYPE
Used internally by Enterprise Manager
RC_RMAN_CONFIGURATION
RMAN configuration settings
RC_RMAN_STATUS
Historical status information about RMAN operations.
RC_STORED_SCRIPT
n/a
Names of scripts stored in the recovery catalog
RC_STORED_SCRIPT_LINE
n/a
Contents of the scripts stored in the recovery catalog
RC_TABLESPACE
All tablespaces registered in the recovery catalog, all dropped tablespaces, and tablespaces that belong to old incarnations
RC_TEMPFILE
All tempfiles registered in the recovery catalog
RC_UNUSABLE_BACKUPFILE_DETAILS
V$UNUSABLE_BACKUPFILE_DETAILS
Unusable backup files registered in the recovery catalog

Last updated: 2009-12-15 Tuesday

V$BACKUP_ARCHIVELOG_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_ARCHIVELOG_SUMMARY provides archive log summary information based on archive logs in the backup set or on proxy copies.
Column
Datatype
Description
NUM_FILES_BACKED
NUMBER
Number of files backed up
NUM_DISTINCT_FILES_BACKED
NUMBER
Number of distinct archive log files backed up
MIN_FIRST_CHANGE#
NUMBER
Lowest SCN range value
MAX_NEXT_CHANGE#
NUMBER
Highest SCN range value
MIN_FIRST_TIME
DATE
Lowest SCN range time
MAX_NEXT_TIME
DATE
Highest SCH range time
INPUT_BYTES
NUMBER
Total input bytes read
OUTPUT_BYTES
NUMBER
Output size of backups
COMPRESSION_RATIO
NUMBER
Compression ratio
INPUT_BYTES_DISPLAY
VARCHAR2(4000)
Displayable format for input bytes
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
Displayable format for output bytes

Note:

1.       The corresponding RMAN catalog view is RC_BACKUP_ARCHIVELOG_SUMMARY.


Oracle data dictionary views

Last updated: 2009-12-15 Tuesday