All Products
Search
Document Center

ApsaraDB RDS:A "The operation is not permitted due to no backup" error is reported when creating a temporary instance

Last Updated:May 09, 2022

Overview

This topic describes how to handle the The operation is not permitted due to no backup error when you create a temporary instance in the ApsaraDB RDS console.

Details

Take note of the following items:

  • Before you perform high-risk operations such as modifying the specifications or data of an Alibaba Cloud instance, we recommend that you check the disaster recovery and fault tolerance capabilities of the instance to ensure data security.
  • Before you modify the specifications or data of an Alibaba Cloud instance, such as an Elastic Compute Service (ECS) instance or an ApsaraDB RDS instance, we recommend that you create snapshots or enable backups for the instance. For example, you can enable log backups for an ApsaraDB RDS instance.
  • If you have granted specific users the permissions on sensitive information, such as usernames and passwords, or submitted sensitive information in the Alibaba Cloud Management Console, we recommend that you modify the sensitive information at the earliest opportunity.

After the instance is overwritten and restored, ApsaraDB RDS creates a temporary instance through the API. The temporary instance cannot be created during the period between the time of overwritten restoration and the time of the previous backup. That is, there is a limit between the time of the user's overwritten restoration and the time of the previous backup set, and the temporary instance cannot be restored (that is, the temporary instance cannot be created). Refer to the following three scenarios to perform operations.

Solution 1

current time a, the last backup set time point b, and the last backup set time point b is c. at the current time a, the user rolls back the data to point b. after rollback, temporary instances cannot be created from point c to point b. the creation before point c is not affected.

Scenario 2

current time a, the last backup set time point b, and the last backup set time point b is c. the user creates a temporary instance at a certain point in time a1 between b and a and rolls it back to a1. no temporary instance can be created between b and a1. the creation before point in time b is not affected.

Solution 3

current time a, the last backup set time point b, and the last backup set time point b is c. a temporary instance is created at a point in time b1 between c and b and is rolled back to b1. no temporary instance can be created between c and b1.

Applicable scope

  • ApsaraDB RDS for MySQL
  • ApsaraDB RDS for SQL Server
  • ApsaraDB RDS for PostgreSQL