alert log rotation on Windows
715773Aug 28 2009 — edited Aug 28 2009I'm trying to put something into place to 'rotate' my alert logs for 10.2.0.1.0 instances running on Windows. My understanding was that if I renamed the alert log, once Oracle needs to write to the log, it will create it again, so I've renamed a log file, then switched logfiles, caused check points, even run :-
execute sys.dbms_system.ksdwrt(2,to_char(sysdate)|| ' -- ');
But no alert log has appeared, does any one have any ideas as to how I can rotate the alert log on Windows such that the alert_<SID>.log file gets recreated ?.