Skip to Main Content


Dev Live Dev Intro

This month we are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Question and Answer

Tom Kyte

Thanks for the question.

Asked: March 23, 2001 - 1:29 pm UTC

Answered by: Tom Kyte - Last updated: June 22, 2006 - 2:53 pm UTC

Category: Database - Version: 8.1.7

Viewed 1000+ times

You Asked

What is RBA ?
What do these hex numbers mean ?
I saw this in the alert log

Oralcel 8.1.7

Mon Mar 5 21:47:26 2001
Completed checkpoint up to RBA [0x1c5.2.10], SCN: 0x0000.00047fc0
Tue Mar 6 20:45:21 2001
Beginning log switch checkpoint up to RBA [0x1c6.2.10], SCN: 0x0000.00047fd1
Thread 1 advanced to log sequence 454


and we said...

Redo Byte Address (RBA)

An RBA points to a specific location in a particular redo thread. It
is ten bytes long and has three components: log sequence number,
block number within log, and byte number within block.

and you rated our response

  (3 ratings)

Is this answer out of date? If it is, please let us know via a Review


RBA associated with fast start checkpointing

March 26, 2001 - 2:05 am UTC

Reviewer: Y Srinivas from VA USA

After reading this answer I recollect that now checkpointing is done at the block level (fast start checkpointing). Is the RBA address the last block used for checkpointing?

Contents of RBA

April 29, 2005 - 9:08 am UTC

Reviewer: Santosh Hiremath from India-Bangalore

How the RBA is generated.

Thanks and Regards,
Santosh from Bangalore.

If you have a time please explain me how exactly it is useful.



June 22, 2006 - 1:17 pm UTC

Reviewer: A reader

Hi Tom,

I would be thankful to you if you kindly explain this below line in detain or with EXAMPLE.

"Given a checkpoint RBA, DBWR writes buffers from the head of the queue until the low RBA of the buffer at the head of the checkpoint queue is greater than the checkpoint RBA."


Tom Kyte


June 22, 2006 - 2:53 pm UTC

let me just rephrase.

It is as straight forward as it looks in this case, don't over analyze it. Pretend the checkpoint rba is a "time". dbwr flushed out blocks to disk older than that time.