Re: RMAN or Hot Backup

From: jgar the jorrible <joel-garry_at_home.com>
Date: Fri, 27 Mar 2009 09:34:08 -0700 (PDT)
Message-ID: <08c16cfc-5059-477c-9744-797a41c24fb9_at_z8g2000prd.googlegroups.com>



On Mar 27, 8:01 am, John Schaeffer <ame..._at_iwc.net> wrote:
> On Mar 26, 9:30 pm, "Bob Jones" <em..._at_me.not> wrote:
>
> > "Mladen Gogala" <gogala.mla..._at_gmail.com> wrote in message
>
> >news:gqh502$q0h$2_at_solani.org...
>
> > > On Thu, 26 Mar 2009 17:24:28 -0500, Michael Austin wrote:
>
> > >> They are morons and should be relieved of their duties and COMPETENT
> > >> talent hired to replace them.
>
> > > I would disagree, and bitterly so. There are reasons for using hot
> > > backups, especially in this economy.
>
> > Hot backup and economy? That's ingenious.
>
> Well, I've used RMAN before, and I'm all for it.  There is so much it
> does and takes care of for you which a Hot Backup cannot.  But, these
> other nuts want to switch and I'm hoping to get a bunch of reasons why
> not to switch from all of you.......
>
> Thanks!

We might help more if you said their reasons to switch... you can see from this thread that this grates on the fundamentals of dba work.

Michael Austin wrote:

> EMC has the BCV (Business Continuity Volume) where they use HotBackup
> Mode to "clone" a database by breaking a mirror and importing it into
> another instance. Again, On a very busy system, once or twice/week they
> would end up with corrupt undo-segments causing ORA-600 errors pointing
> to those corrupt segments. Basically, if you continually do a
> "controlled" crash like this, you are lucky more often than not if it
> works...

Did this happen with an alter db backup surrounding the break? Yeesh. I've been wondering about what will happen putting the db into backup mode every 15 minutes, as one proposal coming down the pike implies. I need Swiss pikes to defend my db.

jg

--
_at_home.com is bogus.
http://en.wikipedia.org/wiki/Pike_(cipher)
Received on Fri Mar 27 2009 - 11:34:08 CDT

Original text of this message