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!

checkpoint SCN and checkpoint counter

640772Jan 30 2013 — edited Feb 18 2013

Dear Experts,

What is the difference between checkpoint SCN and checkpoint counter ?

during startup of a crash database (may be shut abort), it check checkpoint counter of a datafile with control file and if they match it means this is right version!!! and then it check checkpoint SCN of the datafile with the stop SCN in control file for that file and start crash recovery, if the do not match.

I am confused about this checkpoint counter and will it identified that the right file is there or restored ?

Please correct me if I am wrong in the above scenario?

Regards
Sunil Kumar

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 18 2013

Added on Jan 30 2013

#general-database-discussions

14 comments

6,669 views