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: Calling dbshut for backup

Re: Calling dbshut for backup

From: Sam Jordan <sjo_at_spin.ch>
Date: Thu, 20 May 1999 13:01:01 +0000
Message-ID: <3744078D.73CD0E61@spin.ch>


Julio Negueruela wrote:
>
> Ermanno Giovanetto escribió:
> >
> > Which Oracle version are you using?
> >
> > I had the same problem on Oracle 8.0.5 64 bits on an HP-UX 11.00 machine,

I use 8.0.5. on Linux Suse6.

> > and I found an Oracle bulletin that said that the IMMEDIATE option has a bug
> > and sometimes hangs.
> > I noticed that some instances don't have this problem whilke other instances
> > on same machine do.
> >
> > So I use the ABORT option, then startup in restricted mode and finally
> > shutdown normal

Isn't there a potential of having consistency problems, if first shutting
down using abort?
>
> I know it depends on your work environment but may be shutdown
> transactional can help Sam Jordan.

What do you mean with shutdown transactional? I thought that normal, immediate and abort are the only options for the shutdown command? I got the hang-ups both for normal and immediate mode. The latter one basically should kick all logged users resp. rollback their transactions,
at least that's my current knowledge.

Anyway, if noone is logged in into the db, then the shutdown command does what it should.

bye
--
Sam Jordan Received on Thu May 20 1999 - 08:01:01 CDT

Original text of this message

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