Re: DB Server Machine power outage. Recovery?

From: Erwin Dondorp <erwindon_at_wxs.nl>
Date: Thu, 09 Dec 1999 20:57:44 +0100
Message-ID: <385009B8.1CA071E0@wxs.nl>

Steve Parker wrote:
> When the machine running the Oracle server with mounted databases goes
> down due to power outage, how do you handle recovery? Should you delete
> the sga files from the <oracleHome>/dbs directory before restarting?

This is best done by using "SHUTDOWN ABORT". Even when the database is not even up, this will remove the lock files. Further recovery should not be nessecary most of the times. i.e. a simple STARTUP should do.
If you are unlucky the RECOVER command will do the job.

--
Erwin Dondorp
<http://www.dondorp.com/> Received on Thu Dec 09 1999 - 13:57:44 CST