V$LOGFILE.STATUS和$LOG.STATUS

1.V$LOGFILE.STATUS 

  ([url]http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1152.htm#sthref3730[/url])

  類型：VARCHAR2(7)

  Status of the log member:

  (1).INVALID - File is inaccessible(檔案不可通路);

  (2).STALE - File's contents are incomplete(表明該檔案内容不完全，例如正在添加一個日志檔案成員)

         If the redo log file group member has never been used, either due to a new redo log file group or a repaired member, the value of STATUS is STALE until the log file member is used to record redo information.

  (3).DELETED - File is no longer used(該檔案已不再使用);

  (4).null - File is in use(檔案正在使用中).

2.V$LOG.STATUS 

 ([url]http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1150.htm#sthref3726[/url])

  類型：VARCHAR2(16)

  Log status:

  (1).UNUSED - Online redo log has never been written to. This is the state of a redo log that was just added, or just after a RESETLOGS, when it is not the current redo log.

         (表明從未對聯機重做日志組進行寫入，這種狀态的日志檔案要麼而是剛增加的，要麼是當日志不是current redo log時RESETLOGS操作後的狀态)

  (2).CURRENT - Current redo log. This implies that the redo log is active. The redo log could be open or closed.

         (目前的聯機重做日志組，這意味着該聯機重做日志組是活動的)

  (3).ACTIVE - Log is active but is not the current log. It is needed for crash recovery. It may be in use for block recovery. It may or may not be archived.

         (聯機重做日志組是活動的，但是并非目前聯機重做日志組，崩潰恢複需要該狀态的日志，它可能用于塊恢複，它可能已經歸檔也可能未歸檔)

  (4).CLEARING - Log is being re-created as an empty log after an ALTER DATABASE CLEAR LOGFILE statement. After the log is cleared, the status changes to UNUSED.

         (表明在ALTER DATABASE CLEAR LOGFILE 指令後正在将該日志重建為一個空日志，日志清除後其狀态更改為UNUSED。)

  (5).CLEARING_CURRENT - Current log is being cleared of a closed thread. The log can stay in this status if there is some failure in the switch such as an I/O error writing the new log header.

       （表明正在清除目前日志檔案中的已關閉線程，如果切換時發生某些故障，如寫入新日志标題時的I/O錯誤，則該日志可以停留在該狀态。）

  (6).INACTIVE - Log is no longer needed for instance recovery. It may be in use for media recovery. It might or might not be archived.

        （表明例程恢複不再需要聯機重做日志組，它可能已經歸檔也可能未歸檔。）