DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, June 27, 2016

Query to check RMAN job status

Please use the below query to check for RMAN job status in DB level.

col INPUT_TYPE format a15
col STATUS format a12
col START_TIME format a18
col END_TIME format a18
col OUTPUT_BYTES_DISPLAY a25
col OUTPUT_BYTES_DISPLAY format a25
col TIME_TAKEN_DISPLAY format a25
select session_key,
       input_type,
       to_char(start_time,'yyyy-mm-dd hh24:mi') start_time,
       to_char(end_time,'yyyy-mm-dd hh24:mi')   end_time,
       output_bytes_display,
       time_taken_display,
  status
from v$rman_backup_job_details
order by session_key asc;

No comments: