Re: Question about RMAN Datafile + Archivelog Backups

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: ChrisDavid.Taylor@xxxxxxxxxxxxxxx
  • Date: Wed, 2 Dec 2009 09:20:51 -0800

If the archive logs are not included with the backup,
there's a pretty good chance you will run into a
scenario where a restore is needed, but not all
the required archive logs are available.

Suppose the storage crashes 12 hours after the backup?

Not only would the 12 hours of work be lost because the
archive logs were not backed up, but the backup itself
would likely be useless, as the archive logs created during
the backup would not be available.

This seems a good opportunity for you to educate
folks regarding the basics of Oracle recovery so they
understand why archive logs MUST be backed up.

Quite a few DBA's not only duplex archive logs, but also
back them up twice before deleting them.


Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com



On Wed, Dec 2, 2009 at 8:56 AM, 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: