I'm putting together a backup strategy for a database using RMAN. It's more involved than what we normally do which is daily full backups of the all data files, archived logs, control files and parameter files. I'm trying to determine what are the disadvantages to just relying upon log files backups as opposed to a combination of log file backups and incrementals. If for example, I were to perform a full backup on Sunday, and then Mon - Saturday perform backups of only the archived and redo logs hourly, would I be doing something bad?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
RMAN; Incremental vs Archived Log Backups
- Thread starter ErrolDC2
- Start date
It depends 
Do you know how long it would take to reapply all the logs to your Sunday backup if you lost the database on Saturday ?
Is this time acceptable ?
If your Sunday backup proves to be defective, do you have the time to apply 2 weeks worth of logs?
Is the backup taking so long that you cannot do it fully every day in a reasonable timeframe?
Alex
Do you know how long it would take to reapply all the logs to your Sunday backup if you lost the database on Saturday ?
Is this time acceptable ?
If your Sunday backup proves to be defective, do you have the time to apply 2 weeks worth of logs?
Is the backup taking so long that you cannot do it fully every day in a reasonable timeframe?
Alex
- Status
Similar threads
- Locked
- Question
- Locked
- Question