使用LogMiner的简单步骤
1 运行下面脚本:
conn /as sysdba
@$ORACLE_HOME/rdbms/admin/dbmslm.sql
@$ORACLE_HOME/rdbms/admin/dbmslmd.sql
@$ORACLE_HOME/rdbms/admin/dbmslms.sql
2 创建数据字典文件(data-dictionary)--Extracting the Dictionary to a Flat File
CONNECT /as sysdba
alter system set UTL_FILE_DIR ='/u01/oracle/oradata/' scope=spfile;
shutdown immediate
startup 重新启动数据库，使新加的参数生效，然后创建数据字典文件：
EXECUTE dbms_logmnr_d.build('dictionary.ora', '/u01/oracle/oradata/');
3 创建要分析的日志文件列表
EXECUTE dbms_logmnr.add_logfile('/opt/oracle/oradata/mydb/redo02.log', dbms_logmnr.new);
EXECUTE dbms_logmnr.add_logfile('/opt/oracle/oradata/mydb/redo01.log', dbms_logmnr.addfile);
EXECUTE dbms_logmnr.add_logfile('/opt/oracle/oradata/mydb/redo03.log', dbms_logmnr.addfile);
4 使用logminer进行日志分析
EXECUTE dbms_logmnr.start_logmnr( DictFileName=>'/u01/oracle/oradata/dictionary.ora');
5 查看某个对象的操作历史
select operation, count(*) from v$logmnr_contents where seg_name='TEST' group by operation;
conn /as sysdba
@$ORACLE_HOME/rdbms/admin/dbmslm.sql
@$ORACLE_HOME/rdbms/admin/dbmslmd.sql
@$ORACLE_HOME/rdbms/admin/dbmslms.sql
2 创建数据字典文件(data-dictionary)--Extracting the Dictionary to a Flat File
CONNECT /as sysdba
alter system set UTL_FILE_DIR ='/u01/oracle/oradata/' scope=spfile;
shutdown immediate
startup 重新启动数据库，使新加的参数生效，然后创建数据字典文件：
EXECUTE dbms_logmnr_d.build('dictionary.ora', '/u01/oracle/oradata/');
3 创建要分析的日志文件列表
EXECUTE dbms_logmnr.add_logfile('/opt/oracle/oradata/mydb/redo02.log', dbms_logmnr.new);
EXECUTE dbms_logmnr.add_logfile('/opt/oracle/oradata/mydb/redo01.log', dbms_logmnr.addfile);
EXECUTE dbms_logmnr.add_logfile('/opt/oracle/oradata/mydb/redo03.log', dbms_logmnr.addfile);
4 使用logminer进行日志分析
EXECUTE dbms_logmnr.start_logmnr( DictFileName=>'/u01/oracle/oradata/dictionary.ora');
5 查看某个对象的操作历史
select operation, count(*) from v$logmnr_contents where seg_name='TEST' group by operation;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10248702/viewspace-668004/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
nologging选项的学习与测试
请登录后发表评论
登录
全部评论
