AWS Aurora Point in time recovery
Restore AWS Aurora from Point in time snapshot (go back to a specific point in time).
These are the Steps
Restoring to point in time snapshot of AWS RDS Aurora (to any time with-in the backup retention period irrespective of the frequency of automated backups).
1. In AWS console, select the old/existing database instance (apidbauu003) and rename the instance to something new (apidbauu003-corrupted).
2. Select the RDS Aurora DB instance (apidbauu003-corrupted).
3. From instance actions, execute “restore to point of time”
4. Use latest restorable time (Default) or use Custom Restore time with-in the backup retention period (14 days any time).
5. Under section “Setting”
a. Enter the “DB instance identifier” name as the old name (apidbauu003).
6. Under section “Network & Security”, verify following
a. VPC
b. Subnet group
c. Publicly Accessible (Default No)
7. Click on button “Launch DB instance”.
8. Verify the new instance created by following step 1-6.
a. Connect to new Aurora instance database using MySQL client utility.
b. Execute sql statement to verify the data for any transaction/master table.