RDS: Testing the restore of the entire database to the last recoverable time possible?

0

Hi,

I ran the DR test and I managed to restore a new RDS instance using the PITR on the (RDS) Automated backup, however when I inspected the data in the database I only found a very small subset of the data in the new DB instance. I would have thought it would replay the snapshot and apply all the WAL logs it has at its own disposal, but I might be mistaken.

What is the correct DR recovery procedure to recover the entire database to the latest possible time?

Cheers, Peter.

2개 답변
0
profile pictureAWS
전문가
답변함 한 달 전
profile picture
전문가
검토됨 한 달 전
0

Hello,

Please note, RDS automated backup takes snapshot everyday during backup window and it uploads transaction logs (wal logs) for DB instances to Amazon S3 every five minutes.

Furthermore, to see the latest restorable time for a DB instance, use the AWS CLI describe-db-instances command and look at the value returned in the LatestRestorableTime field for the DB instance [1]. Optionally, to see the earliest restorable time for each DB instance, choose Automated backups in the Amazon RDS console.

Generally, RPO would be 5 mins using RDS automated backups because transaction logs backup is taken every 5 mins to S3.

Reference

[1] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIT.html : Restoring a DB instance to a specified time

Hope it helps and if it does, I would appreciate if answer can be accepted so that community can benefit for clarity when searching for similar enquiries in repost/aws guide.

Thank you!

AWS
답변함 한 달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠