Call the SubmitSqlFlashbackTask API to submit a flashback SQL task.
Debugging
Request parameters
Parameter | Type | Required | Example | Description |
---|---|---|---|---|
Action | String | Yes | SubmitSqlFlashbackTask |
Required parameter. Value: SubmitSqlFlashbackTask. |
DbName | String | Yes | test |
The name of the DRDS database. |
DrdsInstanceId | String | Yes | drds********* |
The ID of a DRDS instance. |
EndTime | String | Yes | 2019-09-10 23:23:23 |
The time when the SQL flashback task ends. |
RecallRestoreType | Integer | Yes | 0 |
The restoration type. Valid values:
|
StartTime | String | Yes | 2019-09-10 20:23:23 |
The start time of the flashback SQL statement. |
TraceId | String | No | ase***** |
The Trace ID of the flashback SQL. |
TableName | String | No | test |
The name of the table where the flashback SQL operation was performed. |
SqlType | String | No | INSERT,UPDATE |
The type of the SQL statement. Valid values: INSERT, UPDATE, and DELETE. Separate multiple types with commas (,). |
SqlPk | String | No | 11111 |
The primary key of flashback SQL. |
RecallType | Integer | No | 0 |
Exact match or fuzzy match. Valid values:
|
Response parameters
Parameter | Type | Example | Description |
---|---|---|---|
RequestId | String | DSSDF-SEWE-***** |
The ID of the request. |
Success | Boolean | true |
Indicates whether the database creation failure records were removed from the DRDS instance. |
TaskId | Long | 1111 |
The ID of the replication task. |
Examples
Sample requests
http(s)://drds.aliyuncs.com/? Action=SubmitSqlFlashbackTask
&DbName=test
&DrdsInstanceId=drds*********
&EndTime=2019-09-10 23:23:23
&RecallRestoreType=0
&StartTime=2019-09-10 20:23:23
&<Common request parameters>
Sample success responses
XML
format
<SubmitSqlFlashbackTaskResponse>
<RequestId>DSSDF-SEWE-*****</RequestId>
<Success>True</Success>
<TaskId>1111</TaskId>
</SubmitSqlFlashbackTaskResponse>
JSON
format
{
"RequestId": "DSSDF-SEWE-*****",
"Success": true,
"TaskId": 1111
}
Error codes
For a list of error codes, visit the API Error Center.