Oracle Checkpoint
Overview of Checkpoints
A is a crucial mechanism in consistent database shutdowns, instance recovery, and Oracle Database operation generally. The term checkpoint has the following related meanings:
-
A data structure that indicates the checkpoint position, which is the in the redo stream where instance recovery must begin
The checkpoint position is determined by the oldest dirty buffer in the database buffer cache. The checkpoint position acts as a pointer to the redo stream and is stored in the control file and in each data file header.
-
The writing of modified database buffers in the to disk
Purpose of Checkpoints
Oracle Database uses checkpoints to achieve the following goals:
-
Reduce the time required for recovery in case of an instance or media failure
-
Ensure that dirty buffers in the buffer cache are written to disk regularly
-
Ensure that all committed data is written to disk during a consistent shutdown
When Oracle Database Initiates Checkpoints
The checkpoint process (CKPT) is responsible for writing checkpoints to the data file headers and control file. Checkpoints occur in a variety of situations. For example, Oracle Database uses the following types of checkpoints:
-
Thread checkpoints
The database writes to disk all buffers modified by redo in a specific thread before a certain target. The set of thread checkpoints on all instances in a database is a database checkpoint. Thread checkpoints occur in the following situations:
-
Consistent database shutdown
-
ALTER SYSTEM CHECKPOINT statement
-
Online redo log switch
-
ALTER DATABASE BEGIN BACKUP statement
-
-
Tablespace and data file checkpoints
The database writes to disk all buffers modified by redo before a specific target. A tablespace checkpoint is a set of data file checkpoints, one for each data file in the tablespace. These checkpoints occur in a variety of situations, including making a tablespace read-only or taking it offline normal, shrinking a data file, or executing ALTER TABLESPACE BEGIN BACKUP.
-
Incremental checkpoints
An incremental checkpoint is a type of thread checkpoint partly intended to avoid writing large numbers of blocks at online redo log switches. DBWn checks at least every three seconds to determine whether it has work to do. When DBWn writes dirty buffers, it advances the checkpoint position, causing CKPT to write the checkpoint position to the control file, but not to the data file headers.
Other types of checkpoints include instance and media recovery checkpoints and checkpoints when schema objects are dropped or truncated.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29119536/viewspace-1485263/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle checkpoint詳解Oracle
- oracle checkpoint檢查點Oracle
- Oracle checkpoint詳解一Oracle
- Oracle checkpoint詳解二Oracle
- Oracle中的checkpoint程式Oracle
- Oracle log_checkpoint_interval和Oracle
- Oracle中checkpoint存在的意義Oracle
- [zt]Oracle檢查點ckpt (checkpoint)Oracle
- oracle checkpoint檢查點系列一Oracle
- 【Oracle-資料庫概念】-Oracle checkpoint詳解Oracle資料庫
- oracle checkpoint 觸發的9個條件Oracle
- oracle實驗記錄(恢復-checkpoint cnt)Oracle
- oracle結構梳理----checkpoint——啟動與關閉Oracle
- mysql checkpointMySql
- Postgres Checkpoint
- ORACLE資料庫檢視ACQ(ACTIVE CHECKPOINT QUEUE)資訊Oracle資料庫
- 【CHECKPOINT】Oracle檢查點優化與故障處理Oracle優化
- 關於Oracle GoldenGate中Extract的checkpoint的理解OracleGo
- 【TUNE_ORACLE】Oracle檢查點(一)檢查點(Checkpoint)概念介紹Oracle
- Postgresql 的CheckpointSQL
- PostgreSQL checkpoint原理SQL
- Checkpoint總結
- checkpoint 優化優化
- Oracle SCN機制解析 (SCN, checkpoint檢查點) - finalOracle
- oracle mount_open_checkpoint(scn)啟動驗證測試Oracle
- PostgreSQL備機checkpointSQL
- checkpoint詳解(zt)
- 初學checkpoint and scn
- Incremental checkpoint up to RBAREM
- SCN, Checkpoint 與 oracle資料庫恢復的關係(final)Oracle資料庫
- oracle內部原理_如何修改block資料塊大體流程_checkpointOracleBloC
- ckpt(checkpoint)機制研究
- checkpoint詳解(部分轉)
- Checkpoint和SCN的解析
- Oracle 18C,19C standby CHECKPOINT_CHANGE# 不更新問題Oracle
- oracle switch logfile日誌切換及alter system checkpoint作了什麼Oracle
- PostgreSQL xlog格式之checkpointSQL
- MySQL checkpoint執行時機MySql