v$log 、v$logfile

最新推荐文章于 2024-07-20 08:30:00 发布

oracleerp

最新推荐文章于 2024-07-20 08:30:00 发布

阅读量1.1k

点赞数

文章标签： sql

本文链接：https://blog.csdn.net/oracleerp/article/details/2743776

版权

SQL> col status format a8;
SQL> col group# format 999999;
SQL> select group#,members,sequence#,status,bytes,first_change#
2 from v$log where thread#=1;

GROUP#    MEMBERS SEQUENCE# STATUS        BYTES FIRST_CHANGE#
------- ---------- ---------- -------- ---------- -------------
      1          1         23 CURRENT    52428800       2019003
      2          1         21 INACTIVE   52428800       1931979
      3          1         22 INACTIVE   52428800       1974840

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE#
------- ---------- ---------- ---------- ---------- --- -------- -------------
FIRST_TIME
--------------
1 1 23 52428800 1 NO CURRENT 2019003
31-7月 -08

2 1 21 52428800 1 YES INACTIVE 1931979
28-7月 -08

3 1 22 52428800 1 YES INACTIVE 1974840
30-7月 -08
(group#：用于标识日志组的编号，SEQUENCE#：用于标识日志的序列号，member:标识每个日志组的日志成员个数，first_change#：标识日志组的起始SCN)

SQL> col member format a30;
SQL> select member,status from v$logfile where group#=1;

MEMBER STATUS
------------------------------ --------
F:/ORACLE/PRODUCT/10.2.0/ORADA
TA/ORCL/REDO01.LOG

SQL> select member,status from v$logfile where group#=2;

MEMBER STATUS
------------------------------ --------
F:/ORACLE/PRODUCT/10.2.0/ORADA STALE
TA/ORCL/REDO02.LOG

SQL> select * from v$logfile;

GROUP# STATUS   TYPE    MEMBER                         IS_
------- -------- ------- ------------------------------ ---
      3 STALE    ONLINE F:/ORACLE/PRODUCT/10.2.0/ORADA NO
                         TA/ORCL/REDO03.LOG

2 STALE ONLINE F:/ORACLE/PRODUCT/10.2.0/ORADA NO
TA/ORCL/REDO02.LOG

1 ONLINE F:/ORACLE/PRODUCT/10.2.0/ORADA NO
TA/ORCL/REDO01.LOG

SQL>

（status：用于标识日志成员的状态。stale：表示许久未用------日志组太大）