diff between incremental and archive backups

From: kathryn axelrod <kat.axe_at_gmail.com>
Date: Sun, 22 Nov 2015 17:29:50 -0800
Message-ID: <CAEbHM456VHGXPr6t-EcV_OWtNMcXVNu0XEHnH_d8cgw=hCmScA_at_mail.gmail.com>

There seem two paths on the topic.
 Replying to the first one, I didn't see this mentioned, so apologize if it was: i'd add the warning that, if the plan has only one copy of the logs backed up and you lose just one of those many logs, you may lose a Lot of data. e.g. you do a full on Sunday, Jan 1..lose one log on Monday, Jan 2 due to corruption or other..and you decide you want to do a pitr on Saturday, January 7..you can't. You'll be forced to go all the way back to right before the missing log.

On Friday, November 13, 2015, Mark W. Farnham <mwf_at_rsiz.com <javascript:_e(%7B%7D,'cvml','mwf_at_rsiz.com');>> wrote:

> Well put.
>
>
>
> Consider also that if a given block is modified many times, then the size
> of the deltas in the redo stream likely exceeds the size of the one current
> version of the block that will need to be written to the incremental backup
> and applied in the course of rolling forward from the full backup through
> any incrementals.
>
>
>
> Having the two possible recovery scenarios might allow you to minimize the
> recovery time depending on the texture of updates to your database.
>
>
>
> mwf
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Sandra Becker
> *Sent:* Friday, November 13, 2015 2:10 PM
> *To:* Brian.Zelli_at_roswellpark.org
> *Cc:* oracle-l (oracle-l_at_freelists.org)
> *Subject:* Re: diff between incremental and archive backups
>
>
>
> Depending on how many archivelogs your database writes in a week, that
> could be a lot of logs to apply. Consider if you have the space to store
> them, or time to restore them to disk, and the time to apply all the logs
> vs. doing incremental backups and applying fewer logs. Just something to
> consider.
>
> Sandy B.
>
>
>
> On Fri, Nov 13, 2015 at 11:59 AM, Zelli, Brian <
> Brian.Zelli_at_roswellpark.org> wrote:
>
> So we were having a discussion about rman incremental backups. And the
> question came up that if I do an rman full once a week and then rman back
> up of the archive logs the rest of the week, that’s all I need to do a
> point in time restore. I don’t have to do incremental backups. Is this an
> accurate assumption?
>
>
>
> Brian
>
>
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
>
>
>
>
> --
>
> Sandy B.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 23 2015 - 02:29:50 CET