To see if archived logs got backed up in last 24 hours and how many are still sitting on the disks, use the script below
SELECT backedup||' out of '||archived||' archive logs backed up' "Archlog files backed up",
ondisk "Archlog files on disk"
FROM (select count(*) archived
from v$archived_log where completion_time > sysdate - 1),
(select count(*) backedup from v$archived_log
where backup_count > 0
and completion_time > sysdate - 1),
(select count(*) ondisk from v$archived_log
where archived = 'YES' and deleted = 'NO');
SELECT backedup||' out of '||archived||' archive logs backed up' "Archlog files backed up",
ondisk "Archlog files on disk"
FROM (select count(*) archived
from v$archived_log where completion_time > sysdate - 1),
(select count(*) backedup from v$archived_log
where backup_count > 0
and completion_time > sysdate - 1),
(select count(*) ondisk from v$archived_log
where archived = 'YES' and deleted = 'NO');
0 comments:
Post a Comment