1.redo log相关数据字典

• v$logfile:指明redo log组和成员的状态

SQL> select * from v$logfile;

GROUP#   STATUS TYPE MEMBER                                               IS_
---------- ------- ------- ---------------------------------------- ---
3                        ONLINE /u01/oracle/oradata/oracle/redo03.log   NO
2                        ONLINE /u01/oracle/oradata/oracle/redo02.log   NO
1                        ONLINE /u01/oracle/oradata/oracle/redo01.log   NO

• v$log：展示从控制文件获取的联机日志文件的信息

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ ------------ ------------------
1 1 46 52428800 512 1 YES INACTIVE 1813000 30-OCT-16 1816235 30-OCT-16
2 1 47 52428800 512 1 YES INACTIVE 1816235 30-OCT-16 1829325 30-OCT-16
3 1 48 52428800 512 1 NO CURRENT 1829325 30-OCT-16 2.8147E+14

• v$log_history：包含日志文件的历史信息。

SQL> select * from v$log_history;

RECID STAMP THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# RESETLOGS_CHANGE# RESETLOGS_TIME
---------- ---------- ---------- ---------- ------------- ------------------ ------------ ----------------- ------------------
1 916808395 1 1 995548 10-JUL-16 1034481 995548 10-JUL-16
2 916808400 1 2 1034481 10-JUL-16 1040284 995548 10-JUL-16
3 916808562 1 3 1040284 10-JUL-16 1051490 995548 10-JUL-16
4 916814857 1 4 1051490 10-JUL-16 1077946 995548 10-JUL-16
5 916852678 1 5 1077946 10-JUL-16 1107799 995548 10-JUL-16
6 916856238 1 6 1107799 10-JUL-16 1132272 995548 10-JUL-16
7 916862452 1 7 1132272 10-JUL-16 1148329 995548 10-JUL-16
8 916979803 1 8 1148329 10-JUL-16 1175517 995548 10-JUL-16
9 917028708 1 9 1175517 12-JUL-16 1204024 995548 10-JUL-16
10 917035691 1 10 1204024 12-JUL-16 1233525 995548 10-JUL-16

redo log解读