|
-
As I understood, the incrementally updated backups primarily help when you have to restore or recover the database.
Before going down this route, it might be good to compare the time savings on your environment for a level 0 vs. level 1 backup. Based on that, you could decide whether a level 1 with incrementally updated option is better or level 0 is better.
There is certainly advantage for incrementally updated backups. As an example, if I take level 0 backup on Sunday and take level 1 from Mon-Fri. On Sat, if recovery needs to be done, it would involve restoring level 0 of Sunday and applying the 5 incrementals taken during the week.
With the incrementally updated backups, I would have to apply only 1 incremental, since my level 0 backup of Sunday is already recovered and pushed forward to Thursday (with incrementally updated backup feature) and I only need to apply Friday's incremental.
Instead of spending the time during actual recovery, the time is spent during a normal backup.
I found the below article to be useful in understanding this feature
http://www.nyoug.org/Presentations/SIG/DBA/10grman.pdf (i like to end my responses with a smile..didn't mean to offend)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|