Friday, April 5, 2019

Oracle 18c Database Backup Monitoring

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

No comments:

Post a Comment

How can I restore Cassandra snapshots?