REDO LOG MEMBER STATUS 和 REDO LOG GROUP STATUS
来源:互联网 发布:知乎 lse mim 编辑:程序博客网 时间:2024/05/22 13:52
V$LOG 中列出的是REDO LOG GROUP STATUS
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 might or might not be archived.
V$LOGFILE 中列出的是REDO LOG MEMBER STATUS
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
- REDO LOG MEMBER STATUS 和 REDO LOG GROUP STATUS
- 添加Redo log Member/Group
- 删除redo log group or member
- v$log中status说明及redo log大小修改
- redo 和 undo log
- redo log
- Redo log
- Redo Log
- redo log
- redo log
- dataguard 修改redo log 和standby redo log
- 关于Dataguard Online redo log 和 Standby redo log
- redo log和undo log的区别
- MySQL之Undo Log和Redo Log
- QUESTION 169 A database has three online redo log groups with one member each. A redo log member wit
- 理解redo(4)redo log buffer和LGWR
- 在备库重建online redo和standby redo log
- binlog,undo log,redo log
- 团结就是力量
- 努力编程与编程高手之探索1
- LCD flicking issue - close
- Excel中的下拉表的操作
- 快要完工了,在黎明前的黑暗中静静等待
- REDO LOG MEMBER STATUS 和 REDO LOG GROUP STATUS
- 冒个泡泡。HK求职经验分享
- ASP Framework (二) 数据库操作DB类
- 读书笔记之《把时间当朋友》-----(二)
- display CMOS time
- 一个DLL回调应用程序函数的示例。
- 如何在VS2008中调用SQL存储过程?
- IE中使用Google Chrome Frame运行HTML 5
- 随机产生一个字符串