Re: Calling dbshut for backup

An alternative is to kill all oracle sessions in os level before shutdown the db.

Joe

Sam Jordan wrote:

> 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 Sun May 23 1999 - 09:29:02 CDT