Call the SubmitSqlFlashbackTask API to submit a flashback SQL task.

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

  • 1: Image restoration
  • 0: reverse recovery
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:

  • 0: the exact match.
  • 1: the fuzzy match.

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.