[[264441]]

概述

Oracle 的Online redo log 是為確保已經(jīng)提交的事務(wù)不會(huì)丟失而建立的一個(gè)機(jī)制。 因?yàn)檫@種健全的機(jī)制，才能讓我們在數(shù)據(jù)庫crash時(shí)，恢復(fù)數(shù)據(jù)，保證數(shù)據(jù)不丟失。下面介紹一下Redo log的六種狀態(tài)(鍛煉下大家英文能力)。

redo log六種狀態(tài)

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的狀態(tài)和具體文件

redo log一般用的比較多命令就上面兩條和對redo log調(diào)整方面的命令了，屬于必須掌握的內(nèi)容。