GV$RMAN_STATUS_CURRENT definition in Oracle 10g / www.oracledba.ru
GV$RMAN_STATUS_CURRENT
select
userenv ('Instance'), -- INST_ID NUMBER
SID_KRBMRST, -- SID NUMBER
ID_KRBMRST, -- RECID NUMBER
STAMP_KRBMRST, -- STAMP NUMBER
decode -- PARENT_RECID VARCHAR2(40)
(LEVEL_KRBMRST, 0, NULL, PID_KRBMRST),
decode -- PARENT_STAMP VARCHAR2(40)
(LEVEL_KRBMRST, 0, NULL, PTS_KRBMRST),
L0ID_KRBMRST, -- SESSION_RECID NUMBER
L0TS_KRBMRST, -- SESSION_STAMP NUMBER
LEVEL_KRBMRST, -- ROW_LEVEL NUMBER
decode -- ROW_TYPE VARCHAR2(19)
(LEVEL_KRBMRST, 0, 'SESSION', 1, 'COMMAND', 'RECURSIVE OPERATION'),
CMDID_KRBMRST, -- COMMAND_ID VARCHAR2(33)
UPPER (OPER_KRBMRST), -- OPERATION VARCHAR2(33)
decode -- STATUS VARCHAR2(23)
(STATUS_KRBMRST, 1, 'RUNNING', 1+8, 'RUNNING WITH WARNINGS', 1+16, 'RUNNING WITH ERRORS', 1+8+16, 'RUNNING WITH ERRORS', 2, 'COMPLETED', 2+8, 'COMPLETED WITH WARNINGS', 2+16, 'COMPLETED WITH ERRORS', 2+8+16, 'COMPLETED WITH ERRORS', 'FAILED'),
0, -- MBYTES_PROCESSED NUMBER
to_date -- START_TIME DATE
(START_KRBMRST, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_date -- END_TIME DATE
(END_KRBMRST, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian')
from
x$krbmrst