业务部门需求,要协助客户DBA查truncate操作历史执行情况。
首先确认数据库已开启enable_ddl_logging, 然后从alert中查找没有记录;
之前11g版本都是记录到alert日志中,客户使用的19c数据库,怀疑19c有些变化,于是通过查询MOS
- How to Enable and Monitor DDL Logging in 11g and 12c (Doc ID 2254010.1)
可以看到相关说明:
- ENABLE_DDL_LOGGING is licensed under Oracle Change Management Pack and it is not offered as a standalone option.
- You can create an enhancement request, but it is already mentioned that it is part of Oracle Change Management Pack that needs to be purchased as a separate license.
- You can set the parameter to TRUE only if you purchased the license for the above mentioned package.
- In 11g we have this DDL Logging information under ADR HOME/alert directory only in XML format and Text Format information will be recorded in alert_
.log file - In 12c we have this DDL Logging information under ADR HOME/log/ddl_
.log ( Text Format ) and ADR HOME/log/ddl/log.xml ( XML format ).
果然12c以后就改变了ddl的记录位置到ADR HOME/log/ddl_<SID>.log
,顺利找到后即可协助业务排查。