Re: Question about RMAN Datafile + Archivelog Backups
- From: troach@xxxxxxxxx
- To: ChrisDavid.Taylor@xxxxxxxxxxxxxxx,"'Oracle-L@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- 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" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
Date: Wed, 2 Dec 2009 10:56:28
To: 'Oracle-L@xxxxxxxxxxxxx'<oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxx<mailto: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:
