The Flashback Database Feature
Introduction
The Flashback Database is one of the most powerful new features in Oracle 10g coming as a part of Backup & Recovery enhancements.
In this post you can find the result of my research and shared experience about this feature.
What is the Oracle Flashback Database?
Flashback Database is a part of the backup & recovery enhancements in Oracle 10g Database that are called Flashback Features.
The main purpose of Flashback Technology is to let you quickly recover from logical corruptions or user errors.
Oracle Flashback Features include the following:
Flashback DATABASE
Flashback DROP
Flashback TABLE
Flashback QUERY
Flashback VERSIONS QUERY
Flashback TRANSACTION QUERY
What says Oracle’s documentation about the Flashback Database Feature:
Oracle Database Backup and Recovery Basics -
10g Release 2 (10.2) - Chapter 5.1 - Restore Points and Flashback Database: Concepts
Flashback Database enables you to wind your entire database backward in time, reversing the effects of unwanted database changes within a given time window. The effects are similar to database point-in-time recovery.
And:
It is similar to conventional point in time recovery in its effects, allowing you to return a database to its state at a time in the recent past.
And:
Flashback Database can be used to reverse most unwanted changes to a database, as long as the datafiles are intact.
From Oracle Database Concepts - 10g Release 2 (10.2) - Chapter 15 - Backup & Recovery
Oracle Flashback Database lets you quickly recover an Oracle database to a previous time to correct problems caused by logical data corruptions or user errors.
Another quote from Metalink Note 268197.1: New Background Processes In 10g:
- This a new feature introduced in 10g
- Flashbacking a database means going back to a previous database state
- The Flashback Database feature provides a way to quickly revert an entire Oracle database to the state it was in at a past point in time
- This is different from traditional point in time recovery
…
- One can use Flashback Database to back out changes that:
- Have resulted in logical data corruptions
- Are a result of user error
- This feature is not applicable for recovering the database in case of media failure
Thanks.
Introduction
The Flashback Database is one of the most powerful new features in Oracle 10g coming as a part of Backup & Recovery enhancements.
In this post you can find the result of my research and shared experience about this feature.
What is the Oracle Flashback Database?
Flashback Database is a part of the backup & recovery enhancements in Oracle 10g Database that are called Flashback Features.
The main purpose of Flashback Technology is to let you quickly recover from logical corruptions or user errors.
Oracle Flashback Features include the following:
Flashback DATABASE
Flashback DROP
Flashback TABLE
Flashback QUERY
Flashback VERSIONS QUERY
Flashback TRANSACTION QUERY
What says Oracle’s documentation about the Flashback Database Feature:
Oracle Database Backup and Recovery Basics -
10g Release 2 (10.2) - Chapter 5.1 - Restore Points and Flashback Database: Concepts
Flashback Database enables you to wind your entire database backward in time, reversing the effects of unwanted database changes within a given time window. The effects are similar to database point-in-time recovery.
And:
It is similar to conventional point in time recovery in its effects, allowing you to return a database to its state at a time in the recent past.
And:
Flashback Database can be used to reverse most unwanted changes to a database, as long as the datafiles are intact.
From Oracle Database Concepts - 10g Release 2 (10.2) - Chapter 15 - Backup & Recovery
Oracle Flashback Database lets you quickly recover an Oracle database to a previous time to correct problems caused by logical data corruptions or user errors.
Another quote from Metalink Note 268197.1: New Background Processes In 10g:
- This a new feature introduced in 10g
- Flashbacking a database means going back to a previous database state
- The Flashback Database feature provides a way to quickly revert an entire Oracle database to the state it was in at a past point in time
- This is different from traditional point in time recovery
…
- One can use Flashback Database to back out changes that:
- Have resulted in logical data corruptions
- Are a result of user error
- This feature is not applicable for recovering the database in case of media failure
Thanks.
No comments:
Post a Comment