Database version: 12.1
I want to know if there are any RMAN backup jobs currently running.
And if there are any RMAN jobs running, I want to know if it is an L0, L1 or Archive log backup.
Which view can I use for that ?
I ran the following query which uses v$rman_status view.
But, the END_TIME always shows the current time !
Plus, v$rman_status does not provide info on whether the backup which is currently being run is L0, L1 or Archive log
The only useful information I got from the below query is that there is an RMAN job which started running at 29-SEP-2021 20:40:13 , nothing much
SQL> select distinct status from V$RMAN_BACKUP_JOB_DETAILS;
STATUS
-----------------------
COMPLETED
FAILED
SQL>
SQL> SELECT status,
operation,
To_char(start_time, 'DD-MON-YYYY HH24:MI:SS') AS START_TIME,
To_char(end_time, 'DD-MON-YYYY HH24:MI:SS') AS END_TIME,
To_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') current_time,
MBYTES_PROCESSED
FROM v$rman_status
WHERE start_time > SYSDATE - 1
2 3 4 5 AND status LIKE 'RUNNING%'; 6 7 8 9
STATUS OPERATION START_TIME END_TIME CURRENT_TIME MBYTES_PROCESSED
----------------------- --------------------------------- ----------------------------- ----------------------------- ----------------------------- ----------------
RUNNING RMAN 29-SEP-2021 20:40:13 29-SEP-2021 21:28:54 29-SEP-2021 21:28:54 0
SQL>