Oracle RDS PITR taking too much time to create instance

Question

Hi,
I'm trying to implement a DR for an Oracle RDS, for testing, we are copying the backups to a different region, I'm creating a PITR but is taking too long to create the new instance, it has been on **Creating ** for more than 3 hours and still running, not sure on what to do to reduce the RTO.

JT · Accepted Answer

After checking in detail I found that for some reason the cross region copy stopped, and the latest snapshot in the secondary region was 10 days old but it contained all the transactions up to date. Checking the recent events in the RDS I found that the copy that was supposed to happen every day with the new snapshot was getting cancelled.

I could not find a reason for the cancellation but, after disabling the cross region copy and re enabling it again, it started to work properly.

I will keep an eye just in case it happens again

I could not find a reason for the cancellation but, after disabling the cross region copy and re enabling it again, it started to work properly.

I will keep an eye just in case it happens again

anish_g · Answer

Hi, Please refer to the following post for the best practices guidelines for reducing the point-in-time restore times for RDS databases. 
https://repost.aws/knowledge-center/rds-point-in-time-restore-issues

AWS Backup also offers cross-region continuous backup and point-in-time restore for Amazon RDS Single instance databases which can be scheduled to run based on specific time window. But be aware of the limitations with database option groups copy.
https://docs.aws.amazon.com/aws-backup/latest/devguide/cross-region-backup.html

Oracle RDS PITR taking too much time to create instance

回答を追加する

関連するコンテンツ