The Backup Exists and the Restore Does Not Finish
The report, in their words
A bad migration at 14:05 dropped a column and rewrote 40 million rows in the orders table. The decision to restore from last night's backup was made at 14:20. It is now 17:30, the restore is still running, the estimated finish keeps moving, and somebody has finally asked how long this is supposed to take. The runbook says "RTO: 1 hour".
Pull evidence
One item at a time, and nothing here tells you which one matters. Deciding what is worth looking at is most of the diagnosis.
Restore progress
What the backup actually is
Where the one-hour RTO came from
The restore target instance
The recovery point
When a restore was last tested
Is the backup readable?
Transfer from object storage
The read replica
0 of 9 inspected. You are not required to open all of them — a real investigation is judged on how few you needed.
What is your diagnosis?
Commit to one. Nothing below is shown until you do.
Guessing wrong and being told exactly why is the point of this page. Reading the answer first is not practice.