日志挖掘详细操作.docVIP

日志挖掘详细操作 日志挖掘详细操作 ——对redo log 进行挖掘，找出在某个时间点所作的DDL 或DML 操作（包括：时间点、datablock scn 、sql语句） 1）对DML 分析 SQL select * from scott.tb01; ID ---------- 1 2 3 3 rows selected. SQL delete from scott.tb01; 3 rows deleted. SQL commit; Commit complete. SQL insert into scott.tb01 values(111); 1 row created. SQL insert into scott.tb01 values(222); 1 row created. SQL insert into scott.tb01 values(333); 1 row created. SQL commit; Commit complete. SQL select * from scott.tb01; ID ---------- 111 222 333 3 rows selected. ——查看当前日志组 SQL select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME ---------- ---------- ---------- ---------- ---------- --------- ---------- ------------- ------------------- 1 1 1 104857600 3 YES INACTIVE 846224 2012-03-22 15:46:28 4 1 0 104857600 3 YES UNUSED 0 3 1 3 104857600 3 NO CURRENT 847894 2012-03-22 16:30:10 2 1 2 104857600 3 YES INACTIVE 846225 2012-03-22 15:47:06 SQL alter system archive log current;——使当前日志组归档 System altered. SQL select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME ---------- ---------- ---------- ---------- ---------- --------- ---------- ------------- ------------------- 1 1 5 104857600 3 NO CURRENT 849696 2012-03-22 17:36:01 4 1 4 104857600 3 YES ACTIVE 849665 2012-03-22 17:34:34 3 1 3 104857600 3 YES ACTIVE 847894 2012-03-22 16:30:10 2 1 2 104857600 3 YES INACTIVE