Re: DBShut question

And just to clarify, shutdown normal is the default. If dbshut issues just a "shutdown" command, what you get is a shutdown normal. As Kenneth says, not normally the desired approach for an automated shutdown for backup.

Pete

Kenneth C Stahl wrote:

> Dominic Cribbin wrote:
> >
> > Hi,
> >
> > I have a question about the DBSHUT command.
> >
> > I am currently running an oracle database (version 8.1.5) on Sun Solaris box
> > using UNIX.
> >
> > I would like to know what type of Oracle shutdown is "dbshut", is it
> > "Normal", "Transactional" or "Abort".
> >
> > My reason for asking is that I want to write a script to take automated cold
> > DB backups and I am unsure whether the dbshut command will shutdown the
> > database in "normal" mode or will there be a chance that I could loose any
> > uncommitted transactions ???
> >
> > Regards
> >
> > Dominic
>
> As delivered, dbshut assumes a "shutdown normal". In the normal world this
> is virtually never correct. I recommend that everyone edit dbshut so that
> it performs a "shutdown immediate".

Received on Tue Dec 14 1999 - 10:30:28 CST