首页 > Linux操作系统 > Linux操作系统 > ORACLE RBA


原创 Linux操作系统 作者:aimos 时间:2011-10-06 00:00:21 0 删除 编辑
Question About RBA (Redo Block Address) [ID 759966.1]

  修改时间 08-JAN-2009     类型 HOWTO     状态 MODERATED  

In this Document

This document is being delivered to you via Oracle Support's (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version:
Information in this document applies to any platform.


1. What is RBA? Can you explain it in relation to a transaction and commit scn?How can I find out
which RBAs exist in a archive log/redo log? 3. For example:
Completed checkpoint up to RBA [0x19.2.10], SCN: 5586949


A "Redo Block Address" (RBA) describes a physical location within a redo log file. An RBA consists
of the following:

Log sequence number
Block number within log file
Byte offset within block

The structure of the redo block address is given below :
1 - The number of the redo log.
[4 bytes]

2 - The block offset from the beginning of the redo log file.
[4 bytes]

3 - The byte offset within the block.
[2 bytes]

So in this case, RBA [0x19.2.10] maps to Log squence 25, Block number 2 with byte offset 16.

As for the relation between RBA and SCN, you can see that RBA is actually a physical location
inside the redo log file while SCN is the system change number that is in fact a unit of time (a
timestamp) maintained by the database kernel which is used to order events.

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

下一篇: ORA-00600 [kpncxcc-3]
请登录后发表评论 登录


  • 博文量
  • 访问量