小弟是菜鸟,提个简单的问题,大家别BS我啊 oracle数据库中能够查看对数据库进行插入、删除、更新记录的日志文件的具体路径在哪? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这个问题不菜你可以尝试用logminer工具分析日志获取需要的信息,附一个logminer使用的例子:SQL> @$ORACLE_HOME/rdbms/admin/dbmslm.sql;Package created.Grant succeeded.SQL> @$ORACLE_HOME/rdbms/admin/dbmslmd.sql;Package created.SQL> alter system set utl_file_dir = '/export/home/oracle/oradata/orcl/logs' scope = spfile;System altered.SQL> shutdown;Database closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 629145600 bytesFixed Size 1281792 bytesVariable Size 490733824 bytesDatabase Buffers 134217728 bytesRedo Buffers 2912256 bytesDatabase mounted.Database opened.SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIV STATUS FIRST_CHANGE# FIRST_TIME---------- ---------- ---------- ---------- ---------- ------ -------------------------------- ------------- ------------ 1 1 938 52428800 1 NO INACTIVE 17445492 30-NOV-08 2 1 939 52428800 1 NO INACTIVE 17494420 01-DEC-08 3 1 940 52428800 1 NO CURRENT 17508573 01-DEC-08SQL> exec dbms_logmnr.add_logfile('/export/home/oracle/oradata/orcl/redo03.log', dbms_logmnr.new);PL/SQL procedure successfully completed.SQL> exec dbms_logmnr.start_logmnr(DictFileName=>'/export/home/oracle/oradata/orcl/logs/testlogmnr.ora');PL/SQL procedure successfully completed.SQL> select count(*) from V$LOGMNR_CONTENTS; COUNT(*)---------- 5363SQL> exec dbms_logmnr.end_logmnr;PL/SQL procedure successfully completed. SELECT * FROM V$LOGFILE; 我查出来的TXT文档为什么是乱码?? 用Oracle Log miner 打开看看 @$ORACLE_HOME/rdbms/admin/dbmslm.sql原来 这里面的testlogmnr.ora那句是什么,我环境上找不到类似文件啊。 怎么查每一项由那些叶子项组成? 帮我看看这个执行计划 oracle学习新手,求几条sql的标准答案对照~~~(书本上找不到答案很急人啊~~)100分求~~ oci 执行sql问题。 oracle9i模糊查询中怎么不识别'_' 问一个菜鸟级问题,如何将AB表中不同之处删除??在线等解答! 求一个sql 请教unix连oracle(9.0.2) 在线等待---服务器端与client端可以装在同一台机器上吗? oracle sql developer 我关闭连接后就再也显示不出来了 怎样建立database links 在不同的服务器之间 数据库中 怎样抓取sql?
附一个logminer使用的例子:
SQL> @$ORACLE_HOME/rdbms/admin/dbmslm.sql;Package created.
Grant succeeded.SQL> @$ORACLE_HOME/rdbms/admin/dbmslmd.sql;Package created.SQL> alter system set utl_file_dir = '/export/home/oracle/oradata/orcl/logs' scope = spfile;System altered.SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.Total System Global Area 629145600 bytes
Fixed Size 1281792 bytes
Variable Size 490733824 bytes
Database Buffers 134217728 bytes
Redo Buffers 2912256 bytes
Database mounted.
Database opened.SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIV STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ------ -------------------------------- ------------- ------------
1 1 938 52428800 1 NO INACTIVE 17445492 30-NOV-08
2 1 939 52428800 1 NO INACTIVE 17494420 01-DEC-08
3 1 940 52428800 1 NO CURRENT 17508573 01-DEC-08SQL> exec dbms_logmnr.add_logfile('/export/home/oracle/oradata/orcl/redo03.log', dbms_logmnr.new);PL/SQL procedure successfully completed.SQL> exec dbms_logmnr.start_logmnr(DictFileName=>'/export/home/oracle/oradata/orcl/logs/testlogmnr.ora');PL/SQL procedure successfully completed.SQL> select count(*) from V$LOGMNR_CONTENTS; COUNT(*)
----------
5363SQL> exec dbms_logmnr.end_logmnr;PL/SQL procedure successfully completed.
我查出来的TXT文档为什么是乱码??
原来
这里面的testlogmnr.ora那句是什么,我环境上找不到类似文件啊。