Home > database >  A little doubt about Oracle backup strategy
A little doubt about Oracle backup strategy

Time:09-28

Newcomers are learning Oracle backup strategy... Companies use the database is not in the archive mode, I usually use timing export user object + exp DMP file to backup (whether very backward==);

Want to do on your test environment recently a regular backup strategy out (after all, the company always are not always doesn't open archive), after learning the RMAN, produced a doubt, at here, I hope each master when you're free to teach two other orz,

RMAN backup on archive mode, but the archive mode is always open, consumes a lot of space, so the archive log usually set the period of validity, such as the seven days, more than the archive logs as the expiration time, RMAN archive log files regularly expire, to limit the archive log files doesn't take up too much space;

Question: the recovery of RMAN should not be in accordance with the sequence of archive logs to recover? For instance from arc1, arc2,... , arc7, if now arc1, arc2 arc3, arc4 has expired and was removed, so after the recovery will be in accordance with the arc5, arc6, arc7 order read and restore the database;
But so, arc1 arc4 these log data? Although these data must be persisted to disk early, but one thousand disk is broken! The expiration of the archive log is not data cannot be restored? !

I hope each master can answer.

CodePudding user response:

Backup recovery strategy is very complex,
Rman backup and not only do a level 0 backup, according to the strategy situation, according to how long you want to restore the recent data,
May retain for a level 0 backup and recently a period of time the incremental backup
Level 0 backup according to the strategy to time will do a new, then too old is no longer need to, you can delete the

CodePudding user response:

Complete backup strategy, normal recovery make not use expired archive log
If your ARC1 \ ARC2 \ ARC3 will remove due to expire, there must be a level 0 backup or incremental backup to complete this part of work

CodePudding user response:

Since a backup deleted, must want to have a new backup can replace it, or delete the event
  • Related