Overview
Restores databases with the backup files in the internal backup storage.
Make sure isRecovery is correctly set, as there is no restore database [userdb] with recovery API.
Use getDmsOperation to get the restoration progress, with the requestNo you can get from the response.
Request
Request parameters
| Parameter | Required | Type | Limitations | Description |
|---|---|---|---|---|
| cloudDBInstanceNo | Y | String | Cloud DB instance number | |
| fileName | Y | String | File name If the file is uploaded to a folder in Object Storage’s bucket, specify the file name inthe form of subfolder/filename. |
|
| isRecovery | Y | Boolean | Restoration mode (recovery and norecovery) Set this parameter to 1 if you do not need to restore log backups any more, and 0 if you need to restore additional logs with restoreDmdLog. |
|
| newDatabaseName | Y | String | Name of a new database to restore. It must be unique over the database instances to restore. |
|
| responseFormatType | N | String | Response format |
Examples
Request example
{CloudDB_API_URL}/restoreDmsDatabase?cloudDBInstanceNo=1010059&fileName=d1.full&isRecovery=0
Response example
<restoreDmsDatabaseResponse>
<requestId>e7ed561c-50de-4772-8791-c6b9bf5dbe10</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
<requestNo>782352</requestNo>
</restoreDmsDatabaseResponse>