Postmortem of database outage of January 31

Re:Postmortem of database outage of January 31 by nhumrich on Saturday February 11, 2017 @09:28AM (#13622748)

I know about the daily snapshots, but didn't know about the archive logs. Is this something I have to enable? How do I get the logs and how do I restore using them?

[ Parent | on HN ]

Re:Postmortem of database outage of January 31 by illumin8 on Saturday February 11, 2017 @11:49AM (#13623360)

It's automatic. Go ahead and launch a new instance, restoring to a point in time (that's how you do restores in RDS). Notice that it gives you a calendar day/date/time fields where you can select the recovery point down to the second. This is enabled by replaying the archive logs to get you to the exact point in time.

[ Parent | on HN ]

Re:Postmortem of database outage of January 31 by nhumrich on Monday February 13, 2017 @11:57AM (#13636729)

Thank you! I never realized I could do this for some reason. I always restored from snapshots.

[ Parent | on HN ]