Flashback Restoration

Flashback restoration 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.

• The Astore engine supports only the flashback DROP/TRUNCATE 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.

• Flashback Query
  
• Flashback Table
  
• Flashback DROP/TRUNCATE