Re: Differential incremental backups

From: Orlando L <oralrnr_at_gmail.com>
Date: Thu, 18 Mar 2010 12:49:39 -0500
Message-ID: <4e0c9d991003181049s2246d9a4mb92890470f0c3bb8_at_mail.gmail.com>



I think that answers my question. The earliest we can go back is to the last base backup. If we have incremental backups and or archive logs before base backups, they are not of use even if RMAN retention window is set to 7 days.

Thanks everyone who contributed. I will test it out, but they want some quick answers.

On Thu, Mar 18, 2010 at 12:18 PM, Robert Freeman <robertgfreeman_at_yahoo.com>wrote:

> If that is the question...
>
> assume you had all archived redo from 3.12.2010 forward.
> assume you took a level 0 backup on 3.14.2010 (with archived redo logs).
> Any incremental backups after that are not Germaine to this question.
>
> Could you restore to 3.12.2010? Answer no. You could only restore/recover
> to the point of the END of the level 0 taken on 3.14.2010. If you had a
> single, level 0 backup taken before the point-in-time you wish to restore
> to, then recovery is possible.
>
>
> RF
>
>
> Robert G. Freeman
> Master Principle Consultant, Oracle Corporation
> Oracle ACE
> Author:
> Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY
> SOON!
> OCP: Oracle Database 11g Administrator Certified Professional Study Guide
> (Sybex)
> Oracle Database 11g New Features (Oracle Press)
> Oracle Database 10g New Features (Oracle Press)
> Other various titles
> Blog: http://robertgfreeman.blogspot.com
>
>
> ------------------------------
> *From:* "Joel.Patterson_at_crowley.com" <Joel.Patterson_at_crowley.com>
> *To:* oralrnr_at_gmail.com; cicciuxdba_at_gmail.com
>
> *Cc:* andrey.hudyakov_at_gmail.com; william.muriithi_at_epicadvertising.com;
> oracle-l_at_freelists.org
> *Sent:* Thu, March 18, 2010 10:03:57 AM
> *Subject:* RE: Differential incremental backups
>
> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Orlando L
> *Sent:* Thursday, March 18, 2010 11:21 AM
> *To:* Guillermo Alan Bort
> *Cc:* andrey.hudyakov_at_gmail.com; william.muriithi_at_epicadvertising.com;
> oracle-l_at_freelists.org
> *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_at_gmail.com>
> 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_at_gmail.com> 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_at_epicadvertising.com>
>
>
>
> 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
>
>
> ------------------------------
>
>
>
>
>
>
>
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 18 2010 - 12:49:39 CDT

Original text of this message