How to Monitor rman Backup ?
Datafiles Backed up during past 24 Hours
SELECT dbfiles||' from '||numfiles "Datafiles backed up", cfiles "Control Files backed up", spfiles "SPFiles backed up" FROM (select count(*) numfiles from sys.v_$datafile), (select count(*) dbfiles from sys.v_$backup_datafile a, sys.v_$datafile b where a.file# = b.file# and a.completion_time > sysdate - 1), (select count(*) cfiles from sys.v_$backup_datafile where file# = 0 and completion_time > sysdate - 1), (select count(*) spfiles from sys.v_$backup_spfile where completion_time > sysdate - 1)
Archlog Files Backed up during past 24 Hours
SELECT backedup||' from '||archived "Archlog files backed up", ondisk "Archlog files still on disk" FROM (select count(*) archived from sys.v_$archived_log where completion_time > sysdate - 1), (select count(*) backedup from sys.v_$archived_log where backup_count > 0 and completion_time > sysdate - 1), (select count(*) ondisk from sys.v_$archived_log where archived = 'YES' and deleted = 'NO')
RMAN Backups Still Running:
SELECT to_char(start_time,'DD-MON-YY HH24:MI') "BACKUP STARTED", sofar, totalwork, elapsed_seconds/60 "ELAPSE (Min)", round(sofar/totalwork*100,2) "Complete%" FROM sys.v_$session_longops WHERE compnam = 'dbms_backup_restore' / BACKUP STARTED,SOFAR,TOTALWORK,ELAPSE (Min),Complete% 27-JUN-07 09:54,755,45683,2.73333333333333,1.65 27-JUN-07 09:52,1283,10947,4.36666666666667,11.72 27-JUN-07 09:46,11275,11275,0.783333333333333,100 27-JUN-07 09:46,58723,58723,5.73333333333333,100 27-JUN-07 09:46,12363,12363,0.333333333333333,100 27-JUN-07 09:44,11115,11115,4.53333333333333,100 27-JUN-07 09:44,12371,12371,0.183333333333333,100 27-JUN-07 07:34,4706,4706,0.166666666666667,100 27-JUN-07 07:34,83729,83729,118.35,100 27-JUN-07 05:21,8433,8433,0.333333333333333,100 27-JUN-07 05:21,83729,83729,132.25,100
Leave a Reply
You must be logged in to post a comment.