Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CHECKPOINTS, SCN, LSN

GTS (DBA)Oct 28 2013 — edited Oct 31 2013

Greeting to Everyone !

I want to know more about relationship between CHECKPOINTS, SCN, LSN. (to maintain data consistency )

I read some articles many things are confusing me.

Ex:

Every redo log file has both a log sequence number and low and high SCN. The low SCN records

the lowest SCN recorded in the log file, while the high SCN records the highest SCN in the log file.

Thanks in advance ..

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 28 2013

Added on Oct 28 2013

#general-database-discussions

31 comments

4,164 views