Two rollback methods after Oracle 11g 11.2.0.3 upgrade failure

Upgrade environment:

1. RAC 11.2.0.1 to RAC 11.2.0.2

2. RAC 11.2.0.1 to RAC 11.2.0.3

3. RAC 11.2.0.2 to RAC 11.2.0.3

The above DB software is upgraded using the out-of-place upgrade method.

If there is a problem with the upgrade process after the upgrade is completed, you can select either of the following methods:
1. Restore the database to 11.2.0.1/11.2.0.3 by flashing back to the database
2. Run catdwgrd. SQL to downgrade the data dictionary.

The following describes how to restore a database to 11.2.0.1/11.2.0.3 through flash back.

For details about How To execute catdwgrd. SQL Downgrade data dictionary, see: How To Downgrade From Database 11.2 To Previous Release (supported des 11.2.0.3-11.2.0.1) [ID883335.1]

1. Check the upgraded database version (11.2.0.3)

Note:

We have implemented a database crash point before upgrading the data dictionary of 11.2.0.3.

Create restore point upgrade_rollback guarantee flashback database;

SQL> SELECT NAME, SCN, TIME, DATABASE_INCARNATION #, GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE FROM V $ RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE = 'yes ';

NAME
--------------------------------------------------------------------------------
SCN
----------
TIME
---------------------------------------------------------------------------
DATABASE_INCARNATION # GUA STORAGE_SIZE
------------------------------------
UPGRADE_ROLLBACK
1227989
31-MAR-12 10.21.06.000000000 AM
1 YES 16384000

Check version information

SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
RACDB

SQL> select * from v $ version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
PL/SQL Release 11.2.0.3.0-Production
CORE 11.2.0.3.0 Production
TNS for IBM/aix risc System/6000: Version 11.2.0.3.0-Production
NLSRTL Version 11.2.0.3.0-Production

SQL> col COMP_ID format a10
SQL> col COMP_NAME format a30
SQL> select comp_id, comp_name, version, status, modified from dba_registry

SQL>/

COMP_ID COMP_NAME VERSION STATUS MODIFIED
-------------------------------------------------------------------------------------------------------------------
APEX Oracle Application Express 3.2.1.00.12 INVALID 31-MAR-2012 12:04:14
EM Oracle Enterprise Manager 11.2.0.3.0 VALID 31-MAR-2012 11:36:51
ORDIM Oracle Multimedia 11.2.0.3.0 VALID 31-MAR-2012 12:04:14
XDB Oracle XML Database 11.2.0.3.0 VALID 31-MAR-2012 12:04:13
EXF Oracle Expression Filter 11.2.0.3.0 VALID 31-MAR-2012 12:04:12
RUL Oracle Rules Manager 11.2.0.3.0 VALID 31-MAR-2012 12:04:13
OWM Oracle Workspace Manager 11.2.0.3.0 VALID 31-MAR-2012 12:04:11
CATALOG Oracle Database Catalog Views 11.2.0.3.0 VALID 31-MAR-2012 12:04:11
CATPROC Oracle Database Packages and T 11.2.0.3.0 VALID 31-MAR-2012 12:04:11
Ypes

JAVAVM JServer JAVA Virtual Machine 11.2.0.3.0 VALID 31-MAR-2012 12:04:11
XML Oracle XDK 11.2.0.3.0 VALID 31-MAR-2012 12:04:11
CATJAVA Oracle Database Java Packages 11.2.0.3.0 VALID 31-MAR-2012 12:04:11
RAC Oracle Real Application Cluste 11.2.0.3.0 VALID 31-MAR-2012 12:04:14
Rs

13 rows selected.

1 2 Next Page