Database Administration (MOSC)

MOSC Banner

Understanding REDO changes applies to datafiles

edited Jun 11, 2016 5:05AM in Database Administration (MOSC) 6 commentsAnswered

Hi Team,

I'm facing some problem understanding the concept of "how the REDO log changes are applied to the datafiles"

Whenever a transaction is commited the Change vector (ie update,inserted DML statement data)goes to the Online redo logs from the REDO log buffers.

However, how does database will come to know that what changes within the REDO logfiles will be applied to which datafiles (more specifically which data block).

My assumption is that it'll check the last SCN of the REDO, and then will make all the datafiles consistent upto that SCN no.

However I just wanted to havea clear picture regarding this topic.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center