Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

logs are archived but not backed up

358284Mar 20 2006 — edited Mar 28 2006
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2006
Added on Mar 20 2006
9 comments
6,629 views