This view contains information about the history of RMAN operations on all databases associated with this recovery catalog. It contains essentially the same information as V$RMAN_STATUS
, except that it does not contain information about current sessions.
All RMAN operations such as backups, restores, deletion of backups, and so on are logged in this table. The table is organized to show the status of each RMAN session (the invocation of an RMAN client, including all actions taken until the RMAN client exits), operations executed during the session, and recursive operations.
RC_RMAN_STATUS
also contains the RSR_KEY
, PARENT_KEY
and SESSION_KEY
columns, which do not appear in V$RMAN_STATUS
.
Column | Datatype | Description |
---|---|---|
SID |
NUMBER |
The session ID of the session that executed this RMAN operation. |
RECID |
NUMBER |
The recid of the corresponding row in the control file. |
STAMP |
NUMBER |
The timestamp of the row in the control file. (Because control file records are reused, you must combine the timestamp and recid to get a value unique across all records in RC_RMAN_STATUS .) |
PARENT_RECID |
VARCHAR2(40) |
If ROW_TYPE=SESSION (that is, this row has no parents and represents an RMAN session), then this column contains NULL. Otherwise, it contains the recid of the parent row of this row. |
PARENT_STAMP |
VARCHAR2(40) |
If ROW_TYPE=SESSION (that is, this row has no parents and represents an RMAN session), then this column contains NULL. Otherwise, it contains the timestamp of the parent row of this row. |
SESSION_RECID |
NUMBER |
If ROW_TYPE=SESSION (that is, this row has no parents and represents an RMAN session), then this column contains NULL. Otherwise, it contains the recid of the row representing the session associated with this row. |
SESSION_STAMP |
NUMBER |
If ROW_TYPE=SESSION (that is, this row has no parents and represents an RMAN session), then this column contains NULL. Otherwise, it contains the timestamp of the row representing the session associated with this row. |
ROW_LEVEL |
NUMBER |
This is the level of this row.
|
ROW_TYPE |
VARCHAR2(19) |
This is the type of operation represented by this row. Possible values are:
|
COMMAND_ID |
VARCHAR2(33) |
The user-specified ID of the operation. The user can change this using the SET COMMAND ID syntax in RMAN. By default, the command ID is set to the time at which RMAN is invoked, in ISO standard format. |
OPERATION |
VARCHAR2(33) |
This is the name of the operation presented by this row. For SESSION operations, this column is set to 'RMAN'. For COMMAND operations, it describes the command executed, such as "BACKUP", "RESTORE", "CONFIGURE", "REPORT" and so on. |
STATUS |
VARCHAR2(23) |
The status of the operation described by this row. Possible values are: COMPLETED, COMPLETED WITH WARNINGS, COMPLETED WITH ERRORS, and FAILED. |
MBYTES_PROCESSED |
NUMBER |
If the operation represeted by this row performed some data transfer (such as backing up or restoring data) then this column contains the number of megabytes processed in the operation. Otherwise, this row contains NULL. |
START_TIME |
DATE |
The start time for the operation represented by this row. |
END_TIME |
DATE |
The end time for the operation represented by this row. |
RSR_KEY |
NUMBER |
Unique key for this row. |
PARENT_KEY |
NUMBER |
The value of RSR_KEY for the parent row of this row. |
SESSION_KEY |
NUMBER |
The value of RSR_KEY for the session row associated with this row. |
INPUT_MBYTES |
NUMBER |
Sum of sizes of all all input files backed up by this job, in megabytes. |
OUTPUT_MBYTES |
NUMBER |
Sum of sizes of all output files produced by this job, in megabytes. |
OPTIMIZED_ID |
NUMBER |
Used internally by Enterprise Manager. |
OBJECT_TYPE_ID |
NUMBER |
Used internally by Enterprise Manager. |
OUTPUT_DEVICE_TYPE_ID |
NUMBER |
Used internally by Enterprise Manager. |
OPTIMIZED |
VARCHAR2(3) |
YES if backup optimization was applied during the backup job. Otherwise, NO. |
OBJECT_TYPE |
VARCHAR2(50) |
Contains one of the following values: DATABASE FULL, RECOVERY AREA, DATABASE INCR, DATAFILE FULL, DATAFILE INCR, ARCHIVELOG, CONTROLFILE, SPFILE. |
OUTPUT_DEVICE_TYPE |
VARCHAR2(4) |
'DISK', 'SBT_TAPE' or '*'. A '*' indicates that output was written to more than one device type. |
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. |