Register

checkpoints in data recovery

351 views
0 votes
0 votes
if we have more checkpoints, does the speed of recovery increase or decrease?
User Avatar

1 Answer

1 votes
1 votes

@Tara33

Checkpoint is a mechanism where all the previous logs are removed from the system and stored permanently in a storage disk...

Checkpoint declares a point before which the DBMS was in consistent state, and all the transactions were committed....

Frequent checkpointing writes dirty buffers to the datafiles more often than otherwise, and so reduces cache recovery time in the event of an instance failure. ...

However, in a high-update system, frequent checkpointing can reduce runtime performance, because checkpointing causes DBWn processes to perform writes....

User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
1
Tuhin Dutta asked Dec 8, 2017
1,269 views
Checkpoints in Data Recovery
Are they in the syllabus? I believe not since nothing is specified in the syllabus but I've seen questions in made easy test series regarding undo and redo list. ... Give contents of Undo and Redo list.
Are they in the syllabus? I believe not since nothing is specified in the syllabus but I've seen questions in made easy test series regarding undo and redo list.$(Start, ...
User Avatar
3 votes
3 votes
1 answer
2
Saikat asked Nov 5, 2015
3,794 views
Can anyone please help me with that UNDO and REDO concept in recovery of transaction with commit and checkpoint?
User Avatar
1 votes
1 votes
0 answers
3
sh!va asked Jul 9, 2016
271 views
Identify the recovery mechanism
A DBMS recovery mechanism is upgraded to recover the data even in case of failure of any one site including the coordinating site, without blocking any site. Which recovery mechanism was applied in this DBMS ? Two-phase commit Three-phase commit Roll-backward recovery Roll-forward recovery
A DBMS recovery mechanism is upgraded to recover the data even in case of failure of any one site including the coordinating site, without blocking any site. Which recove...
User Avatar
0 votes
0 votes
1 answer
4
indrajeet asked Jun 16, 2016
571 views
recovery from failure
IN DEFFERED DATABASE MODIFICATION ,A TRANSACTION IS PARTIALLY COMMITED AND FAILURE OCCURS BEFORE COMMIT AND A LOG IS CREATED AS FOLLOWS <T,STARTS> <T,A,500> <T,COMMITS> Q-> WILL THE ORIGINAL DATABSE WILL MODIFIED OR NOT?? PLEASE EXPLAIN.
IN DEFFERED DATABASE MODIFICATION ,A TRANSACTION IS PARTIALLY COMMITED AND FAILURE OCCURS BEFORE COMMIT AND A LOG IS CREATED AS FOLLOWS<T,STARTS><T,A,500><T,COMMITS>Q- WI...
User Avatar
Link Copied!