Set up a friendly environment to share my understanding and ideas about Oracle / Oracle Spatial database administration, ESRI ArcSDE Geodatabase administration and UNIX (Solaris) operating system.
V$RMAN_BACKUP_SUBJOB_DETAILS merges similar operations within an RMAN session into a single row. For example, if there are four BACKUP DATAFILE commands, three RECOVERY COPY OF DATAFILE commands, and one BACKUP RECOVERY AREA command, this view will contain three rows - one each for BACKUP, ROLLFORWARD, and COPY_DISK_TO_TAPE operation.
Column
Datatype
Description
SESSION_KEY
NUMBER
Session identifier
SESSION_RECID
NUMBER
Together with SESSION_KEY and SESSION_STAMP, used to uniquely identify job output from V$RMAN_OUTPUT
SESSION_STAMP
NUMBER
Together with SESSION_KEY and SESSION_RECID, used to uniquely identify job output from V$RMAN_OUTPUT
OPERATION
VARCHAR2(33)
Can be BACKUP, ROLLFORWARD, VALIDATE, or COPY_DISK_TO_TAPE. A row for each suboperation type for the session will be in the output view.
COMMAND_ID
VARCHAR2(33)
Either a user-specified SET COMMAND ID or a unique command ID generated by RMAN
START_TIME
DATE
Start time of the first BACKUP command in the job
END_TIME
DATE
End time of the last BACKUP command in the job
INPUT_BYTES
NUMBER
Sum of all input file sizes backed up by this job
OUTPUT_BYTES
NUMBER
Output size of all 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)
Can be DISK, SBT, or *. An * indicates more than one device (in most cases, it will be DISK or SBT).
AUTOBACKUP_DONE
VARCHAR2(3)
YES or NO, depending upon whether or not 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. If the user command does not satisfy one of them, then preference is given in order, from top to bottom of the list.
·DB FULL
·RECVR AREA
·DB INCR
·DATAFILE FULL
·DATAFILE INCR
·ARCHIVELOG
·CONTROLFILE
·SPFILE
OPTIMIZED
VARCHAR2(3)
YES or NO, depending on whether optimization was applied. Applicable to backup jobs only.
AUTOBACKUP_COUNT
NUMBER
Number of autobackups performed by this job
COMPRESSION_RATIO
NUMBER
Compression ratio
INPUT_BYTES_DISPLAY
VARCHAR2(4000)
Values in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on.
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
Values in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on.
Thank you for visiting Spatial DBA - Oracle and ArcSDE.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
==================================================================
V$RMAN_BACKUP_JOB_DETAILS displays details about backup jobs.
Column
Datatype
Description
SESSION_KEY
NUMBER
Session identifier
SESSION_RECID
NUMBER
Together, with SESSION_KEY and SESSION_STAMP, used to uniquely identify job output from V$RMAN_OUTPUT
SESSION_STAMP
NUMBER
Together, with SESSION_KEY and SESSION_RECID, used to uniquely identify job output from V$RMAN_OUTPUT
COMMAND_ID
VARCHAR2(33)
Either a user-specified SET COMMAND ID or a unique command ID generated by RMAN
START_TIME
DATE
Start time of the first BACKUP command in the job
END_TIME
DATE
End time of the last BACKUP command in the job
INPUT_BYTES
NUMBER
Sum of all input file sizes backed up by this job
OUTPUT_BYTES
NUMBER
Output size of all pieces generated by this job
STATUS_WEIGHT
NUMBER
Used internally by Enterprise Manager
OPTIMIZED_WEIGHT
NUMBER
Used internally by Enterprise Manager
OBJECT_TYPE_WEIGHT
NUMBER
Used internally by Enterprise Manager
OUTPUT_DEVICE_TYPE
VARCHAR2(17)
Can be DISK, SBT, or *. An * indicates more than one device (in most cases, it will be DISK or SBT).
AUTOBACKUP_COUNT
NUMBER
Number of autobackups performed by this job
AUTOBACKUP_DONE
VARCHAR2(3)
YES or NO, depending upon whether or not a control file autobackup was done as part of this backup 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. If the user command does not satisfy one of them, then preference is given in order, from top to bottom of the list.
·DB FULL
·RECVR AREA
·DB INCR
·DATAFILE FULL
·DATAFILE INCR
·ARCHIVELOG
·CONTROLFILE
·SPFILE
OPTIMIZED
VARCHAR2(3)
YES or NO, depending on whether optimization was applied. Applicable to backup jobs only.
ELAPSED_SECONDS
NUMBER
Number of elapsed seconds
COMPRESSION_RATIO
NUMBER
Compression ratio
INPUT_BYTES_PER_SEC
NUMBER
Input read-rate-per-second
OUTPUT_BYTES_PER_SEC
NUMBER
Output write-rate-per-second
INPUT_BYTES_DISPLAY
VARCHAR2(4000)
Values in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on.
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
Values in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on
INPUT_BYTES_PER_SEC_DISPLAY
VARCHAR2(4000)
Input read-rate-per-second. These values are in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on.
OUTPUT_BYTES_PER_SEC_DISPLAY
VARCHAR2(4000)
Output write-rate-per-second. These values are in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on.
TIME_TAKEN_DISPLAY
VARCHAR2(4000)
Time taken, shown in user-displayable format h:m:s
Accessing V$RMAN_BACKUP_JOB_DETAILS will cause a performance issue in Oracle 10.2.0.2 – 10.2.0.4. There are several notes related the view in Metalink.
The workaround is:
SQL> Connect / as sysdba
exec dbms_stats.DELETE_TABLE_STATS('SYS','X$KCCRSR');
exec dbms_stats.LOCK_TABLE_STATS('SYS','X$KCCRSR');
I reserve the right to delete comments that are not contributing to the overall theme of the BLOG or are insulting or demeaning to anyone. The posts on this BLOG are provided "as is" with no warranties and confer no rights. The opinions expressed on this site are mine and mine alone, and do not necessarily represent those of my employer.
