解决Oracle Golden Gate ggserr.log文件过大的问题

ogg版本 12.3 Windows_x64

diretc\logging\ogg-ggserr.xml 为ggserr.log的配置文件

发现修改diretc\logging\ogg-ggserr.xml 中很多参数没有效果  参考 log4j配置

<appender name="ggserr.Standard" class="RollingFileAppender">
    <!-- 修改日志文件名 -->
    <param name="File"             value="ggserr.log"/>
    <param name="MaxFileSize"      value="10MB"/>
    <param name="MaxBackupIndex"   value="9"/>
    <param name="BufferedIO"       value="false"/>
    <param name="Append"           value="true"/>
    <layout class="PatternLayout">
      <param name="Pattern" value="%d{%Y-%m-%dT%H:%M:%S%z}  %m%n"/>
    </layout>
  </appender>

只有修改name参数， 重启mgr能产生新的日志文件

修改后的ogg-ggserr.xml

<?xml version="1.0"?>  															
<configuration>        																
 <appender name="ggserr.Standard" class="RollingFileAppender">  							
   <param name="File"             value="dirlog/ggserr_2019_05_06.log"/>    
   <param name="MaxFileSize"      value="100MB"/> 					
   <param name="MaxBackupIndex"   value="9"/>						
   <param name="BufferedIO"       value="false"/>					
   <param name="Append"           value="true"/>					
 	<layout class="PatternLayout">									
  		<param name="Pattern" value="%d{%Y-%m-%dT%H:%M:%S%z}  %m%n"/>			
 	</layout>																
  </appender>																
 <logger          name="ggserr.log" additivity="false">						
  	<appender-ref  name="ggserr.Standard"/>										
  	<level        value="info"/>												
 </logger>								
</configuration>      

 

用计划任务执行bat每天生成一个不同的日志文件名来控制日志文件大小

switch_ogg_log.bat

rem 用于每天生成日志文件
@echo off

rem 关闭OGG 管理进程
rem dirlog目录需要手动创建
cmd /c d:/oracle/ggdir/ggsci paramfile D:\Oracle\ggdir\dirlog\command\stopMgr.txt

rem 修改日志文件名
echo ^<?xml version=^"1.0^"?^>  															>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo ^<configuration^>        																>>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo  ^<appender name=^"ggserr.Standard^" class=^"RollingFileAppender^"^>  							>>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo    ^<param name=^"File^"             value=^"dirlog/ggserr_%Date:~0,4%_%Date:~5,2%_%Date:~8,2%.log^"/^>    >>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo    ^<param name=^"MaxFileSize^"      value=^"100MB^"/^> 					>>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo    ^<param name=^"MaxBackupIndex^"   value=^"9^"/^>						>>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo    ^<param name=^"BufferedIO^"       value=^"false^"/^>					>>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo    ^<param name=^"Append^"           value=^"true^"/^>					>>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo  	^<layout class=^"PatternLayout^"^>									>>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo   		^<param name=^"Pattern^" value=^"%%d{%%Y-%%m-%%dT%%H:%%M:%%S%%z}  %%m%%n^"/^>			>>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo  	^</layout^>																>>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo   ^</appender^>																>>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo  ^<logger          name=^"ggserr.log^" additivity=^"false^"^>						>>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo   	^<appender-ref  name=^"ggserr.Standard^"/^>										>>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo   	^<level        value=^"info^"/^>												>>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo  ^</logger^>								>>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml
echo ^</configuration^>      >>D:\Oracle\ggdir\diretc\logging\ogg-ggserr.xml

rem 重启管理进程
cmd /c d:/oracle/ggdir/ggsci paramfile D:\Oracle\ggdir\dirlog\command\startMgr.txt

rem 删除过期日志
FORFILES  /D -7 /C "cmd /c del /q @file"


exit

stopMgr.txt

stop mgr !
exit

startMgr.ext

start mgr