logs are archived but not backed up
358284Mar 20 2006 — edited Mar 28 2006Hi there,
Thanks in advance for any help. I have two questions:
1. Is there anything wrong with the following sequence of RMAN commands for a nightly backup?
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete noprompt expired backup;
backup database;
backup force (archivelog all);
delete noprompt archivelog all completed before 'sysdate-3';
I'm especially interested in the backup force line since I've only started using it recently.
2. By running the above script on a nightly basis, I discovered that I have some redo logs that were archived but not backed up. E.g. if I run the following:
select count(*) from v$archived_log where archived='YES' and BACKUP_COUNT<1;
On one of my servers, the backup of archive logs has stopped since some days ago. But the archive log mode is on and auto archiving is enabled.
Any help will be appreciated. Many thanks.
Gloria