Restore a Cross Region Automated RDS Backup using CLI

Question

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](/media/postImages/original/IM48HGOybfToK8_ueJF5aatQ)

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.

iBehr · 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
```

Giovanni Lauria · Answer

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.

JT · Answer

Hi Giovanni!
Thanks for your replay! I just found the parameter that I was looking for   --source-db-instance-automated-backups-arn
it works :-)

JT · Answer

Hi iBehr!

yes! that is the one that I was looking for! Many thanks

Restore a Cross Region Automated RDS Backup using CLI

Relevant content