Oracle 11g LogMiner解析redo日志(5)

日期：2020-06-02 栏目：程序人生浏览：次

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
7900 JAMES CLERK 7698 1981-12-03 00:00:00 0 30
7902 FORD ANALYST 7566 1981-12-03 00:00:00 0 20
7934 MILLER CLERK 7782 1982-01-23 00:00:00 0 10

14 rows selected.

SQL>
SQL>
SQL> update xxx set job=sal;

14 rows updated.

SQL> commit;

Commit complete.

SQL> alter system switch logfile;

System altered.

SQL>

8.8、查看数据库当前归档信息

SQL> select GROUP#,THREAD#,SEQUENCE#,ARCHIVED,MEMBERS,status from v$log;

GROUP# THREAD# SEQUENCE# ARC MEMBERS STATUS
---------- ---------- ---------- --- ---------- ----------------
1 1 154 YES 1 INACTIVE
2 1 156 NO 1 CURRENT
3 1 155 YES 1 ACTIVE

SQL> alter system switch logfile;

System altered.

SQL> select GROUP#,THREAD#,SEQUENCE#,ARCHIVED,MEMBERS,status from v$log;

GROUP# THREAD# SEQUENCE# ARC MEMBERS STATUS
---------- ---------- ---------- --- ---------- ----------------
1 1 157 NO 1 CURRENT
2 1 156 YES 1 ACTIVE
3 1 155 YES 1 ACTIVE

SQL>

8.9、添加要分析的归档文件

SQL> execute dbms_logmnr.add_logfile('/u01/app/oracle/flash_recovery_area/OR11G/archivelog/2018_09_20/o1_mf_1_153_ft6k0418_.arc',DBMS_LOGMNR.new );