Skip Headers
Oracle® Database Backup and Recovery Reference
10g Release 2 (10.2)

Part Number B14194-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

RC_BACKUP_SPFILE_DETAILS

RC_BACKUP_SPFILE_DETAILS provides detailed information about SPFILE backups for each database registered in the recovery catalog.

This view is primarily intended to be used internally by Enterprise Manager.

Column Datatype Description
SESSION_KEY NUMBER Session identifier. Use in joins with RC_RMAN_OUTPUT.
SESSION_RECID NUMBER Together with SESSION_STAMP, uniquely identifies output for this backup job from RC_RMAN_OUTPUT.
SESSION_STAMP NUMBER Together with SESSION_RECID, uniquely identifies output for this backup job from RC_RMAN_OUTPUT.
DB_KEY NUMBER The primary key for this database in the recovery catalog. Use this column to form a join with almost any other catalog view.
DB_NAME VARCHAR2(8) The DB_NAME of the database incarnation to which this record belongs.
BS_KEY NUMBER Unique backup set identifier.
SET_STAMP NUMBER Set stamp.
SET_COUNT NUMBER Set count.
MODIFICATION_TIME DATE Modification time.
FILESIZE NUMBER Size in bytes of the SPFILE that was backed up.
FILESIZE_DISPLAY VARCHAR2(4000) Same value as FILESIZE, but converted to a user-displayable format, for example nM, nG, nT, nP..