日志组状态：inactive/active/current

最新推荐文章于 2024-03-27 09:27:07 发布

翻译最新推荐文章于 2024-03-27 09:27:07 发布 · 2.3k 阅读

文章标签：

#database #crash #file

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

本文介绍了Oracle数据库中redo日志文件的状态分类，包括当前（current）、活动（active）和非活动（inactive）状态，并解释了每种状态下日志的作用及归档模式对日志重用的影响。

日志组状态：inactive/active/current

Active (Current) and Inactive Redo Log Files

Oracle Database uses only one redo log files at a time to store redo records written from the redo log buffer. The redo log file that LGWR is actively writing to is called the current redo log file.

Redo log files that are required for instance recovery are called active redo log files.

--这句话的意思应该是：在上一个checkpoint event 之后到instance crash之间并且没有写入数据文件的这些redolog，这些redolog是instance crash 需要的，其状态为 active

Redo log files that are no longer required for instance recovery are called inactive redo log files.

If you have enabled archiving (the database is in ARCHIVELOG mode), then the database cannot reuse or overwrite an active online log file until one of the archiver background processes (ARCn ) has archived its contents. If archiving is disabled (the database is in NOARCHIVELOG mode), then when the last redo log file is full, LGWR continues by overwriting the first available active file.