RE: Question about RMAN Datafile + Archivelog Backups
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>, "Oracle-L@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 Dec 2009 12:06:29 -0500
Chris,
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Taylor, Chris David
Sent: Wednesday, December 02, 2009 11:56 AM
To: '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:
