http://debianws.lexgopc.com/wiki143/index.php?action=history&feed=atom&title=Oracle_FlashbackOracle Flashback - Revision history2026-10-26T19:02:20ZRevision history for this page on the wikiMediaWiki 1.43.1http://debianws.lexgopc.com/wiki143/index.php?title=Oracle_Flashback&diff=3658354&oldid=previmported>SchlurcherBot: Bot: http → https2025-06-24T02:02:27Z<p>Bot: http → https</p>
<p><b>New page</b></p><div>{{Multiple issues|<br />
{{refimprove|date=January 2014}}<br />
{{notability|date=January 2014}}<br />
}}<br />
<br />
In [[Oracle database]]s, '''Flashback''' tools allow [[database administrator|administrator]]s and users to view and manipulate past states of an [[database instance|instance]]'s [[data]] without (destructively) [[data recovery|recover]]ing to a fixed point in time.<br />
<br />
Compare the functionality of [[Oracle LogMiner]], which identifies how and when data changed rather than its state at a given time.<br />
<br />
==Flash Recovery Area==<br />
<br />
Flashback requires the '''Flash Recovery Area''' ('''FRA'''),<ref><br />
{{cite book<br />
|last1= Alapati<br />
|first1= Sam<br />
|last2= Kuhn<br />
|first2= Darl<br />
|last3= Nanda<br />
|first3= Arup<br />
|title= RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach<br />
|url= https://books.google.com/books?id=qISYkSBV2hgC<br />
|publisher= Apress<br />
|date= 2007<br />
|page= 17<br />
|isbn= 9781430203056<br />
|accessdate= 2015-03-18<br />
|quote= You must have activated a flash recovery area in order to avail or the flash database of the guaranteed restore point feature.<br />
}}<br />
</ref><br />
a storage area that allows Flash Backup and Recovery operations on Oracle databases. DBAs may configure the FRA on an [[Automatic Storage Management|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.<br />
<br />
The FRA feature is available from release Oracle 10g onwards.<br />
<br />
== Availability ==<br />
{{As of | 2013}} [[Oracle Corporation]] 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).<ref><br />
{{cite web<br />
|url = https://www.oracle.com/us/products/database/enterprise-edition/comparisons/index.html<br />
|title = Oracle database - Comparisons<br />
|publisher = Oracle Corporation<br />
|accessdate = 2013-07-11<br />
}}<br />
</ref><br />
<br />
== External links ==<br />
<br />
* {{cite web<br />
|url= https://www.oracle.com/technetwork/database/features/availability/flashback-overview-082751.html<br />
|title= Oracle Flashback Technology<br />
|accessdate= 2011-06-10<br />
|date= <br />
|year= <br />
|work= Oracle Technology Network<br />
|publisher= Oracle Corporation<br />
|doi= <br />
|archiveurl= <br />
|archivedate= <br />
|quote= <br />
}}<br />
* https://www.orafaq.com/wiki/FRA<br />
<br />
== References==<br />
{{reflist}}<br />
<br />
[[Category:Oracle software]]<br />
<br />
<br />
{{database-software-stub}}</div>imported>SchlurcherBot