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
View PDF

RC_RMAN_BACKUP_SUBJOB_DETAILS

RC_RMAN_BACKUP_SUBJOB_DETAILS provides details for groups of similar operations within an RMAN session.

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

Column Datatype Description
DB_KEY NUMBER The primary key for this database.
DB_NAME VARCHAR2(8) The DB_NAME of the database incarnation to which this record belongs.
SESSION_KEY NUMBER Session identifier. Use in joins with RC_RMAN_OUTPUT.
SESSION_RECID NUMBER Together with SESSION_KEY and SESSION_STAMP, used to uniquely identify job's output from RC_RMAN_OUTPUT
SESSION_STAMP NUMBER Together with SESSION_RECID and SESSION_KEY, used to uniquely identify job's output from RC_RMAN_OUTPUT
OPERATION VARCHAR2(33) The possible values are BACKUP , ROLLFORWARD, VALIDATE, or BACKUPSET. For each operation type in a session, the view contains one row with each value representing all operations of that type during the session.
COMMAND_ID VARCHAR2(33) Either a user-specified value set using SET COMMAND ID, or an RMAN-generated unique command id.
START_TIME DATE Start time of the first backup command in the job
END_TIME DATE End time of the last backup job in the job.
INPUT_BYTES NUMBER Sum of sizes of all input files backed up during this job.
OUTPUT_BYTES NUMBER Sum of sizes of all output pieces generated by this job.
STATUS_WEIGHT NUMBER Used internally by Enterprise Manager.
OBJECT_TYPE_WEIGHT NUMBER Used internally by Enterprise Manager.
OPTIMIZED_WEIGHT NUMBER Used internally by Enterprise Manager.
OUTPUT_DEVICE_TYPE VARCHAR2(17) 'DISK', 'SBT_TAPE' or '*'. A '*' indicates a backup job that wrote its output to more than one device type.
AUTOBACKUP_DONE VARCHAR2(3) 'YES' or 'NO', depending upon whether a control file autobackup was done as part of this job.
STATUS VARCHAR2(23) One of the following values: RUNNING WITH WARNINGS, RUNNING WITH ERRORS, 'COMPLETED', 'COMPLETED WITH WARNINGS', 'COMPLETED WITH ERRORS', 'FAILED
INPUT_TYPE VARCHAR2(13) Contains one of the following values: DATABASE FULL, RECOVERY AREA, DATABASE INCR, DATAFILE FULL, DATAFILE INCR, ARCHIVELOG, CONTROLFILE, SPFILE.

When a subjob includes backups corresponding to more than one of these values, multiple rows will appear in the view, corresponding to the different INPUT_TYPE values for each type of input, with corresponding values for the INPUT_BYTES, OUTPUT_BYTES, INPUT_BYTES_DISPLAY, OUTPUT_BYTES_DISPLAY fields.

OPTIMIZED VARCHAR2(3) If OPERATION=BACKUP, then OPTIMIZED is 'YES' or 'NO', depending on whether backup optimization was applied.
AUTOBACKUP_COUNT NUMBER Number of autobackups performed by this job.
COMPRESSION_RATIO NUMBER Compression ratio for this backup.
INPUT_BYTES_DISPLAY VARCHAR2(4000) Same value as INPUT_BYTES, but converted to a user-displayable format, for example nM, nG, nT, nP.
OUTPUT_BYTES_DISPLAY VARCHAR2(4000) Same value as OUTPUT_BYTES, but converted to a user-displayable format, for example nM, nG, nT, nP.