Perform point-in-time recovery (PITR)

MySQL | PostgreSQL | SQL Server

You can use point-in-time-recovery (PITR) to restore your primary Cloud SQL instances whether the instance is live, or is deleted. PITR lets you restore the instance to a specific point-in-time. For a deleted instance, you can restore the instance to a specific point-in-time to a new or existing instance.

Cloud SQL provides the following options to restore your instance using PITR:

For performing a PITR on an unavailable or deleted instance, you'll need to find the latest and earliest recovery time.

Perform a PITR

Console

  1. In the Google Cloud console, go to the Cloud SQL Instances page.

    Go to Cloud SQL Instances

  2. Open the more actions menu More actions icon. for the instance you want to recover and click Create clone.
  3. Optionally, on the Create a clone page, update the ID of the new clone.
  4. Select Clone from an earlier point in time.
  5. Enter a PITR time.
  6. Click Create clone.

gcloud

Create a clone using PITR.

Replace the following:

  • SOURCE_INSTANCE_NAME - Name of the instance you're restoring from.
  • NEW_INSTANCE_NAME - Name for the clone.
  • TIMESTAMP - UTC timezone for the source instance in RFC 3339 format. For example, 2012年11月15日T16:19:00.094Z.
gcloudsqlinstancescloneSOURCE_INSTANCE_NAME\
NEW_INSTANCE_NAME\
--point-in-time'TIMESTAMP'

REST v1

Before using any of the request data, make the following replacements:

  • project-id: The project ID
  • target-instance-id: The target instance ID
  • source-instance-id: The source instance ID
  • restore-timestamp The point-in-time to restore up to

HTTP method and URL: 

POST https://sqladmin.googleapis.com/v1/projects/project-id/instances/source-instance-id/clone

Request JSON body: 

{
 "cloneContext":
 {
 "kind": "sql#cloneContext",
 "destinationInstanceName": "target-instance-id",
 "pointInTime": "restore-timestamp"
 }
}

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Save the request body in a file named request.json, and execute the following command: 

curl -X POST \
 -H "Authorization: Bearer $(gcloud auth print-access-token)" \
 -H "Content-Type: application/json; charset=utf-8" \
 -d @request.json \
 "https://sqladmin.googleapis.com/v1/projects/project-id/instances/source-instance-id/clone"

PowerShell (Windows)

Save the request body in a file named request.json, and execute the following command: 

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
 -Method POST `
 -Headers $headers `
 -ContentType: "application/json; charset=utf-8" `
 -InFile request.json `
 -Uri "https://sqladmin.googleapis.com/v1/projects/project-id/instances/source-instance-id/clone" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
 "kind": "sql#operation",
 "targetLink": "https://sqladmin.googleapis.com/v1/projects/project-id/instances/target-instance-id",
 "status": "PENDING",
 "user": "user@example.com",
 "insertTime": "2020-01-21T22:43:37.981Z",
 "operationType": "CREATE",
 "name": "operation-id",
 "targetId": "target-instance-id",
 "selfLink": "https://sqladmin.googleapis.com/v1/projects/project-id/operations/operation-id",
 "targetProject": "project-id"
}

REST v1beta4

Before using any of the request data, make the following replacements:

  • project-id: The project ID
  • target-instance-id: The target instance ID
  • source-instance-id: The source instance ID
  • restore-timestamp The point-in-time to restore up to

HTTP method and URL: 

POST https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/source-instance-id/clone

Request JSON body: 

{
 "cloneContext":
 {
 "kind": "sql#cloneContext",
 "destinationInstanceName": "target-instance-id",
 "pointInTime": "restore-timestamp"
 }
}

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Save the request body in a file named request.json, and execute the following command: 

curl -X POST \
 -H "Authorization: Bearer $(gcloud auth print-access-token)" \
 -H "Content-Type: application/json; charset=utf-8" \
 -d @request.json \
 "https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/source-instance-id/clone"

PowerShell (Windows)

Save the request body in a file named request.json, and execute the following command: 

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
 -Method POST `
 -Headers $headers `
 -ContentType: "application/json; charset=utf-8" `
 -InFile request.json `
 -Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/source-instance-id/clone" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
 "kind": "sql#operation",
 "targetLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/target-instance-id",
 "status": "PENDING",
 "user": "user@example.com",
 "insertTime": "2020-01-21T22:43:37.981Z",
 "operationType": "CREATE",
 "name": "operation-id",
 "targetId": "target-instance-id",
 "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/operations/operation-id",
 "targetProject": "project-id"
}

Perform a PITR using the backup vault

If your Cloud SQL instance is enabled to use enhanced backups, then you can perform point-in-time-recovery for your instance using the backup vault.

Console

  1. In the Google Cloud console, go to the Cloud SQL Instances page.

    Go to Cloud SQL Instances

  2. Open the more actions menu More actions icon. for the instance you want to recover and click Create clone.

  3. Select Clone from an earlier point in time.

  4. Enter a PITR time.

  5. Click Create clone.

gcloud

To perform a PITR on an instance from the backup vault, you'll need to find the data-source for the backup that is nearest to the time you want to perform the PITR. To find the backup, see List all the backups in the backup vault for an instance. Once you've identified the backup, run the following command to perform the PITR:

gcloud sql instances point-in-time-restore DATA_SOURCE
PITR_TIMESTAMP
--project=TARGET_PROJECT

Replace the following:

  • DATA_SOURCE: the path of the data-source for the backup that is closest to the PITR timestamp you want to recover to.
  • PITR_TIMESTAMP: the UTC timestamp for the source instance PITR log you want to restore your instance to, in RFC 3339 format. For example, 2012年11月15日T16:19:00.094Z.
  • TARGET_PROJECT: the project ID of your Cloud SQL instance.

REST v1

REST v1beta4

Perform PITR on an unavailable instance

Console

You might want to recover an instance that isn't available to a different zone because of the following reasons:

  • The zone in which the instance is configured isn't accessible. This instance has a FAILED state.
  • The instance is undergoing maintenance. This instance has a MAINTENANCE state.

To recover an unavailable instance, complete the following steps:

  1. In the Google Cloud console, go to the Cloud SQL Instances page.

    Go to Cloud SQL Instances

  2. Find the row of the instance to clone.
  3. In the Actions column, click the More Actions menu.
  4. Click Create clone.
  5. On the Create a clone page, complete the following actions:
    1. In the Instance ID field, update the instance ID, if needed.
    2. Click Clone from an earlier point in time.
    3. In the Point in time field, select a date and time from which you want to clone data. This recovers the state of the instance from that point in time.
    4. Click Create clone.

    6. While the clone initializes, you're returned to the instance listing page.

gcloud

You might want to recover an instance that isn't available to a different zone because the zone in which the instance is configured isn't accessible.

gcloudsqlinstancescloneSOURCE_INSTANCE_NAMETARGET_INSTANCE_NAME\
--point-in-timeDATE_AND_TIME_STAMP\
--preferred-zoneZONE_NAME\
--preferred-secondary-zoneSECONDARY_ZONE_NAME

The user or service account that's running the gcloud sql instances clone command must have the cloudsql.instances.clone permission. For more information about required permissions to run gcloud CLI commands, see Cloud SQL permissions.

REST v1

You might want to recover an instance that isn't available to a different zone because the zone in which the instance is configured isn't accessible.

Before using any of the request data, make the following replacements:

  • PROJECT_ID: the project ID.
  • SOURCE_INSTANCE_NAME: the name of the source instance.
  • TARGET_INSTANCE_NAME: the name of the target (cloned) instance.
  • DATE_AND_TIME_STAMP: a date-and-time stamp for the source instance in the UTC time zone and in the RFC 3339 format (for example,
    2012年11月15日T16:19:00.094Z).
  • ZONE_NAME: Optional. The name of the primary zone for the target instance. This is used to specify a different primary zone for the Cloud SQL instance that you want to clone. For a regional instance, this zone replaces the primary zone, but the secondary zone remains the same as the instance.
  • SECONDARY_ZONE_NAME: Optional. The name of the secondary zone for the target instance. This is used to specify a different secondary zone for the regional Cloud SQL instance that you want to clone.

HTTP method and URL: 

POST https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/SOURCE_INSTANCE_NAME/clone

Request JSON body: 

{
 "cloneContext":
 {
 "destinationInstanceName": "TARGET_INSTANCE_NAME",
 "pointInTime": "DATE_AND_TIME_STAMP",
 "preferredZone": "ZONE_NAME",
 "preferredSecondaryZone": "SECONDARY_ZONE_NAME"
 }
}

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Save the request body in a file named request.json, and execute the following command: 

curl -X POST \
 -H "Authorization: Bearer $(gcloud auth print-access-token)" \
 -H "Content-Type: application/json; charset=utf-8" \
 -d @request.json \
 "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/SOURCE_INSTANCE_NAME/clone"

PowerShell (Windows)

Save the request body in a file named request.json, and execute the following command: 

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
 -Method POST `
 -Headers $headers `
 -ContentType: "application/json; charset=utf-8" `
 -InFile request.json `
 -Uri "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/SOURCE_INSTANCE_NAME/clone" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
 "kind": "sql#operation",
 "targetLink": "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/TARGET_INSTANCE_NAME",
 "status": "PENDING",
 "user": "user@example.com",
 "insertTime": "2020-01-21T22:43:37.981Z",
 "operationType": "CLONE",
 "name": "OPERATION_ID",
 "targetId": "TARGET_INSTANCE_NAME",
 "selfLink": "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/operations/OPERATION_ID",
 "targetProject": "PROJECT_ID",
 "instanceUid": "INSTANCE_ID"
}

The user or service account that's using the instances.clone API method must have the cloudsql.instances.clone permission. For more information about required permissions to use API methods, see Cloud SQL permissions.

REST v1beta4

You might want to recover an instance that isn't available to a different zone because the zone in which the instance is configured isn't accessible.

Before using any of the request data, make the following replacements:

  • PROJECT_ID: the project ID.
  • SOURCE_INSTANCE_NAME: the name of the source instance.
  • TARGET_INSTANCE_NAME: the name of the target (cloned) instance.
  • DATE_AND_TIME_STAMP: a date-and-time stamp for the source instance in the UTC time zone and in the RFC 3339 format (for example,
    2012年11月15日T16:19:00.094Z).
  • ZONE_NAME: Optional. The name of the primary zone for the target instance. This is used to specify a different primary zone for the Cloud SQL instance that you want to clone. For a regional instance, this zone replaces the primary zone, but the secondary zone remains the same as the instance.
  • SECONDARY_ZONE_NAME: Optional. The name of the secondary zone for the target instance. This is used to specify a different secondary zone for the regional Cloud SQL instance that you want to clone.

HTTP method and URL: 

POST https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID/instances/SOURCE_INSTANCE_NAME/clone

Request JSON body: 

{
 "cloneContext":
 {
 "destinationInstanceName": "TARGET_INSTANCE_NAME",
 "pointInTime": "DATE_AND_TIME_STAMP",
 "preferredZone": "ZONE_NAME",
 "preferredSecondaryZone": "SECONDARY_ZONE_NAME"
 }
}

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Save the request body in a file named request.json, and execute the following command: 

curl -X POST \
 -H "Authorization: Bearer $(gcloud auth print-access-token)" \
 -H "Content-Type: application/json; charset=utf-8" \
 -d @request.json \
 "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID/instances/SOURCE_INSTANCE_NAME/clone"

PowerShell (Windows)

Save the request body in a file named request.json, and execute the following command: 

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
 -Method POST `
 -Headers $headers `
 -ContentType: "application/json; charset=utf-8" `
 -InFile request.json `
 -Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID/instances/SOURCE_INSTANCE_NAME/clone" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
 "kind": "sql#operation",
 "targetLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID/instances/TARGET_INSTANCE_NAME",
 "status": "PENDING",
 "user": "user@example.com",
 "insertTime": "2020-01-21T22:43:37.981Z",
 "operationType": "CLONE",
 "name": "OPERATION_ID",
 "targetId": "TARGET_INSTANCE_ID",
 "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID/operations/OPERATION_ID",
 "targetProject": "PROJECT_ID",
 "instanceUid": "INSTANCE_ID"
}

The user or service account that's using the instances.clone API method must have the cloudsql.instances.clone permission. For more information about required permissions to use API methods, see Cloud SQL permissions.

If you try to create a PITR clone at a time after the latest recoverable time, then the following error message is given:

Thetimestampforpoint-in-timerecoveryisafterthelatestrecoverytimeof
Timestampoflatestrecoverytime.Clonetheinstancewithatime
that'searlierthanthisrecoverytime.

Perform PITR on a deleted instance

To use PITR to restore a deleted instance, you'll need:

  • the PITR timestamp (timestamp) you want to restore your instance to
  • the target instance name
  • the time the source instance was deleted (source-instance-deletion-time)

You can use PITR on a deleted instance using gcloud CLI or the Cloud SQL API only. For more information, see Restore a deleted instance using a PITR.

gcloud

Find your PITR window

To find your deleted instance's PITR window, get the earliest and latest recovery time for your instance. You can select anytime timestamp in this window to perform a PITR.

Find source instance deletion time and log retention days

The source-instance-deletion-time and log-retention-days for the deleted instance are stored with the retained backups for your instance after deletion. To find these values for your deleted instance, see List retained backups.

Restore using a PITR

To restore your deleted instance using a PITR, run the following command:

gcloud sql instances clone SOURCE_INSTANCE_NAME \
NEW_INSTANCE_NAME \
--point-in-time='PITR_TIMESTAMP' \
--source-instance-deletion-time=SOURCE_INSTANCE_DELETION_TIMESTAMP

Replace the following:

  • SOURCE_INSTANCE_NAME: the name of the source instance that you want to restore.
  • NEW_INSTANCE_NAME: the name of the new instance.
  • PITR_TIMESTAMP: the UTC timestamp for the source instance PITR log you want to restore your instance to, in RFC 3339 format. For example, 2012年11月15日T16:19:00.094Z.
  • SOURCE_INSTANCE_DELETION_TIMESTAMP: the UTC timestamp for the time that the source instance was deleted, in RFC 3339 format. For example, 2012年11月15日T16:19:00.094Z.

REST v1

Find your PITR window

To find your deleted instance's PITR window, get the earliest and latest recovery time for your instance. You can select anytime timestamp in this window to perform a PITR.

Find source instance deletion time and log retention days

The source-instance-deletion-time and log-retention-days for the deleted instance are stored with the retained backups for your instance after deletion. To find these values for your deleted instance, see List retained backups.

Restore using a PITR

Before using any of the request data, make the following replacements:

  • project-id: the project ID
  • target-instance-id: the target instance ID
  • source-instance-id: the source instance ID
  • source-instance-deletion-time: the deletion time of the source instance
  • restore-timestamp the point-in-time which you want to restore the instance

HTTP method and URL: 

POST https://sqladmin.googleapis.com/v1/projects/project-id/instances/source-instance-id/clone

Request JSON body: 

{
 "cloneContext":
 {
 "kind": "sql#cloneContext",
 "destinationInstanceName": "target-instance-id",
 "sourceInstanceDeletionTime: "source-instance-deletion-time",
 "pointInTime": "restore-timestamp"
 }
}

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Save the request body in a file named request.json, and execute the following command: 

curl -X POST \
 -H "Authorization: Bearer $(gcloud auth print-access-token)" \
 -H "Content-Type: application/json; charset=utf-8" \
 -d @request.json \
 "https://sqladmin.googleapis.com/v1/projects/project-id/instances/source-instance-id/clone"

PowerShell (Windows)

Save the request body in a file named request.json, and execute the following command: 

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
 -Method POST `
 -Headers $headers `
 -ContentType: "application/json; charset=utf-8" `
 -InFile request.json `
 -Uri "https://sqladmin.googleapis.com/v1/projects/project-id/instances/source-instance-id/clone" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
 "kind": "sql#operation",
 "targetLink": "https://sqladmin.googleapis.com/v1/projects/project-id/instances/target-instance-id",
 "status": "PENDING",
 "user": "user@example.com",
 "insertTime": "2020-01-21T22:43:37.981Z",
 "operationType": "CLONE",
 "name": "operation-id",
 "targetId": "target-instance-id",
 "selfLink": "https://sqladmin.googleapis.com/v1/projects/project-id/operations/operation-id",
 "targetProject": "project-id"
}

REST v1beta4

Find your PITR window

To find your deleted instance's PITR window, get the earliest and latest recovery time for your instance. You can select anytime timestamp in this window to perform PITR.

Find source instance deletion time and log retention days

The source-instance-deletion-time and log-retention-days for the deleted instance are stored with the retained backups for your instance after deletion. To find these values for your deleted instance, see List retained backups.

Restore using PITR

Before using any of the request data, make the following replacements:

  • project-id: the project ID
  • target-instance-id: the target instance ID
  • source-instance-id: the source instance ID
  • source-instance-deletion-time: the deletion time of the source instance
  • restore-timestamp the point-in-time which you want to restore the instance

HTTP method and URL: 

POST https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/source-instance-id/clone

Request JSON body: 

{
 "cloneContext":
 {
 "kind": "sql#cloneContext",
 "destinationInstanceName": "target-instance-id",
 "sourceInstanceDeletionTime: "source-instance-deletion-time",
 "pointInTime": "restore-timestamp"
 }
}

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Save the request body in a file named request.json, and execute the following command: 

curl -X POST \
 -H "Authorization: Bearer $(gcloud auth print-access-token)" \
 -H "Content-Type: application/json; charset=utf-8" \
 -d @request.json \
 "https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/source-instance-id/clone"

PowerShell (Windows)

Save the request body in a file named request.json, and execute the following command: 

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
 -Method POST `
 -Headers $headers `
 -ContentType: "application/json; charset=utf-8" `
 -InFile request.json `
 -Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/source-instance-id/clone" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

Response

{
 "kind": "sql#operation",
 "targetLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/instances/target-instance-id",
 "status": "PENDING",
 "user": "user@example.com",
 "insertTime": "2020-01-21T22:43:37.981Z",
 "operationType": "CREATE",
 "name": "operation-id",
 "targetId": "target-instance-id",
 "selfLink": "https://sqladmin.googleapis.com/sql/v1beta4/projects/project-id/operations/operation-id",
 "targetProject": "project-id"
}

Get the earliest and latest recovery time

For an available instance, you can perform a PITR to any timestamp in the instance's PITR window. The PITR window starts a the earliest recovery time and ends at the latest recovery time. If the instance is unavailable and the instance logs are stored in Cloud Storage, or the instance was deleted and had PITR retention enabled, then you can retrieve the earliest and latest recovery time, and perform the PITR to any timestamp in that window. In all cases, you can restore the instance to a different primary or secondary zone by providing values for the preferred zones.

gcloud

Unavailable instance

To get the earliest and latest time to which you can recover a Cloud SQL instance that's not available, run the following command:

gcloud sql instances get-latest-recovery-time INSTANCE_NAME

Replace the following:

  • INSTANCE_NAME: the name of the instance you want to find the latest recovery time for.

Deleted instance

To get the earliest and latest time to which you can recover a Cloud SQL deleted instance to, run the following command:

gcloud sql instances get-latest-recovery-time INSTANCE_NAME
--source-instance-deletion-time='SOURCE_INSTANCE_DELETION_TIMESTAMP'

Replace the following:

  • INSTANCE_NAME: the name of the instance you want to find the latest recovery time for.
  • SOURCE_INSTANCE_DELETION_TIMESTAMP: the UTC timestamp for the time that the source instance was deleted, in RFC 3339 format. For example, 2012年11月15日T16:19:00.094Z.

REST v1

Unavailable instance

Before using any of the request data, make the following replacements:

  • PROJECT_ID: the project ID
  • INSTANCE_NAME: the name of the instance for which you're querying for the latest recovery time

HTTP method and URL: 

GET https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/INSTANCE_NAME/getLatestRecoveryTime

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Execute the following command: 

curl -X GET \
 -H "Authorization: Bearer $(gcloud auth print-access-token)" \
 "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/INSTANCE_NAME/getLatestRecoveryTime"

PowerShell (Windows)

Execute the following command: 

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
 -Method GET `
 -Headers $headers `
 -Uri "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/INSTANCE_NAME/getLatestRecoveryTime" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

{
 "kind": "sql#getLatestRecoveryTime",
 "earliestRecoveryTime": "2023-06-10T17:23:59.648821586Z",
 "latestRecoveryTime": "2023-06-20T17:23:59.648821586Z"
}

Deleted instance

Before using any of the request data, make the following replacements:

  • PROJECT_ID: the project ID
  • INSTANCE_NAME: the name of the source instance for which you're querying for the latest recovery time
  • SOURCE_INSTANCE_DELETION_TIME: the time that the source instance was deleted

HTTP method and URL: 

GET https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/INSTANCE_NAME/getLatestRecoveryTime

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Execute the following command: 

curl -X GET \
 -H "Authorization: Bearer $(gcloud auth print-access-token)" \
 "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/INSTANCE_NAME/getLatestRecoveryTime"

PowerShell (Windows)

Execute the following command: 

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
 -Method GET `
 -Headers $headers `
 -Uri "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/INSTANCE_NAME/getLatestRecoveryTime" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

{
 "kind": "sql#getLatestRecoveryTime",
 "earliestRecoveryTime": "2023-06-10T17:23:59.648821586Z",
 "latestRecoveryTime": "2023-06-20T17:23:59.648821586Z"
}

REST v1beta4

Unavailable instance

Before using any of the request data, make the following replacements:

  • PROJECT_ID: the project ID
  • INSTANCE_NAME: the name of the instance for which you're querying for the latest recovery time

HTTP method and URL: 

GET https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID/instances/INSTANCE_NAME/getLatestRecoveryTime

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Execute the following command: 

curl -X GET \
 -H "Authorization: Bearer $(gcloud auth print-access-token)" \
 "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID/instances/INSTANCE_NAME/getLatestRecoveryTime"

PowerShell (Windows)

Execute the following command: 

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
 -Method GET `
 -Headers $headers `
 -Uri "https://sqladmin.googleapis.com/sql/v1beta4/projects/PROJECT_ID/instances/INSTANCE_NAME/getLatestRecoveryTime" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

{
 "kind": "sql#getLatestRecoveryTime",
 "earliestRecoveryTime": "2023-06-10T17:23:59.648821586Z",
 "latestRecoveryTime": "2023-06-20T17:23:59.648821586Z"
}

Deleted instance

Before using any of the request data, make the following replacements:

  • PROJECT_ID: the project ID
  • INSTANCE_NAME: the name of the source instance for which you're querying for the latest recovery time
  • SOURCE_INSTANCE_DELETION_TIME: the time that the source instance was deleted

HTTP method and URL: 

GET https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/INSTANCE_NAME/getLatestRecoveryTime

To send your request, expand one of these options:

curl (Linux, macOS, or Cloud Shell)

Execute the following command: 

curl -X GET \
 -H "Authorization: Bearer $(gcloud auth print-access-token)" \
 "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/INSTANCE_NAME/getLatestRecoveryTime"

PowerShell (Windows)

Execute the following command: 

$cred = gcloud auth print-access-token
$headers = @{ "Authorization" = "Bearer $cred" }

Invoke-WebRequest `
 -Method GET `
 -Headers $headers `
 -Uri "https://sqladmin.googleapis.com/v1/projects/PROJECT_ID/instances/INSTANCE_NAME/getLatestRecoveryTime" | Select-Object -Expand Content

You should receive a JSON response similar to the following:

{
 "kind": "sql#getLatestRecoveryTime",
 "earliestRecoveryTime": "2023-06-10T17:23:59.648821586Z",
 "latestRecoveryTime": "2023-06-20T17:23:59.648821586Z"
}

Troubleshoot

Issue Troubleshooting

argument --point-in-time: Failed to parse date/time:
Unknown string format: 2021-0928T30:54:03.094;
received: 2021-0928T30:54:03.094Z

OR

Invalid value at 'body.clone_context.point_in_time'
(type.googleapis.com/google.protobuf.Timestamp), Field 'pointInTime',
Invalid time format: Failed to parse input,

 The timestamp you provided is invalid.

HTTP Error 400: Successful backup required for carrying out the operation was not found.

OR

Successful backup required for carrying out the operation was not found. or Time where no backups can be found.

 The timestamp that you provided is for a time where backups or when binlog coordinates could not be found.

What's next

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025年11月04日 UTC.