Re: Differential incremental backups
Date: Thu, 18 Mar 2010 08:38:20 -0500
You mean cumulative incremental backup? No. We are using diffrential incremental backup. With that backup strategy will we be able to restore to any point in time after the base backup?
Our need is to be able to go back to any point in time in the past seven days. if that is the case, on Monday I will not be able to go back to previous Thursday, for eg, because the base backup is on Sunday. Am I right in assuming this?
On Thu, Mar 18, 2010 at 8:05 AM, William Muriithi < william.muriithi_at_epicadvertising.com> wrote:
> First, you said differential incremental backup. I believe differential and
> incremental are exclusive to each other if I am not wrong.
> Now assuming incremental, you use the monday full backup and all
> incrementals up to Thursday.
> If its differential, you use the full backup and the last differential
> backup, which is Thursday
> *From*: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>
> *To*: oracle-l_at_freelists.org <oracle-l_at_freelists.org>
> *Sent*: Wed Mar 17 23:57:28 2010
> *Subject*: Differential incremental backups
> I take a base backup on Sunday and take differential incremental backups
> every night and I want to perform recovery on Friday. Will I be able
> to apply backups up to Wednesday night SCN and open the database ? Or will
> I be forced to apply all the incremental backups upto Thursday night before
> I can do open reset logs?