Restoring an Amazon Redshift Cluster

You can restore an Amazon Redshift cluster to a selected target availability zone and change the node type of the cluster during the restore.

You can restore an Amazon Redshift cluster from any of the following backups:

• The most recent backup

• A backup from a specified date and time

Procedure

1. From the navigation pane, go to Protect > Databases.

   The database overview page appears.

2. On the Instances tab, from the list of Instances, select Cloud DB.

   The Instances page for cloud databases appears.

3. In the Actions column for the instance, click the action button , and then click Restore.

   The Backup content page appears.

4. Select the backup to restore:

   • To restore the most recent backup, in the upper-right corner of the page, select Show latest backup.

   • To restore a backup from a specific date and time, in the upper-right corner of the page, select Show backup as of a specific date, and then select the backup.

   • To restore a backup from a date range, in the upper-right corner of the page, select Show backup for a date range, and then select the backup.

5. To restore a snapshot, in the upper-right corner of the page, select Restore from snap copy.

6. Click RESTORE.

   The Restore options dialog box appears.

7. In the Cluster identifier box, type the identifier of the cluster that will be created from the snapshot. The identifier must not already exist within the region.

8. To make the instance accessible from the public internet, move the Public accessibility toggle key to the right.

9. Under Advanced, do the following:

   • From the Target availability zone list, select the availability zone that you want to create the instance in.

   • From the Node type list, select the node type to change the compute and memory capacity of the instance.

   • To define the subnet group, in the Subnet group box, type the subnet group name. Specifying a subnet group may limit the choice of availability zones.

   • To define the cluster parameter group, in the Cluster parameter group box, type the parameter group name.

   • To automatically upgrade to a newer version of cluster, move the Allow version upgrade toggle key to the right.

   • To define which subnets and IP ranges the cluster or instance can use in the Amazon virtual private cloud (VPC), in the VPC security group IDs box, enter the names of the security group ID.

     You can add multiple security groups, separated by commas. For example, you can enter "sg-1122,sg-3344".

10. Optional: To receive an Email when the restore operation completes, select the When the job completes, notify me via email check box.

11. Click SUBMIT.

    The Confirm restore dialog box appears.

12. Click YES.