Re: Differential incremental backups
- From: Orlando L <oralrnr@xxxxxxxxx>
- To: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- Date: Thu, 18 Mar 2010 10:21:01 -0500
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:
