How to address potential data loss scenario with recovery?
We are using database version 11.2.0.3
Following is our rman backup script that runs full database and archivelog backup every day:
RUN {
BACKUP
FULL
TAG
Daily_Full_Backup
DATABASE FILESPERSET=1;
BACKUP
CURRENT
CONTROLFILE;
SQL 'alter system archive log current';
BACKUP
ARCHIVELOG ALL
FORMAT '/ebs/backup/prod/archctl/%d_%t_%s_%p.arch';
DELETE NOPROMPT OBSOLETE;
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
}
So supposedly with this backup running everyday, if a server failure or storage failure should surface, archivelogs not backedup since last backup might be lost and there maybe data loss. How might we address this situation other than setup multiple archive log backup throughout the day? Gurus, please advise. Thank you very much.