Re: Question about RMAN Datafile + Archivelog Backups

From: <>
Date: Wed, 2 Dec 2009 17:16:30 +0000

If you want to do hot backups, you need those archive logs or you will not be able to recover since your datafiles will be inconsistent when you restore them. Sent from my Verizon Wireless BlackBerry

-----Original Message-----

From: "Taylor, Chris David" <> Date: Wed, 2 Dec 2009 10:56:28
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:16:30 CST

Original text of this message