Oracle
1Z0-873 · Question #77
The MySQL server host crashes at 10:00 in the morning, and is brought back online at 10:30. In order to ensure that all data are consistent, a copy is first made of the table, tablespace and log…
The correct answer is B. The binary logs recorded after the backup at 03:00 should be re-applied to make the database file. See the full explanation below for the reasoning.
Question
The MySQL server host crashes at 10:00 in the morning, and is brought back online at 10:30. In order to ensure that all data are consistent, a copy is first made of the table, tablespace and log files currently on the server host, and these files are then restored from a backup made at 03:00 the same morning. What should be done in order to bring the database to the state it was at just before the server host crashed?
Options
- AThe mysql_restore utility should be used to update the server to its last known state.
- BThe binary logs recorded after the backup at 03:00 should be re-applied to make the database file
- CThe procedure described is wrong; instead, the mysqlcheck utility should be used and only if that
- DOnce the backup files from 03:00 have been restored, there is nothing more that can be done to
How the community answered
(49 responses)- A4% (2)
- B84% (41)
- C10% (5)
- D2% (1)
Community Discussion
No community discussion yet for this question.