RE: Question about RMAN Datafile + Archivelog Backups

From: Goulet, Richard <>
Date: Wed, 2 Dec 2009 12:06:29 -0500
Message-ID: <>


    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  

[] On Behalf Of Taylor, Chris David Sent: Wednesday, December 02, 2009 11:56 AM To: ''
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


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.

Received on Wed Dec 02 2009 - 11:06:29 CST

Original text of this message