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

Home -> Community -> Usenet -> c.d.o.server -> Re: database could not be started

Re: database could not be started

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 11 Aug 2003 16:46:03 +0200
Message-ID: <bh8a7c$jat$1@news.fujitsu-siemens.com>

"quarkman" <quarkman_at_myrealbox.com> schrieb im Newsbeitrag news:oprtnqk2wfzkogxn_at_haydn...
> On Sat, 9 Aug 2003 12:39:31 -0500, Burton Peltier
> <burttemp1REMOVE_THIS_at_bellsouth.net> wrote:
>
> > "Anton Buijs" <remove_aammbuijs_at_xs4all.nl> wrote in message
> > news:3f3510b5$0$49108$e4fe514c_at_news.xs4all.nl...
>
> >
> > This is the main reason where you would need the REDO logs. I thought
> > that
> > was what I said? After re-reading my post, it IS what I said.
> >
> > Just to be clear... I did not mean to imply and I know you do NOT
recover
> > REDO logs when recovering from a hot backup. The entire context of the
> > OP
> > was a problem with a cold backup. All of the comments in my post were
> > about
> > cold backups ONLY.
> >
> > Hot backups are different, of course.
>
>
> The temperature of your backups makes no difference. You should never
> backup online redo logs, period. Archivelog or noarchivelog, hot or cold.
>
> The subtler point is that's it's fine to do cold backups, even in
> archivelog mode. Indeed, cold backups with archivelog mode is quite
> possibily the nicest combination of options available to the dba. But
> herein lies the source of possible confusion: I'm in archivelog mode, I
> take cold backups... is it therefore OK for me to backup my online redo
> logs? No it isn't, because I risk data loss at the time of restore.
But if one were in archivelog mode, why not simply do a logswitch, wait until the archiving has finished and that's it?

Lots of Greetings!
Volker Received on Mon Aug 11 2003 - 09:46:03 CDT

Original text of this message

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