Query for EM 11 to monitoring all backups:
SELECT b.database_name AS "DB Name",
t.type_qualifier1 AS "Version",
b.host AS "Server Name" ,
b.target_type AS "Type",
TO_CHAR(b.start_time, 'YYYYMMDD-HH24:MI:SS') AS "Start Time",
TO_CHAR(b.end_time, 'YYYYMMDD-HH24:MI:SS') AS "End Time",
b.input_type "Backup Info",
b.time_taken_display AS "Time taken",
b.output_bytes_display AS "Final Size Bytes",
status AS "Status"
FROM mgmt$ha_backup b,
mgmt$target t
WHERE b.target_guid = t.target_guid
AND b.start_time > sysdate -2
ORDER BY type_qualifier1,
END_TIME ;
and progress restoring or backup from RMAN:
SELECT OPNAME,
SOFAR /TOTALWORK*100 PCT,
TRUNC(TIME_REMAINING /60) MIN_RESTANTES,
TRUNC(ELAPSED_SECONDS/60) MIN_ATEAGORA
FROM V$SESSION_LONGOPS
WHERE TOTALWORK>0
AND OPNAME LIKE '%RMAN%';
SELECT b.database_name AS "DB Name",
t.type_qualifier1 AS "Version",
b.host AS "Server Name" ,
b.target_type AS "Type",
TO_CHAR(b.start_time, 'YYYYMMDD-HH24:MI:SS') AS "Start Time",
TO_CHAR(b.end_time, 'YYYYMMDD-HH24:MI:SS') AS "End Time",
b.input_type "Backup Info",
b.time_taken_display AS "Time taken",
b.output_bytes_display AS "Final Size Bytes",
status AS "Status"
FROM mgmt$ha_backup b,
mgmt$target t
WHERE b.target_guid = t.target_guid
AND b.start_time > sysdate -2
ORDER BY type_qualifier1,
END_TIME ;
and progress restoring or backup from RMAN:
SELECT OPNAME,
SOFAR /TOTALWORK*100 PCT,
TRUNC(TIME_REMAINING /60) MIN_RESTANTES,
TRUNC(ELAPSED_SECONDS/60) MIN_ATEAGORA
FROM V$SESSION_LONGOPS
WHERE TOTALWORK>0
AND OPNAME LIKE '%RMAN%';
Brak komentarzy:
Prześlij komentarz