详解Oracle数据库Redo log的六种状态

数据库 Oracle
Oracle 的Online redo log 是为确保已经提交的事务不会丢失而建立的一个机制。 因为这种健全的机制,才能让我们在数据库crash时,恢复数据,保证数据不丢失。下面介绍一下Redo log的六种状态(锻炼下大家英文能力)。

[[264441]]

概述

Oracle 的Online redo log 是为确保已经提交的事务不会丢失而建立的一个机制。 因为这种健全的机制,才能让我们在数据库crash时,恢复数据,保证数据不丢失。下面介绍一下Redo log的六种状态(锻炼下大家英文能力)。

 

详解Oracle数据库Redo log的六种状态

 

redo log六种状态

1、CURRENT

The online redo log is active, that is, needed for instance recovery, and it is the log to which the database is currently writing. The redo log can be open orclosed.

2、ACTIVE

The online redo log is active and required for instance recovery, but is not the log to which the database is currently writing. It may be in use for blockrecovery, and may or may not be archived.Once perform "alter system checkpoint",the log will be change inactive.

3、INACTIVE

The log is no longer needed for instance recovery. It may be in use for media recovery,and may or may not be archived.

4、UNUSED

The online redo log has never been written to.

5、CLEARING

The log is being re-created as an empty log after an ALTER DATABASECLEAR LOGFILE statement. After the log is cleared, then the status changes to UNUSED.

6、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 thenew log header. . .

The ALTER DATABASE CLEAR LOGFILE statement can fail with an I/O error due to media failure when it is not possible to:

Relocate the redo log file onto alternative media by re-creating it under the currently configured redo log filename

Reuse the currently configured log filename to re-create the redo log file because the name itself is invalid or unusable (for example, due to media failure)

查看Redo log的状态和具体文件

 

详解Oracle数据库Redo log的六种状态

 

 

详解Oracle数据库Redo log的六种状态

 

redo log一般用的比较多命令就上面两条和对redo log调整方面的命令了,属于必须掌握的内容。

责任编辑:武晓燕 来源: 今日头条
相关推荐

2011-01-12 21:26:49

2010-01-06 09:30:51

Oracle Redo

2011-03-24 17:21:42

Oracle数据库Redo故障

2011-05-26 09:36:07

Oracle数据库Redo故障

2011-03-08 08:59:01

SQL Server数数据移动

2011-07-28 16:39:03

MySQL数据库修改MySQL密码

2011-09-13 15:51:54

删除数据库重复行

2022-01-11 18:21:11

存储技术数据

2017-10-27 11:47:05

SQL数据库优化

2023-04-12 08:00:34

Dubbo分布式服务

2011-05-19 13:25:14

Oracle数据库

2023-11-23 13:17:39

MySQL​数据库

2010-04-14 15:14:11

Oracle数据库

2010-04-02 13:59:08

Oracle数据库

2011-03-31 14:53:13

数据中心节能

2010-04-01 11:32:33

Oracle repo

2011-03-29 10:47:49

ORACLE数据库

2009-03-25 18:11:57

监视镜像数据库

2011-08-18 15:49:21

Oracle厉行计划

2011-05-17 15:02:15

ORACLE数据库备份
点赞
收藏

51CTO技术栈公众号