Chinaunix首页 | 论坛 | 博客
  • 博客访问: 15809
  • 博文数量: 8
  • 博客积分: 185
  • 博客等级: 入伍新兵
  • 技术积分: 90
  • 用 户 组: 普通用户
  • 注册时间: 2011-10-10 16:22
文章分类

全部博文(8)

文章存档

2011年(8)

我的朋友

分类: Oracle

2011-11-02 14:52:52

Column Datatype Description
GROUP# NUMBER Log group number
THREAD# NUMBER Log thread number
SEQUENCE# NUMBER Log sequence number
BYTES NUMBER Size of the log (in bytes)
BLOCKSIZE NUMBER Block size of the logfile (512 or 4096)
MEMBERS NUMBER Number of members in the log group
ARCHIVED VARCHAR2(3) Archive status (YES) or (NO)
STATUS VARCHAR2(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 a RESETLOGS, 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 an ALTER DATABASE CLEAR LOGFILE statement. After the log is cleared, the status changes to UNUSED.

  • 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 may or may not be archived.

FIRST_CHANGE# NUMBER Lowest system change number (SCN) in the log
FIRST_TIME DATE Time of the first SCN in the log
阅读(223) | 评论(0) | 转发(0) |
0

上一篇:Install SLM7.1 need media SAP:SAPLUP:700:

下一篇:没有了

给主人留下些什么吧!~~