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 modifications can be retrieved only by means of backup/restoration or point-in-time recovery (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 nodes do not support the flashback function.
  • You can enable the flashback function as required. Note that enabling this function will cause performance deterioration.