RE: Truncated Listener Log/backing up?
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <niall.litchfield@xxxxxxxxx>, <cemail_219@xxxxxxxxxxx>
- Date: Fri, 12 Jan 2007 08:48:03 -0500
Yes, set log_file command to work, it requires
ADMIN_RESTRICTIONS_LISTENER=OFF in the listener.ora file. (I believe
that is the default, but if it is ON you can't rename).
Example:
lsnrctl set log_file ${ORACLE_HOME}/network/log/listener_${DATE}.log
find ${ORACLE_HOME}/network/log -name "listener*.log" -mtime
+${NUMBER_KEEPDAYS} -exec ls -ltr {} \;
find ${ORACLE_HOME}/network/log -name "listener*.log" -mtime
+${NUMBER_KEEPDAYS} -exec rm {} \;
####################### Cleanup old log files
###########################################
find ${LOGGEDDIR} -name "cleanup_listener*.log" -mtime
+${NUMBER_KEEPDAYS} -exec ls -ltr {} \;
find ${LOGGEDDIR} -name "cleanup_listener*.log" -mtime
+${NUMBER_KEEPDAYS} -exec rm {} \;
Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904 727-2546
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Niall Litchfield
Sent: Thursday, January 11, 2007 10:39 AM
To: cemail_219@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Truncated Listener Log/backing up?
You'll need to change the current log from within lsnrctl using set
log_file <newname>, you can then maintain the old one as you feel like.
On 1/11/07, J. Dex <cemail_219@xxxxxxxxxxx> wrote:
Our listener log has grown too large and I want to back it up. It is my
understanding that it can't be truncated because it is an open file.
What
are other people doing to resolve this issue? This is on a W2K server
where the listener is password protected and security patches have been
applied. I want to add whatever type of process can be used into a
script.
_________________________________________________________________
Fixing up the home? Live Search can help
http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&loca
le=en-US&source=hmemailtaglinenov06&FORM=WLMTAG
--
//www.freelists.org/webpage/oracle-l
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
