Online Point-in-Time Recovery (PITR)
You can open a Support ticket, for an online PITR.
The support ticket you open should include the following information:
The name of the database for which you want to do online PITR.
The name of the workspace on which it is running.
The name of the workspace on which you want it restored.
The name you want for the new restored database.
The workspace must be in the same region.
The support team will provide an ETA when they receive your ticket.
Support will copy an online database to a new database name, and the new database will have all the PITR history of the original.
When you find the data you need, you can, for example, copy it back to the original database using
INSERT INTO … SELECT FROM… commands.
This allows you to recover accidentally removed or corrupted data into the original online database while keeping the original data online.
For example, you accidentally deleted all the rows for one customer from a large Sales table.
Last modified: December 5, 2022