Re: problem with dbshut/dbstart?

From: Ken Mizuta <kmizuta_at_jp.oracle.com>
Date: Mon, 01 Feb 1999 15:13:36 +0900
Message-ID: <36B54610.23F5BEB1@jp.oracle.com>

Bruce,

Shutdown does not corrput your database. In fact, if you try to shutdown the database without the immediate, it means that it WAITS for all users to log off. So, as long as the users do not log off, then the database is still running. (If you shutdown the Sequent box in this state, then you might corrupt the database, because the database may still be waiting for users to log off and may not have had the chance to shutdown. Shutdown immediate, on the other hand, does not wait for users to log off and actually forces the users off the database, then does a graceful shutdown of the database. Shutdown abort just drops the database (using abort may corrupt the database).

If you are using dbshut in a script which is automatically run when the Sequent box is shutdown, then you should make sure that the database is truly shutdown before it continues.. i.e., don't use "&" to run dbshut in the background. Wait for dbshut to return before continuing shutdown of the Sequent box.

Ken

Bruce wrote:

> Newbie to Oracle
> Running Oracle 7.2.2.3 (but don't think that's important) on Sequent box
> with Dynix/ptx, shut down of database tends to corrupt it. Looking at the
> dbshut script I see that it uses the command shutdown without the
> "immediate" which says to me that if there's someone (or app) logged in
> then the database will not shutdown, and will subsequently crash. It seems
> to me that the script should use shutdown immediate, can anyone
> support/refute this? The same script appears in 7.2.2.3, 7.3.2 and 7.3.3
> tia
> Bruce
> --
> any opinions expressed are my own
> website: http://www.winzurf.co.nz
> work: bruce.spedding_at_dia.govt.nz
> play: bruce_at_winzurf.co.nz

--

---

  Kenichi Mizuta Oracle Corporation
  Development Manager Applications Division

All opinions expressed are my own and may not reflect the opinions of Oracle Corporation.

Received on Mon Feb 01 1999 - 00:13:36 CST