Help Center> GaussDB> API Reference> APIs (Recommended)> Backup and Restoration> Restoring Data to the Original or Existing Instance
Updated on 2024-07-12 GMT+08:00
View PDF

Restoring Data to the Original or Existing Instance

Function

This API is used to restore data to the original DB instance or an existing DB instance. Before calling this API:

URI

POST https://{endpoint}/v3/{project_id}/instances/recovery

Table 1 Parameter description

Parameter

Mandatory

Type

Description

project_id

Yes

String

Project ID of a tenant in a region.

For details about how to obtain the project ID, see Obtaining a Project ID.

Request Parameters

Table 2 Parameter description

Parameter

Mandatory

Type

Description

source

Yes

Object

Instance from which the backup was created. For details, see Table 3.

target

Yes

Object

The instance to which the backup is restored. For details, see Table 4.
Table 3 source field data structure description

Parameter

Mandatory

Type

Description

instance_id

Yes

String

DB instance ID.

type

Yes

String

Restoration type. The available values are as follows:

  • backup (default value): Data is restored using backups. In this case, backup_id is mandatory.
  • timestamp: Data is restored using point-in-time recovery. In this case, restore_time is mandatory.

backup_id

No

String

Backup ID used for restoration. It indicates the ID of the full backup corresponding to schema_type. This parameter must be specified when backups are used for restoration.

restore_time

No

String

Timestamp to which data is restored to using point-in-time recovery. You can query the available time range by calling the Querying the Restoration Time Range API.
Table 4 target field data structure description

Parameter

Mandatory

Type

Description

instance_id

Yes

String

ID of the DB instance which the backup will be restored to.

  • When restoring data to the original instance, enter the original instance ID.
  • When restoring data to an existing DB instance, enter the existing instance ID.

Response Parameters

Table 5 Response body parameters

Parameter

Type

Description

job_id

String

Task ID.

Example Request

Restoring data to the original or existing instance

POST https://gaussdb-opengauss.ap-southeast-1.myhuaweicloud.com/opengauss/v3/0483b6b16e954cb88930a360d2c4e663/instances/recovery
{ 
   "source" : { 
     "instance_id" : "5362449138da4e408dbae5152ca26640in14", 
     "type" : "backup", 
     "backup_id" : "cc94568cb5a54e4a8ab5dff95e64a5e0br14"
   }, 
   "target" : { 
     "instance_id" : "5362449138da4e408dbae5152ca26640in14" 
   } 
 }

Example Response

Data restored to the original or existing instance.

{ 
  "job_id" : "a03b1b8a-b756-467c-8a49-38720c3d23ec" 
}

Status Code

Error Code

For details, see Error Codes.

Parent topic: Backup and Restoration