You can call this operation to implement precise data recovery during SQL flashback. In this case, the information about the execution QUERY is added to the RDS BINLOG used by the DRDS database.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

Request parameters

Parameter Type Required Example Description
Action String Yes EnableSqlFlashbackMatchSwitch

Required parameter. Value: EnableSqlFlashbackMatchSwitch.

DbName String Yes test

The name of the database you want to back up.

DrdsInstanceId String Yes drds***********

The ID of the ApsaraDB RDS for PostgreSQL instance.

Response parameters

Parameter Type Sample response Description
RequestId String 463A5F0F-12AD-4544-A902-B2B983******

The ID of the request.

Result Boolean true

Indicates whether SqlFlashbackMatchSwitch is enabled or not.

Success Boolean true

Indicates whether the request was sent successfully or not.

Examples

Sample requests

http(s)://drds.aliyuncs.com/? Action=EnableSqlFlashbackMatchSwitch
&DbName=test
&DrdsInstanceId=drds***********
&<Common request parameters>

Sample success responses

XML fomat

<Result>true</Result>
<RequestId>463A5F0F-12AD-4544-A902-B2B983******</RequestId>
<Success>true</Success>

JSON format

{
    "Result": true,
    "RequestId": "463A5F0F-12AD-4544-A902-B2B983******",
    "Success": true
}

Error codes

For a list of error codes, visit the API Error Center.