Step by step to upgrade to 11gr2 and downgrade

1. Upgrade:
with 10.2.0.4 environment and binary,

SQL> create restore point iam10204 guarantee flashback database;
SQL>  @$11g_ORACLE_HOME/rdbms/admin/utlu112i.sql
SQL> shutdown immediate

with 11.2.0.1 environment and binary,

SQL> startup upgrade
SQL> set time on
SQL> spool upgrade.log
SQL> @catupgrd.sql
SQL> spool off
$ sqlplus “/as sysdba”
SQL> startup
SQL> @utlu112s.sql
SQL> @catuppst.sql
SQL> @utlrp.sql

2. Downgrade:
Option 1: if you didn’t have new use data loaded after upgrade, using flashback
with 11.2.0.1 environment and binary,

SQL> startup mount
SQL> flashback database to restore point iam10204;
SQL> SHUTDOWN IMMEDIATE

with 10.2.0.4 environment and binary,

SQL> startup mount
SQL> alter database open resetlogs;
SQL> drop restore point iam10204;

Option 2: traditional downgrade
–To improve the downgrade performance

SQL> drop restore point iam10204;

with 11.2.0.1 environment and binary,

SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP DOWNGRADE
SQL> SPOOL downgrade.log
SQL> @catdwgrd.sql    ~50 minutes
SQL> SPOOL OFF
SQL> SHUTDOWN IMMEDIATE

with 10.2.0.4 environment and binary,

SQL> STARTUP UPGRADE
SQL> SPOOL reload.log
SQL> @catrelod.sql      ~34 minutes
SQL> SPOOL OFF
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
SQL> @utlrp.sql

For Complete Checklist for Manual Upgrades to 11gR2 Reference metalink Doc.: 837570.1

Advertisements

About Alex Zeng
I would be very happy if this blog can help you. I appreciate every honest comments. Please forgive me if I'm too busy to reply your comments in time.

2 Responses to Step by step to upgrade to 11gr2 and downgrade

  1. alexzeng says:

    Run utlu112i.sql got ORA-06512 — Oracle unpublished Doc ID 884112.1
    Reference:
    http://davidalejomarcos.wordpress.com/2010/05/07/ora-06512-executing-utlu112i-sql/
    -Alex

  2. dominical says:

    Hi Alex.

    Thanks for your blog.
    1) I did not know you could do “flashback database to restore point iam10204”, I should try it, never try like that.

    2) Somehow, you did not mention about upgrade of the timezone.
    if I do
    select * from V$timezone_file, if it is not 11, like mine db is 4. so I have to do some kind of upgrade of timezone.

    Dominica L.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: