On 8/11/06, Kevin Closson <kevinc@xxxxxxxxxxxxx> wrote:
>>>If you must bounce the db what is wrong with shutdown abort? You don't look as if this is for a cold backup so who cares that some recovery is required?
...there are 600+ connections. might it not be smart to switch logs a couple of times before the shutdown abort?
In a word yes. wise , sensible and even a least bad practice. I tend to do
alter system checkpoint; shutdown abort;
in DBA Created ^H^H^H^H^H unexpected emergency situations.
-- Niall Litchfield Oracle DBA http://www.orawin.info