Message-Id: <10714.124844@fatcity.com> From: "Rachel Carmichael" Date: Mon, 18 Dec 2000 16:28:40 -0000 Subject: Re: Starting and stopping listener -fears?? Tapiwa, No the listener won't crash -- once it makes a connection for a user, it is not involved in the session anymore. Starting and stopping it won't cause problems. What you *should* worry about are the changes that users can make during your export. That and the fact that if you lose a single datafile, you will have to recreate your entire database, and won't be able to recover to the point at which you had a problem, but only to the time of the export. Having said that, if you (and your users) don't care about recovery to a point in time (say if you have an application where very few changes are made) then the export is (sort of) a sufficient backup. But having lived with only an export as my backup, I strongly urge you to do either a cold backup (if you can shut the database down) or a hot backup (if you can't) in addition to the export. Rachel >From: "Zhou, Tapiwanashe" >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >Subject: Starting and stopping listener -fears?? >Date: Mon, 18 Dec 2000 06:25:20 -0800 > >Hie list, > >I use export for my back ups. I want to prevent users from connecting to >Oracle while backup is proceeding. I have in mind "stopping Oracle >listener" >before backup and "starting it" afterwards using >lsnrctrl stop and lsnrctrl start. > Now my fears are, since some users may be actively connected, if I use >this >won't listener crush (sic) and fail to re-start. > >Thanks in advance. > >Tapiwa > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Zhou, Tapiwanashe > INET: tzhou@border.co.zw > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com