摘要：
查看数据库SQL˃colmemberformata50SQL˃selectgroup#，status，type，memberfromv$logfile；中的日志文件信息；组#状态成员----------------------------------------------------------------------------3在线：APPMARYHU
查看数据库中log file信息
SQL> col member format a50 SQL> select group#,status,type,member from v$logfile; GROUP# STATUS TYPE MEMBER ---------- ------- ------- -------------------------------------------------- 3 ONLINE D:APPMARYHUORADATAARCERZHANGDBREDO03.LOG 2 ONLINE D:APPMARYHUORADATAARCERZHANGDBREDO02.LOG 1 ONLINE D:APPMARYHUORADATAARCERZHANGDBREDO01.LOG SQL> select group#,bytes,members from v$log; GROUP# BYTES MEMBERS ---------- ---------- ---------- 1 52428800 1 2 52428800 1 3 52428800 1
查看日志组文件信息
SQL> set linesize 200 SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------- ------------ ------------------- 1 1 45 52428800 512 2 YES INACTIVE 1545714 2013/07/04 10:05:02 1570213 2013/07/04 10:39:57 2 1 46 52428800 512 2 NO CURRENT 1570213 2013/07/04 10:39:57 2.8147E+14 3 2 39 52428800 512 2 NO CURRENT 1579090 2013/07/04 12:50:24 2.8147E+14 2013/07/04 12:50:24 4 2 38 52428800 512 2 YES INACTIVE 1570199 2013/07/04 10:39:54 1570205 2013/07/04 10:39:54 SQL> select 52428800/1024/1024 m from dual; M ---------- 50