Displaying Backup Information Oracle Database

[oracle@VTGDB-Server app]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Thu Feb 25 13:56:15 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select session_key, input_type, status, start_time, end_time, elapsed_seconds/3600 hrs from v$rman_backup_job_details;

SESSION_KEY INPUT_TYPE  STATUS  START_TIM END_TIME     HRS
----------- ------------- ----------------------- --------- --------- ----------
 2 DB FULL  COMPLETED  25-FEB-16 25-FEB-16 .331388889
 6 DB FULL  FAILED  25-FEB-16 25-FEB-16 .004166667
11 DB FULL  COMPLETED  25-FEB-16 25-FEB-16 .097777778
22 DB FULL  COMPLETED  25-FEB-16 25-FEB-16 .098333333
31 DB FULL  RUNNING  25-FEB-16 25-FEB-16 .040555556

Tweet