Redo Byte Address (RBA)
来源:互联网 发布:长安城知乎 编辑:程序博客网 时间:2024/05/22 04:53
http://www.ixora.com.au/notes/rba.htm
Redo Byte Address (RBA)
Recent entries in the redo thread of an Oracle instance are addressed using a 3-part redo byte address, or RBA. An RBA is comprised of- the log file sequence number (4 bytes)
- the log file block number (4 bytes)
- the byte offset into the block at which the redo record starts (2 bytes)
RBAs are used in the following important ways.
With respect to a dirty block in the buffer cache, the low RBA is the address of the redo for the first change that was applied to the block since it was last clean, and the high RBA is the address of the redo for the most recent change to have been applied to the block.The low and high RBAs for dirty buffers can be seen in X$BH. (There is also a recovery RBA which is used to record the progress of partial block recovery by PMON.) The incremental checkpoint RBA, the target RBA and the on-disk RBA can all be seen in X$TARGETRBA. The incremental checkpoint RBA and the on-disk RBA can also be seen in X$KCCCP. The full thread checkpoint RBA can be seen in X$KCCRT.Dirty buffers are maintained on the buffer cache checkpoint queues in low RBA order. The checkpoint RBA is the point up to which DBWn has written buffers from the checkpoint queues if incremental checkpointing is enabled -- otherwise it is the RBA of last full thread checkpoint. The checkpoint RBA is copied into the checkpoint progress record of the controlfile by the checkpoint heartbeat once every 3 seconds. Instance recovery, when needed, begins from the checkpoint RBA recorded in the controlfile. The target RBA is the point up to which DBWn should seek to advance the checkpoint RBA to satisfy instance recovery objectives.
The on-disk RBA is the point up to which LGWR has flushed the redo thread to the online log files. DBWn may not write a block for which the high RBA is beyond the on-disk RBA. Otherwise transaction recovery (rollback) would not be possible, because the redo needed to undo a change is always in the same redo record as the redo for the change itself.
The term sync RBA is sometimes used to refer to the point up to which LGWR is required to sync the thread. However, this is not a full RBA -- only a redo block number is used at this point.
12-Oct-2007 22:22
- Redo Byte Address(RBA)
- Redo Byte Address (RBA)
- Redo Byte Address (RBA)
- ORACLE RBA(redo byte address)
- Oracle RBA(Redo Byte Address) 说明
- Oracle RBA(Redo Byte Address) 说明
- Oracle RBA(Redo Byte Address) 说明
- Oracle RBA(Redo Byte Address) 说明
- ORACLE RBA(Redo Byte Address)说明
- Oracle RBA(Redo Block Address) 说明
- 理解redo(5)深入学习RBA
- 什么是RBA
- RBA 浅谈
- Oracle RBA
- 什么是RBA
- low RBA
- redo
- redo
- 【位计算】Gray Code
- 二叉树为什么用二级指针来构造的原因
- C语言中static的作用
- spring学习笔记(13)--aop annotation
- windows7开机密码破解
- Redo Byte Address (RBA)
- 在vc6.0中建立包含多个源程序的项目
- zoj3777 Problem Arrangement(状态压缩dp)
- Windows 8.1 Update 关闭 OneDrive 的方法
- 进制运算与位运算
- 发票语音查询系统的状态图
- 带权并查集 La 3027
- Best Practices for Speeding Up Your Web Site
- Ubuntu 14.04 编译newLISP 10.6.0