Skip Headers

Oracle® Database Recovery Manager Reference
10g Release 1 (10.1)

Part Number B10770-02
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
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

RC_RMAN_STATUS

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.

  • If ROW_LEVEL=0 then this is a session row (that is, ROW_TYPE=SESSION and the row represents an invocation of the RMAN client).
  • If ROW_LEVEL=1 then this row represents a command entered in the RMAN client and executed. (ROW_TYPE=COMMAND for rows at level 1.)
  • IF ROW_LEVEL>1 then this row represents a recursive operation, a sub-operation of an RMAN command (such as a control file autobackup performed in conjunction with a database backup). (ROW_TYPE=RECURSIVE OPERATION for rows at levels >1.)

ROW_TYPE

VARCHAR2(19)

This is the type of operation represented by this row. Possible values are:

  • SESSION, for rows at level 0
  • COMMAND, for rows at level 1
  • RECURSIVE OPERATION, for rows at level >1

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

 

Unique key for this row.

PARENT_KEY

 

The value of RSR_KEY for the parent row of this row.

SESSION_KEY

 

The value of RSR_KEY for the session row associated with this row.