1、数据库版本:
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for 32-bit Windows: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
2、配置
SQL> show parameter log_checkpoints
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_checkpoints_to_alert boolean TRUE
初始值为FALSE,通过语句调整:alter system set log_checkpoints_to_alert = true;
3、执行alter system switch logfile(连续执行四次),后观察alert日志文件
第一次: