RE: Question about RMAN Datafile + Archivelog Backups

    When you include the archive logs and control file and spfile in a backup set then you have a complete backup that you can restore anywhere without anything else needed. On top of that no matter if you include them in the backup of not, you've got to back them up sooner or later.  

Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David Sent: Wednesday, December 02, 2009 11:56 AM To: 'Oracle-L_at_freelists.org'
Subject: Question about RMAN Datafile + Archivelog Backups

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_at_ingrambarge.com
<mailto:chris.taylor_at_ingrambarge.com>  

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.

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