Re: ORACLE Backups

In article 94Aug4140950_at_elvis.ita.lgc.com, tpaquette_at_ita.lgc.com (Trevor Paquette) writes:
> 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--/

Once you do the "shutdown abort", you should bring the database back up again and do a regular shutdown. Then do your file backups.

Beverly  

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
+                                    +                             +
+  Beverly Cather Zygmunt            +  Phone: (615) 574-1007      +
+  Oak Ridge National Laboratory     +  email: zygmuntbc_at_ornl.gov  +
+  Building 4500N, MS 6274           +         bzy_at_ornl.gov        +
+  Oak Ridge, TN 37831-6274          +                             +
+                                    +                             +
+                                    +                             +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+                                                                  +
+  "If you torture your data long enough, they will tell you what  +
+  you want to hear." -- James L. Mills                            +
+                                                                  +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++