Skip to Content
Former Member
Apr 12, 2016 at 08:52 AM

Is it possible to use Guaranteed Restore Points with Oracle 12c upgrades?


When upgrading from e.g. Oracle 10g to 11c I often used Oracle Flashback technology for a fast fallback to the old Oracle release in case tests were negative and the upgrade had to be reverted. Now I thought that upgrading from Oracle 11c to 12c could be also safeguarded by setting an Oracle guaranteed restore point (GRP). Looks like this is no longer possible. Applying the SAP Bundle Patch requires raising the COMPATIBLE parameter, which breaks the GRP:

$ env ORACLE_HOME=$OHRDBMS /oracle/SID/121/sapbundle/SBP_12102160119_201602/catsbp

catsbp - Post-process Installation of SBP 201602.

Copyright (c) 2015, 2016, Oracle and/or its affiliates. All rights reserved.

Log file: $ORACLE_BASE/cfgtoollogs/sqlpatch/SAP201602_APPLY_SID_2016_04_06-10-14-19.log

Connecting to database...

Connecting to database...done.

Executing Datapatch...

Executing Datapatch...failed.

Reason: Failure during prerequisite checks

Loading style sheets...

Loading style sheets...skipped.

Reason: Style sheets already loaded

Recompiling objects with utlrp...

Recompiling objects with utlrp...skipped.

Reason: Objects already compiled

Post-installation of this SAP Bundle Patch is incomplete:

Cause: Datapatch has encountered an error during its prerequisite checks.

No post-installation steps have been executed.

Action: Refer to the log file for more information and resolve the error


Database error:

ORA-00406: COMPATIBLE parameter needs to be or greater ORA-00722: Feature "Editions" [for Statement " create or replace noneditionable view dba_registry_history ( action_time, acion, namespace, version, id, bundle_series, comments ) as select action_time, action, namespace, version, id, bundle_series, comments from registry$history "] at catsbp line 1813

catsbp completed with errors, post-installation of this SAP Bundle

Patch is INCOMPLETE. Refer to the log file


for more information.

Overall Status: INCOMPLETE

Is there any trick by which I can avoid changing the COMPATIBLE parameter? Or is it only possible have a GRP during the Oracle 12c upgrade if I skip the SAP Bundle Patch?