|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
Rapid Visibility (RaV)
process, and therefore has not been subject to an independent technical review.|
Oracle Server - Enterprise Edition - Version: 10.2.0.3
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.
2 - The block offset from the beginning of the redo log file.
3 - The byte offset within the block.
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/，如需转载，请注明出处，否则将追究法律责任。