Re: Differential incremental backups

From: Orlando L <oralrnr_at_gmail.com>
Date: Thu, 18 Mar 2010 10:21:01 -0500
Message-ID: <4e0c9d991003180821ga12764sb8876206a5089591_at_mail.gmail.com>

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 - 10:21:01 CDT