Re: Question about RMAN Datafile + Archivelog Backups
- From: Dan Norris <dannorris@xxxxxxxxxxxxx>
- To: ChrisDavid.Taylor@xxxxxxxxxxxxxxx
- Date: Wed, 2 Dec 2009 17:19:24 +0000
If you're making online backups, you'll need all the archived logs since the
most recent backup *started* in order to recover. That's why you should
backup those logs at the end of the backup routine. Without the logs since
the backup started, you cannot recover at all. If you at least have the logs
since backup start, you can recover up until the PIT of the archived log
backup.
Dan
On Wed, Dec 2, 2009 at 4:56 PM, Taylor, Chris David <
ChrisDavid.Taylor@xxxxxxxxxxxxxxx> wrote:
> What are the risks of NOT including archivelogs as part of the RMAN
> routine backups?
>
>
>
> I have been tasked with reducing our backup sizes and was asked if we had
> to include archivelogs in our backups.
>
>
>
> I realized that I didn’t have a real good answer to this. My gut says to
> backup everything, but I cannot think of an exceptional reason to include
> archivelogs in my backup sets. When you have to restore you only need the
> archivelogs since the last backup, right? Or am I forgetting something
> important here?
>
>
>
>
>
> *Chris Taylor*
>
> *Sr. Oracle DBA*
>
> Ingram Barge Company
>
> Nashville, TN 37205
>
> Office: 615-517-3355
>
> Cell: 615-354-4799
>
> Email: chris.taylor@xxxxxxxxxxxxxxx
>
>
>
> *CONFIDENTIALITY NOTICE**: This e-mail and any attachments are
> confidential and may also be privileged. If you are not the named recipient,
> please notify the sender immediately and delete the contents of this message
> without disclosing the contents to anyone, using them for any purpose, or
> storing or copying the information on any medium.*
>
Other related posts:
