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?
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.
- Newest
- Most votes
- Most comments
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
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.
Hi Giovanni! Thanks for your replay! I just found the parameter that I was looking for --source-db-instance-automated-backups-arn it works :-)
Relevant content
- asked 2 years ago
