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: 352

Comment

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

Badge

Loading…

Blog Posts

Start a great career in Data Integration with Oracle Training and Certification Courses

Organizations today rely on data integration technologies in order to gain a unified view of data coming from disparate sources for informed and timely decision making. These technologies bring together data from multiple sources and transform them into meaningful and valuable information. Oracle is one of the leading providers of data integration technologies that are widely accepted by organizations all over the world. Oracle training and certification courses in the field of data…

Continue

Posted by Michael Warne on January 25, 2016 at 1:57am

Roll Forward Physical standby database in 12c

As you are aware that rolling forward a physical standby via an incremental SCN backup method is the simplest method of getting your standby database with lag into sync with the primary database. The lag can be due to missing archives on the primary which haven’t been shipped or applied on the standby.

 

With 12c, the roll forward technique is a bit different. In the prior versions, we had to initially take an incremental backup of the primary database from the SCN where the…

Continue

Posted by Shivananda Rao P on January 11, 2016 at 11:37pm

Learn IBM Sterling B2B Integrator Online Training at VirtualNuggets

VirtualNuggets is Offering Instructor Led Live IBM Sterling B2B Integrator Online Training. we are the Industry leader in providing IBM Sterling B2B Integrator Tools Training Services, Offering Corporate Trainings Both In Online and In-House and Online Training for Individuals. VirtualNuggets is Offering Online Training for all IT technologies across the globe. Our IBM Sterling B2B Integrator online training methodology focused on hands on experience of Sterling Integrator. We also arrange…

Continue

Posted by Vasu Buddi on October 9, 2015 at 11:25am

IBM Integration Bus Development Online Training

VirtualNuggets is Offering Instructor Led Live IBM Integration Bus Development. VirtualNuggets is the Industry leader in providing Integration Bus Tools Training Services, Offering Corporate Trainings Both In Online and In-House and Online Training for Individuals. VirtualNuggets is Offering Online Training for all IT technologies across the globe. Our IBM Integration Bus Development online training methodology focused on hands on experience of IBM Integration Bus Development. We also…

Continue

Posted by Vasu Buddi on October 6, 2015 at 4:13am

© 2016   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service