alert 告警日志

cd /oracle/app/oracle/diag/rdbms/orcl/orcl/trace
tail -10000 alert_orcl.log | awk ‘/ 2019$| 2020$|^2019-|2020-/{d=$0}
/^ORA-/{t=$0;print d," ",t}’

查看检查点未完成

cd /oracle/app/oracle/diag/rdbms/orcl/orcl/trace
tail -10000 alert_orcl.log | awk ‘/ 2019$| 2020$|^2019-|2020-/{d=$0}
/^Checkpoint not complete/{r=$0;print d," ",r }’