Backup Retention for a Terminated Database

Recovery Service supports data recovery from accidental or malicious damages, and also provides you with options to retain backups after terminating a database.

In the OCI Console, while enabling automatic backups for a database, you can choose any one of the following options to retain protected database backups prior to terminating your database.
  • Retain backups according to the protection policy retention period - After you terminate a database, Recovery Service will continue to retain backups for period defined in the associated protection policy.
  • Retain backups for 72 hours, then delete - Recovery Service will retain backups for a period of 72 hours (3-days) after you terminate a database.

In the case of accidental or malicious damages to a database, Recovery Service supports recovery from backups for a period of 72 hours (3-days).

When you terminate a source database or if you disable automatic backups for the database, Recovery Service automatically schedules the deletion of the associated protected database resource and its backups.

After you terminate a source database, the associated protected database resource enters the Delete Scheduled state, and remains in this state for a period of 72 hours (default delay) or until the retention period expires, depending on the option that you have selected to retain backups.

If you disable automatic backups for a database, Recovery Service schedules the deletion of the associated protected database resource and its backups after a 72 hour delay. The protected database enters the Delete Scheduled state.

Recovery Service automatically deletes the protected database resource and the database backups after the scheduled delay ends.
Note

If the retention lock is enabled for the protection policy, then when you terminate a database or disable its automatic backups, Recovery Service will delete the protected database resource and its backups only after the retention period ends. See, Using Retention Lock to Protect Backups to learn about using policy retention lock.