Re: shutdown normal

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 5 Mar 2001 23:52:06 +0100
Message-ID: <ta860obel6q845@beta-news.demon.nl>

"John Roberts" <namaste3_at_home.com> wrote in message news:DAUo6.303630$j6.42403380_at_news1.rdc1.va.home.com...
> Hello Oracle gurus
>
> I'm trying to shut down my instance by connecting as internal and issuing
> the "shudown normal" command, however, the database never shuts down.
> Ultimately I'm doing this to take physical backups of all my data files,
> control files, etc. How long should a shutdown normal operation take in a
> small (< 500 MB) database? Also, is there a way to insure that all users
> are disconnected? In DBA studio the only users that i see still connected
> are system for several background processes.
>
> Any ideas?
>
> Thanks!
>
> - John
>
>

shutdown normal waits for all users to disconnect shutdown immediate disconnects them gracefully shutdown abort just crashes the instance. Replace normal by immediate, it's safe to do so. Issues like this are well documented.

Hth,

Sybrand Bakker, Oracle DBA

>
Received on Mon Mar 05 2001 - 16:52:06 CST