Wednesday, October 14, 2009

Upgrade database from 10.2.0.2 from 10.2.0.4 using coldbackp

Upgrade database from 10.2.0.2 from 10.2.0.4 using:
Following procedure to upgrade Oracle 10.2.0.2 to 10.2.0.4 using cold backup of 10.2.0.2 database
Step 1: backup database (it is running on 10.2.0.2 version) and control file script
Step 2: create parameter file,dump directories and password file for cloning database (10.2.0.4 version)
Step 3: restore backup in clone database server
Step 4: Login as oracle user in clone database server
Step 5: sqlplus "/as sysdba"
sql> startup nomount

sql>CREATE CONTROLFILE SET DATABASE "testdb" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 30
MAXINSTANCES 1
MAXLOGHISTORY 100
LOGFILE
GROUP 1 '/u01/oradata/log1a.log' SIZE 50M,
GROUP 2 '/u01/oradata/log2a.log' SIZE 50M,
GROUP 3 '/u01/oradata/log3a.log' SIZE 50M,
DATAFILE'/u01/oradata/users.dbf',
'/u01/oradata/tools.dbf',
'/u01/oradata/system01.dbf',
'/u01/oradata/undotbs01.dbf',
'/u01/oradata/sysaux01.dbf'
CHARACTER SET US7ASCII;
/
Control file created.

sql> alter database open resetlogs upgrade;

After that run following scripts
sql>@$ORACLE_HOME/rdbms/admin/catupgrd.sql

The following script was executed for the utility upgrade status check which was successful as well.
SQL> @$ORACLE_HOME/rdbms/admin/utlu102s.sql
Recompile invalid objects run following scripts
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
sql>select * from global_name;
SQL> alter database rename global_name to testdb;

Then check,
SQL> select COMP_NAME,VERSION,STATUS from dba_registry ;

COMP_NAME VERSION STATUS
---------------------------------------- ---------- ---------------------------------
Oracle Database Catalog Views 10.2.0.4.0 VALID
Oracle Database Packages and Types 10.2.0.4.0 VALID
Status must be VALID
if Oracle Database Packages and Types compenent will be in INVALID status we have to run catproc.sql script in upgrade mode.

1 comment:

oracle footnote said...

Hi I am planning to move dev(single instance) database which is version
10.2.0.2.0 size arounbd 2Gb
to another host same os version
the target server has RAC set up
and it has some RAC databses
and ORACLE version 10.2.0.4.0 what steps should i take both are using ASM storage (i can shutdown the source DB)