Re: How to unrecoverable data deletion
> Users are asking for permanent data deletion that cannot be recovered.
If the binary log is enabled, eg for replication, deletions can be recovered by restoring from a backup then replaying the binary log.
Restoring from a previous backup will restore deleted data. The only way round that is to destroy the backups ... then of course crash recovery will be impossible.
Users who want their data to disappear forever need not to put such data in a database that depends on logs and backups for data integrity.
Subject
Views
Written By
Posted
979
August 18, 2020 08:42PM
Re: How to unrecoverable data deletion
530
August 18, 2020 09:22PM
458
August 25, 2020 08:03AM
487
August 20, 2020 09:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.