NCP-DB-6.10 · Question #27
When trying to restore a database via Time Machine (TM), the option to restore data to a Point in Time is not available. What should the administrator do to enable Point in Time Recovery?
The correct answer is A. Use an SLA that supports Continuous Log retention. Point in Time Recovery (PITR) is a feature of NDB that allows restoring a database to any point in time within the retention period of the SLA. To enable PITR, the SLA must support Continuous Log retention, which means that NDB captures and stores the database logs…
Question
When trying to restore a database via Time Machine (TM), the option to restore data to a Point in Time is not available. What should the administrator do to enable Point in Time Recovery?
Options
- AUse an SLA that supports Continuous Log retention.
- BUpdate the TM schedule to perform DB Log catch up.
- CTake a Manual snapshot and use it for DB recovery.
- DUse Brass SLA & update the Log catch up frequency.
How the community answered
(39 responses)- A72% (28)
- B8% (3)
- C5% (2)
- D15% (6)
Explanation
Point in Time Recovery (PITR) is a feature of NDB that allows restoring a database to any point in time within the retention period of the SLA. To enable PITR, the SLA must support Continuous Log retention, which means that NDB captures and stores the database logs continuously. This allows NDB to replay the logs from the last snapshot to the desired point in time during the restore process. The other options do not enable PITR, but rather affect the frequency and timing of the snapshots and log catch up operations.
Topics
Community Discussion
No community discussion yet for this question.