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. Once your restored database is ready, the support team will update the support ticket with details.

Support will copy an online database to a new database name, and the new database will have all the PITR history of the original. The database will be attached at the latest time available. The last few minutes of data may not be available in the copy. Then, you have to detach the new copy and re-attach it at whatever point in time you want.

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. If you have thousands of customers, you may not want to take the whole database offline to recover these rows. Online PITR allows you to recover the rows while the database stays online.

Last modified: December 5, 2022

Was this article helpful?