Re: Differential incremental backups
- From: Orlando L <oralrnr@xxxxxxxxx>
- To: Joel.Patterson@xxxxxxxxxxx
- Date: Thu, 18 Mar 2010 13:11:15 -0500
That is the question Joel. I was always under the impression the earliest we
could go back is to the point of base backup, aka level 0 backup. The
previous backups (March 12, Friday as in your example) before the latest
base backup (Mar14, Sunday) and archivelogs would get deleted by RMAN when
we take the Mar 14, Sunday base backup, I assume. So I will not be able to
use them to roll back to Mar 12 if I do restore on Mar 15.
This means this solution will not suit our requirement of wanting to go back
to any point in time in the past 7 calendar days.
On Thu, Mar 18, 2010 at 12:03 PM, <Joel.Patterson@xxxxxxxxxxx> wrote:
> I read him as asking something nobody is picking up on. As I read his
> concern it says regardless of type of backup, if the level 0, or whatever
> base is taken on Sunday, March 14th, and he has archives for the entire
> month of march, can he recover to Friday March 12th. For the sake of
> the example he does not have another base backup supporting Friday, March 12
> th.
>
>
>
>
>
> Orlando can confirm if this isn’t the actual question. Of course as
> with all backup scenarios, as Jared pointed out, one should test it
> regardless of whether you believe you have the answers or not.
>
>
>
> Joel Patterson
> Database Administrator
> 904 727-2546
> ------------------------------
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Orlando L
> *Sent:* Thursday, March 18, 2010 11:21 AM
> *To:* Guillermo Alan Bort
> *Cc:* andrey.hudyakov@xxxxxxxxx; william.muriithi@xxxxxxxxxxxxxxxxxxx;
> oracle-l@xxxxxxxxxxxxx
>
> *Subject:* Re: Differential incremental backups
>
>
>
>
>
> Thanks. I wonder how it can restore to previous Friday if a base backup
> gets taken Sunday night. I thought it would restore base backup first and
> then apply incremental on the top of that base backup. I thought the
> backups taken before base backup were useless and cannot be used to restore
> to a point in time in last week, even if recovery window of 7 days is
> specified. ie, in this example, wanting to go back to last Friday on a given
> Monday, with a base backup on Sunday.
>
>
>
>
>
> On Thu, Mar 18, 2010 at 8:55 AM, Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
> wrote:
>
> Orlando,
>
> Also keep in mind that RMAN automatically manages retentions for you, so
> if you tell it that you need to have a retention policy of 'RECOVERY WINDOW
> 7 DAYS', it will automatically keep all the backup files required to
> guarantee that policy. You will also have to use RMAN commands to ensure
> backup consistency when deleteing files (namely: delete obsolete).
>
> Also, read the RMAN documentation, there are a lot of answers there:
>
> http://www.oracle.com/technology/deploy/availability/htdocs/rman_overview.htm
> http://www.oracle.com/pls/db102/portal.portal_db?selected=4
> Alan.-
>
>
>
> On Thu, Mar 18, 2010 at 10:43 AM, andrey khudyakov <
> andrey.hudyakov@xxxxxxxxx> wrote:
>
> William, you are mistaken.
>
> differential and comulative are exclusive to each other, but each of them
> is incremental backup.
>
>
>
> Orlando, if you want recover your database till some <recover_point>, you
> should have available all incremental backups until recover_point and all
> archived logs between start_time of last incremental backup and
> recover_point
>
>
>
> 2010/3/18 William Muriithi <william.muriithi@xxxxxxxxxxxxxxxxxxx>
>
>
>
> 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
>
>
> ------------------------------
>
>
>
>
>
>
>
>
>
>
>
>
>
Other related posts:
