Oracle log 状态说明
来源:互联网 发布:阿里云 mysql 编辑:程序博客网 时间:2024/06/05 07:04
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(文件不可访问);
([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。)
(表明在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错误,则该日志可以停留在该状态。)
(表明正在清除当前日志文件中的已关闭线程,如果切换时发生某些故障,如写入新日志标题时的I/O错误,则该日志可以停留在该状态。)
(表明例程恢复不再需要联机重做日志组,它可能已经归档也可能未归档。)
- Oracle log 状态说明
- Oracle Log Miner工具说明
- Oracle Dump Redo Log File 说明
- Oracle Dump Redo Log File 说明
- Oracle Dump Redo Log File 说明
- 关于Oracle SUPPLEMENTAL log 补充说明
- Oracle session active 和 inactive 状态 说明
- Oracle session active 和 inactive 状态 说明
- Oracle session active 和 inactive 状态 说明
- Oracle session active 和 inactive 状态 说明
- Oracle session active 和 inactive 状态 说明
- Oracle session active 和 inactive 状态 说明
- Oracle session active 和 inactive 状态 说明
- /var/log/ 常见log 说明
- oracle连接数问题相关,session状态说明
- Oracle Golden Gate 系列十四 -- 监控 GG 状态 说明
- Oracle EBS中工单状态更改的几点说明
- Oracle Golden Gate 系列十四 -- 监控 GG 状态 说明
- 为OpenStack制作CentOS镜像的一种方法
- WEB测试要点总结
- Linux exec函数族
- 基于 equals() 的 键值同步锁: generic key managed concurrent lock map
- mysql 触发器
- Oracle log 状态说明
- PHP中文URL编解码详细说明
- Thread和Runnable浅析
- Reverse Integer
- 01-C语言概述
- Android Studio常用设置项
- 笔记本连接Cisco: LEAP网络
- Aix使用nmon查看top进程占用的内存大小
- Spring3.2 MVC框架搭建