Saturday, March 04, 2017

RMAN Backup Details

col STATUS format a9
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;


select object_type,OUTPUT_DEVICE_TYPE,OPERATION,STATUS,START_TIME,END_TIME,OUTPUT_BYTES/1024/1024/1024 as Backup_SIZE_GB
from v$rman_status
 where OBJECT_TYPE is not null and START_TIME > sysdate -2
order by START_TIME;

No comments:

Integrate Oracle ADF with Oracle E-Business Sutie 12.2 ASCP Instance

Integrate Oracle ADF with Oracle E-Business Suite 12.2 ASCP Instance for  SPWA - Supply Planning Work Area What is  Oracle ADF? Orac...