Question : How We will check Oracle 18c or 12.2 Database Backup Monitoring
Query : Use below query to get backup status details
set line 300
col STATUS format a30
col INPUT_TYPE for a10
col hrs format 999.99
col START_TIME for a30
col END_TIME for a30
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 :
SQL> set line 300
SQL> col STATUS format a30
col INPUT_TYPE for a10
col hrs format 999.99
col START_TIME for a30
col END_TIME for a30
SQL> SQL> SQL> SQL> SQL> 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; 2 3 4 5 6
SESSION_KEY INPUT_TYPE STATUS START_TIME END_TIME HRS
----------- ---------- ------------------------------ ------------------------------ ------------------------------ -------
25133 DB INCR COMPLETED 02/28/19 20:25 02/28/19 23:00 2.59
25141 DB INCR COMPLETED 03/01/19 20:25 03/01/19 23:01 2.61
25149 DB FULL COMPLETED 03/02/19 20:25 03/03/19 00:00 3.59
25155 DB INCR COMPLETED 03/03/19 20:25 03/03/19 22:53 2.47
25163 DB INCR COMPLETED 03/04/19 20:25 03/04/19 23:05 2.67
Query : Use below query to get backup status details
set line 300
col STATUS format a30
col INPUT_TYPE for a10
col hrs format 999.99
col START_TIME for a30
col END_TIME for a30
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 :
SQL> set line 300
SQL> col STATUS format a30
col INPUT_TYPE for a10
col hrs format 999.99
col START_TIME for a30
col END_TIME for a30
SQL> SQL> SQL> SQL> SQL> 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; 2 3 4 5 6
SESSION_KEY INPUT_TYPE STATUS START_TIME END_TIME HRS
----------- ---------- ------------------------------ ------------------------------ ------------------------------ -------
25133 DB INCR COMPLETED 02/28/19 20:25 02/28/19 23:00 2.59
25141 DB INCR COMPLETED 03/01/19 20:25 03/01/19 23:01 2.61
25149 DB FULL COMPLETED 03/02/19 20:25 03/03/19 00:00 3.59
25155 DB INCR COMPLETED 03/03/19 20:25 03/03/19 22:53 2.47
25163 DB INCR COMPLETED 03/04/19 20:25 03/04/19 23:05 2.67
No comments:
Post a Comment