Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Oracle RDS PITR taking too much time to create instance

0

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.

Topics
Database
Tags
OracleRDS Custom for SQL Oracle
Language
English
asked 2 years ago538 views
2 Answers
0
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

answered 2 years ago
0

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

AWS
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content