欢迎您的到来!本空间用来记录日常工作心得和一些小经验.内容可能部分摘自您的辛苦创作,再次对您表示感谢.希望本空间能给您或者其他朋友一些帮助. PS:寻求福州ORACLE DBA工作,期待您的惠顾(kugooo@live.cn)

V$LOG.status与V$LOGFILE.status详解

上一篇 / 下一篇  2008-07-09 21:55:06 / 个人分类:ORACLE--备份恢复

V$LOG

V$LOGdisplays log file information from the control file.

ColumnDatatypeDescription
GROUP#NUMBERLog group number
THREAD#NUMBERLog thread number
SEQUENCE#NUMBERLog sequence number
BYTESNUMBERSize of the log (in bytes)
MEMBERSNUMBERNumber of members in the log group
ARCHIVEDVARCHAR2(3)Archive status (YESorNO)
STATUSVARCHAR2(16)Log status:
  • UNUSED- Online redo log has never been written to. This is the state of a redo log that was just added, or just after aRESETLOGS, when it is not the current redo log.

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

  • 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.

  • CLEARING- Log is being re-created as an empty log after anALTER DATABASE CLEAR LOGFILEstatement. After the log is cleared, the status changes toUNUSED.

  • 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.

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

FIRST_CHANGE#NUMBERLowest system change number (SCN) in the log
FIRST_TIMEDATETime of the first SCN in the log

V$LOGFILE

This view contains information about redo log files.

ColumnDatatypeDescription
GROUP#NUMBERRedo log group identifier number
STATUSVARCHAR2(7)Status of the log member:
  • INVALID- File is inaccessible

  • STALE- File's contents are incomplete

  • DELETED- File is no longer used

  • null- File is in use

TYPEVARCHAR2(7)Type of the logfile:
  • ONLINE

  • STANDBY

MEMBERVARCHAR2(513)Redo log member name
IS_RECOVERY_DEST_FILEVARCHAR2(3)Indicates whether the file was created in the flash recovery area (YES) or not (NO)

TAG: v$log v$logfile

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-10-14  
   1234
567891011
12131415161718
19202122232425
262728293031 

数据统计

  • 访问量: 787
  • 日志数: 17
  • 文件数: 1
  • 建立时间: 2007-12-25
  • 更新时间: 2008-09-03

RSS订阅

Open Toolbar