Oracle
1Z0-883 · Question #103
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE…
The correct answer is A. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE. See the full explanation below for the reasoning.
Question
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values:
RELAY_LOG_FILE = hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?
Options
- ASTOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;
- BSTOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0,
- CSTOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = `hostname-relay-bin.00004',
- DSTOP SLAVE; SET GLOBAL master_delay =0; START SLAVE;
How the community answered
(38 responses)- A84% (32)
- B3% (1)
- C8% (3)
- D5% (2)
Community Discussion
No community discussion yet for this question.