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
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.