ORACLE RBA

Question About RBA (Redo Block Address) [ID 759966.1]
		修改时间 08-JAN-2009     类型 HOWTO     状态 MODERATED

In this Document
  Goal
  Solution

---

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

Applies to:

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

Goal

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

Solution

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博客 ” ，链接：http://blog.itpub.net/23230551/viewspace-708653/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23230551/viewspace-708653/