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] Log sequence number v$logmnr_contents.RBASQN Block number within log file v$logmnr_contents.RBABLK Byte offset within block v$logmnr_contents.RBABYTE So in this case, RBA [0x19.2.10] maps to Log squence 25, Block number 2 with byte offset 16. With this information you should be able to find the details from v$logmnr_contents. In particular, the buffer header information includes two fields: low-RBA and high-SCN. The low-RBA field indicates the point in the redo-log corresponding to the block’s first update after it came into the buffer cache. The high-SCN field indicates the SCN of the last update to the block.
heartbeat: 0 mount id: 0
本文转自maclean_007 51CTO博客，原文链接:
http://blog.51cto.com/maclean/1278258
