Recover terminated transactions by using database or process recoveryįor additional general information about flashback features, see Oracle Database Concepts Besides using it in flashback features, Oracle Database uses undo data to perform these actions: By using flashback features, you can use undo data to query past data or recover from logical damage. Undo data is persistent and survives a database shutdown. For example, if a user runs an UPDATE statement to change a salary from 1000 to 1100, then Oracle Database stores the value 1000 in the undo data. They rely on undo data, which are records of the effects of individual transactions. Oracle Flashback features use the Automatic Undo Management (AUM) system to obtain metadata and historical data for transactions. Roll back a transaction and its dependent transactions while the database remains online Recover tables or rows to a previous point in timeĪutomatically track and archive transactional data changes Perform queries that return metadata that shows a detailed history of changes to the database Oracle Flashback Technology is a group of Oracle Database features that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |