Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: rman backups

Re: rman backups

From: goran bogdanovic <goran00_at_gmail.com>
Date: Wed, 8 Nov 2006 11:59:40 +0100
Message-ID: <6d0a3ba80611080259t6e6a4c55xf069415f9c9c35cb@mail.gmail.com>


On 11/8/06, Mark Brinsmead <pythianbrinsmead_at_gmail.com> wrote:
>
> To take Bob's comments one step farther...
>
> If your data is worth the trouble of backing up, archivelog mode is
> (almost) mandatory.
>
> Does your management understand that doing offline backups (without
> archivelogging -- after all, cold

I have seen such "managers"...it is sad that such people are managing production systems...I just wonder how they get to this position?

backups don't preclude archivelog mode) leaves you in a position where a
> serious system failure (maybe coupled with one bad tape cartridge) could
> cause you to lose several days' worth of data? Are they okay with that?

The incrementa cost of running in archivelog mode is (for most
> organizations) a nit compared to the risk of operating without it.
>
> On 11/7/06, Bob <orcl_at_comcast.net> wrote:
> >
> > Hi Brian, Im surprised no one has mentioned that backing up with rman
> > in no archive log mode will give you nothing more than an rman managed cold
> > backup.
> >
> > ...
> >
> > Maybe you "cant" run in ALMode (management reasons) but if your goal is
> > to "...become more intimate..." with rman- then archivelog mode is
> > mandatory. The good thing about using rman is that it manages (deletes
> > obsolete, applies recovery) of archive logs for you. Minimal manual
> > intervention is needed to manage, or apply archive logs
> >
> > ...
> >
>
> --
> Cheers,
> -- Mark Brinsmead
> Senior DBA,
> The Pythian Group
> http://www.pythian.com/blogs

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 08 2006 - 04:59:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US