Follow dba-ninja.com

Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions

dba-ninja.com Links

Dba_db2_button

Sqlserver_dba_button

DeleteDBInstance - Cannot delete RDS Instance

14 September,2023 by Rambler

Question: I'm trying to delete an RDS Instance with the following aws cli command but getting an error message. The RDS Instance is associated with an AWS Backup Continuous Backup supporting Point in Time Recovery 

aws rds delete-db-instance --db-instance-identifier MyRDS --final-db-snapshot-identifier MyRDS130923

An error occurred (InvalidParameterCombination) when calling the DeleteDBInstance operation: Your RDS instance MyRDS is associated with an AWS Backup resource with id arn:aws:backup:us-west-2:3883838383:recovery-point:continuous:db-hdhdhdhdhdhdhdh. NoDeleteAutomatedBackups must be specified. For more details, see the AWS Backup documentation.

 

Answer: To confirm the RDS Instance is associated with the AWS Backup Continuous Backup run the following command , which returns the AwsBackupRecoveryPointArn  Key , indicating the AWS Backup Recovery Point 

aws rds describe-db-instances --db-instance-identifier MyRDS --query "DBInstances[].AwsBackupRecoveryPointArn"

To delete the RDS - if it is associated to the AWS Backup Continuous , you'll need to add the --no-delete-automated-backups.

aws rds delete-db-instance --db-instance-identifier MyRDS --final-db-snapshot-identifier MyRDS130923 --no-delete-automated-backups.

After the RDS has deleted , execute this command on AWS Backup and you'll notice the Continuous Recovery Point is still available and you can recover from this copy or you can recover from the final snapshot - which is available through the RDS service native backups 

aws backup list-recovery-points-by-backup-vault --backup-vault-name TRV-Backup-Vault --query "RecoveryPoints[?ResourceName=='MyRDS']

 

Read More 

AWS CLI Cheatsheet - RDS, AWS Backup , DMS, IAM, Security Token Service,KMS,EC2, DynamoDB,VPC,Aurora, RESOURCEGROUPSTAGGINGAPI

AWS Backup continuous backup - RDS, DynamoDB , Aurora

 


Author: Rambler (http://www.dba-ninja.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DeleteDBInstance - Cannot delete RDS Instance


dba-ninja.com