oracle11g 11.2.0.3 How to rollback after a failed upgrade

Upgrade Environment:

1, 11.2.0.1 to RAC 11.2.0.2RAC

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 through the Out-of-place upgrade method.

If you find a problem with the upgrade process and need to rollback after the upgrade is complete, we can choose between two fallback options:

1. Restoration of the 11.2.0.1/11.2.0.3 database through a flash-back approach

2. Perform catdwgrd.sql degraded data dictionary database

The following is a brief introduction to restoring the database to 11.2.0.1/11.2.0.3 via the Flash back database

About performing catdwgrd.sql degraded data dictionary see: How to Downgrade from Database 11.2 to Previous release (includes 11.2.0.3-11.2.0.1) [ID883335.1 ]

First, check the upgraded database version (11.2.0.3)

Note:

We've made the database flash point before we upgraded the 11.2.0.3 data dictionary.

Create restore point Upgrade_rollback guarantee Database;flashback

Sql> SELECT NAME, SCN, Time, database_incarnation#, Guarantee_flashback_database, storage_size from V$restore_point W Here 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

--------------------------------------------------------------------------------

Database 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-production11goracle

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