ORACLEDBWR
Company
Resume
Query to find rman backup status
Latest
Query To Find RMAN Backup Status
June 27, 2023
Description:- In this article we are going to see the below query to check rman backup status.
Demo:- Query to check rman backup status:- col STATUS format a10 col hrs format 999.99 select SESSION_KEY, INPUT_TYPE, STATUS,to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; Output The post Query To Find RMAN Backup Status first appeared on Oracledbwr.
June 27, 2023
Description:- In this article we are going to see the below query to check rman backup status.
Demo:- Query to check rman backup status:- col STATUS format a10 col hrs format 999.99 select SESSION_KEY, INPUT_TYPE, STATUS,to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; Output The post Query To Find RMAN Backup Status first appeared on Oracledbwr.
Profile last updated on September 6th, 2024