View a Backup
/paas/api/v1.1/instancemgmt/{identityDomainId}/services/MySQLCS/instances/{serviceId}/backups/{backupId}
Request
-
backupId: string
Backup ID.
-
identityDomainId: string
Name of the identity domain for the MySQL Cloud Service account.
-
serviceId: string
The user-defined name of the Oracle MySQL Cloud Service instance.
-
includeLinkedDetails(optional): boolean
Flag that specifies whether to include information (
true
) or exclude information about related backups (false
). When set totrue
:- For a full backup, includes information about all incremental backups performed since the last full backup.
- For an incremental backup, includes information about the previous full backup.
false
, excluding information about related backups.
-
X-ID-TENANT-NAME: string
Name of the identity domain for the MySQL Cloud Service account.
Response
- application/json
200 Response
object
-
backupCompleteDate(optional):
string
Date and time that the backup completed.
-
backupId(optional):
string
Backup ID. You can use the backup ID to manage the specific backup (for example, download).
-
backupStartDate(optional):
string
Date and time that the backup started.
-
databaseIncluded(optional):
boolean
This should always
false
for Oracle MySQL Cloud Service. -
deletedOnDate(optional):
string
Date and time that the backup deletion completed.
-
expirationDate(optional):
string
Date and time that the backup will be deleted automatically from storage. If specify
keepForever
in backup request, the backup is retained indefinitely or until manually deleted. -
full(optional):
boolean
Flag that specifies whether this is a full (
true
) or incremental (false
) backup. A full backup contains all the data files required to restore the service instance databases. An incremental backup contains only changes to the databases since the last scheduled full backup. -
fullBackup(optional):
string
Full backup linked to the incremental backup.
-
href(optional):
string
URI of the backup resource.
-
incrementalBackups(optional):
array incrementalBackups
List of incremental backups linked to the full backup, if any.
-
initiatedBy(optional):
string
User account that initiated this operation. If the operation is a scheduled automated backup, the value is
scheduled
. -
jobHistory(optional):
array jobHistory
Groups job history details. The job history details only return for a specific backup request.
-
jobId(optional):
string
Job ID for the backup.
-
local(optional):
boolean
Flag that specifies whether the backup is to be downloaded and stored locally (
true
), or archived and stored remotely on the Oracle Storage Cloud Service container (false
). -
localCopy(optional):
boolean
Flag that specifies whether the local copy of a backup is maintained for a backup that has been uploaded to the Oracle Storage Cloud Service.
-
notes(optional):
string
Free-form text that provides additional information about the backup.
-
size(optional):
string
Size of the backup, in MBs. For example:
1011.4MB
(backup complete) orUnknown
(backup in-progress). -
sizeInBytes(optional):
integer
Size of the backup, in Bytes.
-
status(optional):
string
Status of the backup. Valid values include:
Completed
,Failed
,Deleted
,Backup In Progress
,Upload In Progress
,Download In Progress
,Restore In Progress
, orDelete In Progress
. -
tag(optional):
object backup-view-info
array
array
object
-
endLSN(optional):
string
The last LSN of the backup.
-
endTime(optional):
string
Date and time (as epoch) that the backup completed.
-
lastBinLog(optional):
string
The name of the last binlog file.
-
lastBinLogPos(optional):
string
The last binlog position.
-
startLSN(optional):
string
The beginning LSN of the backup.
-
startTime(optional):
string
Date and time (as epoch) that the backup started.
-
triggeredBy(optional):
string
The user account that initiated this operation. If the operation is a scheduled automated backup, the value is
scheduled
.
object
-
completeDate(optional):
string
Date and time that the operation completed.
-
jobId(optional):
string
Job ID for the backup.
-
operation(optional):
string
Type of operation that was executed. For example,
backup
,delete
,upload
,download
, and so on. -
startDate(optional):
string
Date and time the operation started.
-
status(optional):
string
Status of the backup. Valid values include:
Completed
,Failed
,Deleted
,Backup In Progress
,Upload In Progress
,Download In Progress
,Restore In Progress
, orDelete In Progress
. -
statusDetails(optional):
string
History of system messages. Each message is separated by an ellipses
{...}
.
Examples
The following example shows retrieves information about a specific backup id for a MySQL Cloud Service instance by submitting a GET request on the REST endpoint using cURL.
Note: The command in this example uses the URL structure https://rest_server_url/resource-path
, where rest_server_url
is the Oracle Public Cloud or Oracle Cloud Machine REST server to contact for your identity domain or tenant name. See Send Requests for the appropriate URL structure to use on Oracle Public Cloud or Oracle Cloud Machine.
cURL Command
This example retrieves information for backup id 104148c3-2140-484b-8012-efc1c4907c74 for a MySQL Cloud Service instance named MyTestInstance in the ExampleIdentityDomain identity domain.
curl -i -X GET \ -u "username:password" \ -H "X-ID-TENANT-NAME: ExampleIdentityDomain" \ -H "Accept: application/json" \ -H "Content-Type: application/json" \ https://rest_server_url/paas/api/v1.1/instancemgmt/ExampleIdentityDomain/services/MySQLCS/instances/MyTestInstance/backups/104148c3-2140-484b-8012-efc1c4907c74
Example of Response Header
The following shows an example of the response header.
HTTP/1.1 200 OK
Server: Oracle-Application-Server-11g
Content-Language: en
Access-Control-Allow-Headers: Content-Type, api_key, Authorization
Access-Control-Allow-Methods: GET, POST, DELETE, PUT, OPTIONS, HEAD
X-ORACLE-DMS-ECID: iCd20Du6F02Fw0RHB7HQXGS0e0u005006p
X-ORACLE-DMS-ECID: iCd20Du6F02Fw0RHB7HQXGS0e0u005006p
Access-Control-Allow-Origin: *
X-Frame-Options: DENY
Content-Type: application/json
Vary: user-agent
Date: Thu, 15 Dec 2016 01:23:28 GMT
Content-Length: 1098
Connection: keep-alive
Example of Response Body
The following shows an example of the response body in JSON format.
{
"backupId": "104148c3-2140-484b-8012-efc1c4907c74",
"jobId": "8223717",
"backupStartDate": "2016-12-15T00:51:44.924+0000",
"backupCompleteDate": "2016-12-15T00:51:50.029+0000",
"expirationDate": "2017-01-14T00:51:44.924+0000",
"initiatedBy": "username",
"full": true,
"local": false,
"localCopy": true,
"databaseIncluded": false,
"size": "2.8MB",
"sizeInBytes": 2955038,
"status": "Completed",
"storageContainer": "Storage-exampleidentitydomain/MyBackupContainer",
"href": "https://rest_server_url:443/paas/api/v1.1/instancemgmt/exampleidentitydomain/services/MySQLCS/instances/MyTestInstance/backups/104148c3-2140-484b-8012-efc1c4907c74",
"jobHistory": [
{
"operation": "backup",
"jobId": "4223717",
"status": "Completed",
"startDate": "2016-12-15T00:51:44.924+0000",
"completeDate": "2016-12-15T00:51:50.029+0000",
"statusDetails": "Backup and backup image validation completed successfully."
}
],
"tag": "{\"startTime\":1481763105,\"endTime\":1481763106,\"startLSN\":1731072,\"endLSN\":1731376,\"lastBinLog\":\"mytestinstance-mysql-1.000002\",\"lastBinLogPos\":3652,\"triggeredBy\":\"username\"}"
}