Re: Differential incremental backups

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Thu, 18 Mar 2010 10:55:07 -0300
Message-ID: <172762181003180655k11accdebl7aff36112e671aed_at_mail.gmail.com>



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 - 08:55:07 CDT

Original text of this message