Question about BDB recovery
I have a few basic questions about database recovery -
1) How does the database use the checkpoint records during the recovery . Does it scan the log files backwards starting from the eof-of-file and stop at the checkpoint records, before it starts applying the after image of the changes ?
2) if during the checkpoint process the DB is also being updated then how is a "quiet point" enforced. Is some kind of global lock acquired to force a "quiet point"?
3) How many log files are required for the recovery to work. Is there any impact on recovery if files not required (becuase DB has has checkpointed) are present ?
Appreciate your answer.