In
Oracle database
Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a proprietary multi-model database management system produced and marketed by Oracle Corporation.
It is a database commonly used for ru ...
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's
data
Data ( , ) are a collection of discrete or continuous values that convey information, describing the quantity, quality, fact, statistics, other basic units of meaning, or simply sequences of symbols that may be further interpreted for ...
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 GUI ...
, 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 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 corporation, multinational computer technology company headquartered in Austin, Texas. Co-founded in 1977 in Santa Clara, California, by Larry Ellison, who remains executive chairman, Oracle was ...
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