Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: rman backups
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-lReceived on Wed Nov 08 2006 - 04:59:40 CST
![]() |
![]() |