Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alert Log Batch
In article
<4d26ceb8b7c651026b3c9c929e9adc9a.69968_at_mygate.mailgate.org>,
"Jamal Atfeh" <atfeh_at_hotmail.com> wrote:
> I have Oracle databade 8.1.6 under NT4
>
> the alert log keeps growing
>
> is there any batch which can deduct the first 1000 lines from the alert
> log and save it under another name
Untested, but I've run much the same sort of thing.
Actually, it doesn't trim the alert log, it copies (renames) it, causing Oracle to generate a new one.
@echo off
rem * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * rem * rem * REMLOG.BAT rem * rem * To be run using the Windows NT 'at' scheduler rem * rem * i.e. AT 9:25 /EVERY:tu "C:\WINNT\remlog.bat" rem * rem * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
REM Substitute the REAL path below...
SET LOG_DIR=<path_to_alert_log>
CD %LOG_DIR% REM Replace <sid> with the correct value
IF EXIST <sid>ALRT.OLD del <sid>ALRT.OLD
REN <sid>ALRT.LOG <sid>ALRT.OLD
REM * EOF
-- The underscore character does not belong in my address. You know the drill... *** Anyone sufficiently smart enough to configure and use USEnet for research should be smart enough to Read The Freakin' Documentation!Received on Thu Jun 20 2002 - 08:40:59 CDT