tech_memo / ORACLE / REDO_Log

tech_memo/ORACLE

REDOログファイル一覧表示 †

• クエリ

  set pages 10000
  set lines 120
  COL MEMBER FORMAT A30
  COL STATUS FORMAT A10
  
  SELECT LOG.THREAD#,LOG.GROUP#,
     LOG.BYTES/1024/1024 AS MBYTES,
     LOG.STATUS,LOG.ARCHIVED,LOGFILE.MEMBER 
  FROM   V$LOG LOG,V$LOGFILE LOGFILE
  WHERE LOG.GROUP# = LOGFILE.GROUP#
  ORDER BY THREAD#,GROUP#;

• 結果

  THREAD#     GROUP#     MBYTES STATUS     MEMBER
  ---------- ---------- ---------- ---------- ------------------------------
          1          1       1024 INACTIVE   +DATA/redo/redo111.dbf
          1          1       1024 INACTIVE   +LOG/redo/redo112.dbf