| « PreviousNext » | |
   | Did this page help you? Yes | No | Tell us about it... |
Restoring a DB Instance to a Specified Time
The Amazon RDS automated backup feature automatically creates a backup of your database. This backup occurs during a daily user-configurable 30 minute period known as the backup window. Automated backups are kept for a configurable number of days (called the backup retention period). You can restore your DB instance to any specific time during this retention period, creating a new DB instance.
Note
When you restore a DB instance to a point in time, the default DB security group is applied to the new DB instance. If you need custom DB security groups applied to your DB instance you must apply them explicitly using the AWS Management Console, ModifyDBInstance API, or the rds-modify-db-instance command line tool once the DB instance is available.
When restoring a DB instance that is using the Oracle DB engine to a point in time, you can specify a different Oracle DB engine, license model, and DBName (SID) to be used by the new DB instance.
In this example, you restore a database instance to a specified time, creating a new DB instance.
Note
You can restore to any point in time during your backup retention period. To determine the
latest restorable time for a DB instance, use the
rds-describe-db-instance command with the
--show-long and --headers parameters
and look at the value returned in the Latest Restorable Time
column. The latest restorable time for a DB instance is typically within 5 minutes of
the current time.
The OFFLINE, EMERGENCY, and SINGLE_USER modes are not currently supported. Setting any database into one of these modes will cause the latest restorable time to stop moving ahead for the whole instance.
When you restore a DB instance that is using the SQL Server DB engine to a point in time, each database within that instance will be restored to a point in time within 1 second of each other database within the instance. Transactions that span multiple databases within the instance may be restored inconsistently.
Additionally, if you are administering a DB instance using the SQL Server DB engine, you could change the recovery model of some databases or otherwise perform actions that break the sequence of logs that allow continuous point-in-time recovery. In some cases, this issue is detected, and the latest restorable time will stop moving forward; in other cases, such as the BULK_LOGGED recovery model, the issue is not detected. Some issues get corrected when a snapshot is taken, either by the user or by the system during the daily backup window. It may not be possible to restore to points in time that are affected by these issues. For these reasons, Amazon RDS does not support changing the recovery model of databases.
For Microsoft SQL Server DB instances, the OFFLINE, EMERGENCY, and SINGLE_USER modes are not currently supported. Setting any database to one of these modes will cause the latest restorable time to stop moving ahead for all databases that are managed by the DB instance.
AWS Management Console
To restore a DB instance to a specified time
Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.
In the navigation pane, click DB Instances.
Click Instance Actions, and then click Restore To Point In Time.
The Restore DB Instance window appears.
Click on the Use Custom Restore Time radio button.
Enter the date and time that you wish to restore to in the Use Custom Restore Time text boxes.
Type the name of the restored DB instance in the DB Instance Identifier text box.
Click the Launch DB Instance button.
CLI
To restore a DB instance to a specified time
Use the command
rds-restore-db-instance-to-point-in-timeto create a new database instance.PROMPT>rds-restore-db-instance-to-point-in-time mytargetdbinstance -s mysourcedbinstance-db -r 2009-10-14T23:45:00.000Z
API
To restore a DB instance to a specified time
Call
RestoreDBInstanceToPointInTimewith the following parameters:SourceDBInstanceIdentifier=mysourcedbinstanceTargetDBInstanceIdentifier=mytargetdbinstanceRestoreTime=2009-10-14T23:45:00.000Z
Example
https://rds.amazonaws.com/ ?Action=RestoreDBInstanceToPointInTime &SourceDBInstanceIdentifier=mysourcedbinstance &TargetDBInstanceIdentifier=mytargetdbinstance &RestoreTime=2009-10-14T23:45:00.000Z &SignatureVersion=2 &SignatureMethod=HmacSHA256 &Timestamp=2009-10-15T17%3A48%3A21.746Z &AWSAccessKeyId=<AWS Access Key ID> &Signature=<Signature>
