RAC 11gR2; Guaranteed Restore Points with Flashback Logging Disabled

Restore Points and Guaranteed Restore Points:

Before using flashback database solution to revert any changes made on the database, you can give a name to the SCN or specific Time until which you want to restore. This name you give is called a restore point.
A normal restore point enables you to flash the database back to a restore point within the time period determined by the DB_FLASHBACK_RETENTION_TARGET initialization parameter. A guaranteed restore point enables you to flash the database back deterministically to the restore point regardless of the DB_FLASHBACK_RETENTION_TARGET initialization parameter setting. The guaranteed ability to flash back depends on sufficient space being available in the flash recovery area.
Both normal Restore points and guaranteed restore points are stored in the control file. The main difference is that normal restore points aged out from the control file where a guaranteed restore points never age out of the control file and must be manually dropped. In normal restore point Flashback logs may be deleted in response to space pressure.

A guaranteed restore point combined with the Flashback Database command rewinds the database to its state at the restore point SCN even if the flashback database features in not enabled. If you choose to disable the flashback logging, then you cannot use the flashback database to restore the database to any point from the guaranteed restore point. However, you can flashback to the guaranteed restore point and then use the archive logs to recover to SCNs from the guaranteed restore point until the time you want to recover to.

Guaranteed Restore Points with Flashback Logging Disabled:

When you create a guaranteed restore points and the flashback database is disabled then the first time a data file block is modified Oracle stores an image of the block before the modification in the flashback logs. Later modifications to the same block are not logged again in the flashback logs unless another guaranteed restore point was created after the block was last modified.
This solution can be used when you want to revert database changes made by the application (during an upgrade for example).
In the following example, we will show you how to use Guaranteed Restore Points with Flashback Logging Disabled to revert database changes in a RAC 11gR2 environment.

The example:

Read the complete post here: www.oracle-class.com

Views: 421


You need to be a member of Oracle Community to add comments!

Join Oracle Community

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins



Blog Posts

Oracle Club or Oracle Student Ambassador


My name is Hazem Essam, I am Computer Science student at Arab academy for science, technology and maritime transport (AASTMT) Abu Qir Campus in Alexandria/Egypt, I created an idea due to the experience I want to get it from Oracle in my university and not only mine it will be great to be worldwide and because I am one from the biggest fans of Oracle so I decided to make something different to get new and more experience, enhance my skills and share knowledge, I love to make…


Posted by Hazem Essam on October 27, 2016 at 9:38am

Guide to Successful PubMed XML Conversion

PubMed is an online repository, created and maintained by National Center of Biotechnology (NCBI), at the U.S. National Library for Medicine (NLM). PubMed allows access to databases of indexed citations and abstracts to a wide range of biomedical journals and articles.

If you are an associate publisher, institutional repository or commercial publisher and want to submit articles/journals to PubMed central library you will be…


Posted by Alvaro Dee on October 26, 2016 at 5:30am

Looking to Publish Scientific, Technical and Medical Articles? Take a look!

Digital publishers who are involved in publishing Scientific, Technical and Medical (STM) content follow a very rigorous routine of editing, formatting, and publishing. Primarily, the content is meticulously scanned for grammatical errors and logical inequalities. Then a final draft is made in adherence to the guidelines set by the publishing platform and forwarded to TO BE PUBLISHED’ folder. All articles, papers, and…


Posted by Alvaro Dee on October 21, 2016 at 3:29am

Apple Opens Its First iOS App Development Centre in Italy

Apple aims at making things rounder and sleeker. With iPhone 7 out in the field, Apple is now investing its time and resources in organizing workshops and opening new iOS app development centers to educate people in advanced methods of iOS app building.

Apple’s highlight of the year? It’s first-ever iOS development Centre in Naples!…


Posted by Alvaro Dee on October 20, 2016 at 12:33am

© 2016   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service