Re: ORACLE Backups

John Morgan <John_Morgan_at_OIT.PeachNet.EDU> writes:

> Jim Gehl,
> gehl_at_eclipse.sheridanc.on.ca writes:
> >I am automating a backup script in ORACLE 6.0 to shutdown the database
 and
> >then backup all *.dbf files and am wondering if anybody has a csh script
 to
> >check for users on a database and kill the processes that are attached
 before
> >the shutdown.
> >

 .
>
> You could go into SQLDBA and do a shutdown immediate...that would
> effectively kick them off!

 No it won't. That will disable any new connections to the database. Any already existing connections are sitll there and sqldba will wait until all are disconnected before shutting down the database.

 What you want to do is a shutdown abort. That WILL abort any and all current sessions.

--
Name : Trevor Paquette       | Alberta Energy Company   |  _\___ Fahrvergnuegen
Email: tpaquette_at_ita.lgc.com | Calgary, Alberta, Canada | /     \____
Visitor from CyberSpace      | (403) 266-8400           |/ G60       \
Renegade of Virtual Reality  | #include <disclaimer.h>  |\-O------O--/