Guaranteed restore point
In front of any activity on the database ( example UPGRADE / application changes ) over the RMAN backup , in addition to exports and other types of rescue, a fast method (especially then in case of rollback ) to have a consistency point is to create a GUARANTEED RESTORE POINT for a possible rollback database. Requirements : COMPATIBLE parameter must be set to 10.2 or higher in the initialization parameter file of the database. the database must be active in ARCHIVELOG mode . The operation used FLASHBACK DATABASE to bring the database to a guaranteed restore point requires the...