Oracle database Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online t ...

s, Flashback tools allow

administrator Administrator or admin may refer to: Job roles Computing and internet * Database administrator, a person who is responsible for the environmental aspects of a database * Forum administrator, one who oversees discussions on an Internet forum * N ...

s and users to view and manipulate past states of an

instance Instantiation or instance may refer to: Philosophy * A modern concept similar to ''participation'' in classical Platonism; see the Theory of Forms * The instantiation principle, the idea that in order for a property to exist, it must be had by ...

's data without (destructively) recovering to a fixed point in time. Compare the functionality of

Oracle LogMiner Oracle LogMiner, a utility provided by Oracle Corporation to purchasers of its Oracle database, provides methods of querying logged changes made to an Oracle database, principally through SQL commands referencing data in Oracle redo logs. A GU ...

, which identifies how and when data changed rather than its state at a given time.

Flash Recovery Area

Flashback requires the Flash Recovery Area (FRA), a storage area that allows Flash Backup and Recovery operations on Oracle databases. DBAs may configure the FRA on an

ASM ASM may refer to: Codes * American Samoa, ISO 3166-1 alpha-3 country code * Asmara International Airport, IATA airport code * Assamese language, ISO 639 language code ''asm'' Organizations * Aare Seeland mobil, a Swiss bus and train operator * Al ...

diskgroup or on local disk. It is a specific area of disk storage that is set aside exclusively for retention of backup components such as datafile image copies, archived redo logs, and control-file autobackup copies. The FRA feature is available from release Oracle 10g onwards.

Availability

Oracle Corporation Oracle Corporation is an American multinational computer technology corporation headquartered in Austin, Texas. In 2020, Oracle was the third-largest software company in the world by revenue and market capitalization. The company sells da ...

advertises ''Flashback Query'' as available in Oracle Express Edition, Standard One Edition, Standard Edition and Enterprise Edition. On the other hand, only users of Oracle Enterprise Edition have access to ''Flashback Features'' (Flashback Table, Flashback Database, Flashback Transaction Query).

External links

* * http://www.orafaq.com/wiki/FRA

References

Oracle software {{database-software-stub