Re: Question about RMAN Datafile + Archivelog Backups

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: mwf@xxxxxxxx
  • Date: Wed, 2 Dec 2009 22:22:01 +0000

On Wed, Dec 2, 2009 at 9:54 PM, Mark W. Farnham <mwf@xxxxxxxx> wrote:

>  It’s also useful for using busnet or upsnet to “test recovery” at an old
> fashioned physical DR site.
>
Well RMAN backups can be used for that as well.

>  And I really don’t want to ever just have one backup copy of anything I
> really care about.
>

s/copy/method/ and I'd agree.


>  mwf
>
>
>  ------------------------------
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Robert Freeman
> *Sent:* Wednesday, December 02, 2009 3:34 PM
> *To:* Brandon.Allen@xxxxxxxxxxx; Goulet, Richard; Oracle-L@xxxxxxxxxxxxx
> *Subject:* Re: Question about RMAN Datafile + Archivelog Backups
>
>
>
> I've always thought that the archivelog backup should be the default
> condition with a switch to turn it off. Maybe it's a programitic constraint
> since the same command (backup database) is used for both ARCHIVELOG and
> NOARCHIVELOG mode backups.
>
>
> Robert G. Freeman
> Oracle ACE
> Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
> Author:
> Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY
> SOON!
> OCP: Oracle Database 11g Administrator Certified Professional Study Guide
> (Sybex)
> Oracle Database 11g New Features (Oracle Press)
> Oracle Database 10g New Features (Oracle Press)
> Other various titles
> Blog: http://robertgfreeman.blogspot.com
> Check out my new blog series on installing Oracle Database 11gR2 on Windows
> using VMWare!
>
>
>
>
>  ------------------------------
>
> *From:* "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
> *To:* "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>; "
> Oracle-L@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
> *Sent:* Wed, December 2, 2009 12:23:12 PM
> *Subject:* RE: Question about RMAN Datafile + Archivelog Backups
>
> Yes, I like my backups to be recoverable J  I was just pointing out the
> caveat that they’re not included if you just run “backup database”.  It
> seems to me that it would be a good idea to make the backup command include
> archivelogs by default and only have an option to exclude them if desired
> for some reason – maybe in 12x.
>
>
>
>
>
> *From:* Goulet, Richard [mailto:Richard.Goulet@xxxxxxxxxxx]
>
>
>
> True, don't you include the archive logs in the backup set??
>
>
>
>
>
>
>  ------------------------------
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>



-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: