Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Alert Log Batch

Re: Alert Log Batch

From: Imprecise <f_puhan_at_precise.com>
Date: Thu, 20 Jun 2002 09:40:59 -0400
Message-ID: <f_puhan-8D6DA2.09405920062002@vienna7.his.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US