Oracle
1Z0-883 · Question #101
Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?
The correct answer is A. Start the server with the ?innodb_force_recovery option set to a non-zero value. See the full explanation below for the reasoning.
Question
Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?
Options
- AStart the server with the ?innodb_force_recovery option set to a non-zero value.
- BStart the server as usual, and then execute the REPAIR TABLE command.
- CStart the server as usual, and then execute the CHECK TABLE command.
- DStart the server with the ?innodb_recover_options option set to FORCE.
How the community answered
(23 responses)- A74% (17)
- B4% (1)
- C4% (1)
- D17% (4)
Community Discussion
No community discussion yet for this question.