Restore a Cross Region Automated RDS Backup using CLI

Hi, I have region 1 with an Oracle RDS instance configured with automated backups to region 2

is it possible to use CLI to restore to the "latest time" in the region 2?

Enter image description here

I have tried with restore-db-instance-to-point-in-time and restore-db-instance-from-db-snapshot but I can't find a way to do the restore point in time to the latest time as I can do using the user interface.

Topics

Storage Database

Tags

AWS Backup RDS Custom for SQL Oracle Amazon RDS Database Preview Environment

Language

English

asked 4 days ago120 views

4 Answers

Newest
Most votes
Most comments

Accepted Answer

https://docs.aws.amazon.com/cli/latest/reference/rds/restore-db-instance-to-point-in-time.html

--use-latest-restorable-time | --no-use-latest-restorable-time (boolean)

Specifies whether the DB instance is restored from the latest backup time. By default, the DB instance isn't restored from the latest backup time.

Your command should look something like this:

aws rds restore-db-instance-to-point-in-time \
    --source-db-instance-automated-backups-arn "arn:aws:rds:us-west-2:123456789012:auto-backup:ab-jkib2gfq5rv7replzadausbrktni2bn4example" \
    --target-db-instance-identifier myorclinstance-from-replicated-backup \
    --use-latest-restorable-time

EXPERT

iBehr

answered 4 days ago

EXPERT

A_J

reviewed 4 days ago

EXPERT

Oleksii Bebych

reviewed 4 days ago

Sure. To restore an Oracle RDS instance to the latest point in time in region 2, use the AWS CLI command restore-db-instance-to-point-in-time. This creates a new DB instance based on the specified time, typically within 5 minutes of the current time. Ensure the new instance has a similar size and IOPS as the source DB instance to avoid compatibility issues.