Updated on 2024-07-04 GMT+08:00

Flashback

Flashback is a part of the database recovery technology. It can be used to selectively cancel the impact of a committed transaction and restore data from incorrect manual operations. Before the flashback technology is used, the committed database modification can be retrieved only by means of restoring backup and PITR. The restoration takes several minutes or even hours. After the flashback technology is used, it takes only seconds to restore the DROP/TRUNCATE data committed in the database through FLASHBACK DROP and FLASHBACK TRUNCATE. In addition, the restoration time is irrelevant to the database size.

  • Astore does not support the flashback function.
  • Standby database instances do not support the flashback function.
  • You can enable the flashback function as required. Note that enabling this function will cause performance deterioration.