Thanks for the question, Fahd.
Asked: August 14, 2022 - 9:42 pm UTC
Last updated: August 16, 2022 - 2:53 am UTC
Version: 11.2.0.1
Viewed 1000+ times
You Asked
Hi team,
i take Level-0 backup on Sunday, then from monday to saturday i take differential incremental backups.
i want to restore backup on another machine, i have control file backup of Sunday. i can restore level-0 backup easily using control file of Sunday because Sunday control file has information of level-0 backup.
how can i apply Monday to Saturday differential incremental backup on level-0 backup of Sunday ?
Thanks & Regards
Fahd
and Connor said...
Unless you've explicitly disabled it, every time you take a backup, the database will grab a copy of the controlfile in that backup as well.
This means, when you come to restore (to say Thursday), you should restore the (say) Thursday backup of the controlfile, because it will know about last Sunday's level 0 *and* the differentials taken as well.
Then you just to restore/recover to your nominated point in time, and RMAN will use the information in the controlfile to
- restore the level 0
- restore the latest most applicable differential
- apply archivelogs to get things back in sync.
If you restored Sunday's controlfile, it does not know about the differentials. Even in this case, you could still restore but in order to get to Thursday, you would do:
- restore the level 0
- apply 4 days worth of archivelogs to get things up to Thursday
Is this answer out of date? If it is, please let us know via a Comment