Amazon Aurora
User Guide for Aurora (API Version 2014-10-31)

Restoring a DB Cluster to a Specified Time

You can restore a DB cluster to a specific point in time, creating a new DB cluster. When you restore a DB cluster to a point in time, the default DB security group is applied to the new DB cluster. If you need custom DB security groups applied to your DB cluster, you must apply them explicitly using the AWS Management Console, the AWS CLI modify-db-cluster command, or the Amazon RDS API ModifyDBCluster action after the DB instance is available.

Note

For more information about backing up and restoring an Aurora DB cluster, see Overview of Backing Up and Restoring an Aurora DB Cluster. For Aurora MySQL, you can restore a provisioned DB cluster to an Aurora Serverless DB cluster. For more information, see Restoring an Aurora Serverless DB Cluster.

You can restore a DB cluster to a point in time using the AWS Management Console, the AWS CLI, or the RDS API.

AWS Management Console

To restore a DB cluster to a specified time

  1. Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.

  2. In the navigation pane, choose Instances.

  3. Select the primary instance of the DB cluster that you want to restore.

  4. Choose Instance actions, and then choose Restore to point in time.

    The Launch DB Instance window appears.

  5. Choose Latest restorable time to restore to the latest possible time, or choose Custom to choose a time.

    If you chose Custom, enter the date and time that you want to restore the cluster to.

  6. Type the name of the restored DB instance in the DB instance identifier box, and complete the other options.

  7. Choose Launch DB Instance.

CLI

To restore a DB cluster to a specified time, use the AWS CLI command restore-db-cluster-to-point-in-time to create a new DB cluster.

For Linux, OS X, or Unix:

aws rds restore-db-cluster-to-point-in-time \ --source-db-cluster-identifier mysourcedbcluster \ --db-cluster-identifier mytargetdbcluster \ --restore-to-time 2017-10-14T23:45:00.000Z

For Windows:

aws rds restore-db-cluster-to-point-in-time ^ --source-db-cluster-identifier mysourcedbcluster ^ --db-cluster-identifier mytargetdbcluster ^ --restore-to-time 2017-10-14T23:45:00.000Z
API

To restore a DB cluster to a specified time, call the Amazon RDS API RestoreDBClusterToPointInTime action with the following parameters:

  • SourceDBClusterIdentifier

  • DBClusterIdentifier

  • RestoreToTime