20 lines
445 B
SQL
20 lines
445 B
SQL
SELECT s.START_TIME
|
|
,s.status
|
|
,s.row_type
|
|
,s.operation
|
|
,s.object_type
|
|
,s.output_device_Type
|
|
,o.output
|
|
FROM v$rman_status s
|
|
, v$rman_output o
|
|
WHERE o.db_key = s.db_key
|
|
AND o.rsr_key = s.RSR_KEY
|
|
AND o.session_key = s.SESSION_KEY
|
|
AND s.start_time > sysdate - 1
|
|
AND s.status NOT IN ( 'COMPLETED' )
|
|
ORDER by s.START_TIME
|
|
, o.stamp
|
|
, o.recid
|
|
;
|
|
|