Re: ORACLE Backups

From: Robert F Henry <bhenry_at_miller.cs.uwm.edu>
Date: 19 Sep 1994 03:00:46 GMT
Message-ID: <35iusuINN71r_at_uwm.edu>


In article <34lhok$cnd_at_nic.dot.state.mn.us> bill.pociengel_at_nic.state.mn.us writes:
>In <b36_9408080642_at_crystal.dircon.co.uk>, gordon_at_crystal.dircon.co.uk (Gordon Hollingworth) writes:
>>Trevor,
 

>>SHUTDOWN IMMEDIATE - Terminates all connections and performs and automatic
>>rollback on any uncommited transactions.

>>SHUTDOWN ABORT - Terminates everything and does *not* perform rollbacks etc.
>>This is what I call the PANIC option.
 

>i do this if the previous doesn't remove all of the sqlnet attachments.

If I have to resort to a shutdown abort I do a STARTUP and SHUTDOWN NORMAL. If SHUTDOWN IMMEDIATE fails something is usually wrong. If the OS is VMS I've seen a "Page File Quota violation: error in the log file.

>>Does anyone else have anything to add ???

Bob Received on Mon Sep 19 1994 - 05:00:46 CEST

Original text of this message