Database Backup and Recovery (MOSC)

MOSC Banner

How to address potential data loss scenario with recovery?

edited Jun 5, 2014 10:26AM in Database Backup and Recovery (MOSC) 5 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center