24 lines
556 B
SQL
24 lines
556 B
SQL
SELECT s.session_key
|
|
,s.START_TIME
|
|
,s.DB_NAME
|
|
,s.status
|
|
,s.row_type
|
|
,s.operation
|
|
,s.object_type
|
|
,s.output_device_Type
|
|
,o.output
|
|
FROM rc_rman_status s
|
|
, rc_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 o.session_key = 123456
|
|
-- AND s.db_name like '%BOB%'
|
|
-- AND s.start_time > sysdate - 1
|
|
-- AND s.status NOT IN ( 'COMPLETED' )
|
|
ORDER by s.START_TIME
|
|
, o.stamp
|
|
, o.recid
|
|
;
|
|
|