| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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" <tzhou_at_border.co.zw>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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_at_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_at_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).
 |
 |