Oracle 10.2.0.1 32-bit how cold standby migration upgrades to 10.2.0.5 64-bit

Description

The official recommended migration to the same version, such as: 10.2.0.1 (32) migrated to 10.2.0.1 (64).

Upgrade to 10.2.0.5 (64).

First, the environment introduction

Source Library

Operating system version: OEL5.8 32bit

Database version: 10.2.0.1 32bit

Database SID Name: ORCL

Test Library

Operating system version: OEL5.8 x64

Database version: 10.2.0.5 x64

Database SID Name: ORCL

Second, the Source library

1. Close Source Library

# su-oracle

$ sqlplus/as sysdba;

sql> shutdown immediate;

2. Packaged backup/u01/app/oracle/oradata directory for oradata.tar.gz

3. Packaged backup/u01/app/oracle/product/10.2.0/db_1/dbs directory for dbs.tar.gz

4. Copy the oradata.tar.gz dbs.tar.gz to the test library.

Third, test library

1. Close the test library,

2. Restore the oradata.tar.gz to the/u01/app/oracle/oradata directory

3. Restore the dbs.tar.gz to the/u01/app/oracle/product/10.2.0/db_1/dbs directory

4. Create a standby Pfile file

Description

Because the source and migration libraries have the same directory location as the instance names, the control file and parameter file contents do not need to be rebuilt and modified.

# su-oracle

[Oracle@rman ~]$ Sqlplus/as sysdba;

Sql*plus:release 10.2.0.5.0-production on D25 21:05:39 2013

Copyright (c) 1982, Oracle. All Rights Reserved.

Connected to a idle instance.

Sql> create Pfile from SPFile;

File created.

Sql> quit

Disconnected

5. Modify the Pfile file

#增加如下参数文件

_system_trig_enabled = False

$ vi/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora

orcl.__db_cache_size=448790528

orcl.__java_pool_size=4194304

orcl.__large_pool_size=4194304

orcl.__shared_pool_size=146800640

Orcl.__streams_pool_size=0

*.audit_file_dest= '/u01/app/oracle/admin/orcl/adump '

*.background_dump_dest= '/u01/app/oracle/admin/orcl/bdump '

*.compatible= ' 10.2.0.1.0 '

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

*.control_files= '/u01/app/oracle/oradata/orcl/control01.ctl ', '/u01/app/oracle/oradata/orcl/control02.ctl ', '/ U01/app/oracle/oradata/orc

L/control03.ctl '

*.core_dump_dest= '/u01/app/oracle/admin/orcl/cdump '

*.db_block_size=8192

*.db_domain= '

*.db_file_multiblock_read_count=16

*.db_name= ' ORCL '

*.db_recovery_file_dest= '/u01/app/oracle/flash_recovery_area '

*.db_recovery_file_dest_size=2147483648

*.dispatchers= ' (protocol=tcp) (SERVICE=ORCLXDB) '

*.job_queue_processes=10

*.log_archive_format= '%t_%s_%r.dbf '

*.open_cursors=300

*.pga_aggregate_target=201326592

*.processes=150

*.remote_login_passwordfile= ' EXCLUSIVE '

*.sga_target=605028352

*.undo_management= ' AUTO '

*.undo_tablespace= ' UNDOTBS1 '

*.user_dump_dest= '/u01/app/oracle/admin/orcl/udump '

_system_trig_enabled = False

6. Create spfile files through pfile and boot in upgrade mode

[Oracle@rman ~]$ Sqlplus/as sysdba;

Sql*plus:release 10.2.0.5.0-production on 25 21:18:41 2013

Copyright (c) 1982, Oracle. All Rights Reserved.

Connected to a idle instance.

Sql> create SPFile from Pfile;

File created.

Sql>

Sql> startup upgrade;

ORACLE instance started.

Total System Global area 608174080 bytes

Fixed Size 2022696 bytes

Variable Size 155189976 bytes

Database buffers 448790528 bytes

Redo buffers 2170880 bytes

Database mounted.

Database opened.

Sql>

7. To all objects under the 64-bit platform

Sql> @?/rdbms/admin/utlirp.sql

8. Reconstruction Data Dictionary (10.2.0.5)

sql> @ $ORACLE _home/rdbms/admin/catupgrd.sql

About more than 40 minutes, indicating that there are partially invalid objects, you need to compile these invalid objects.

9. Perform the following process to compile the failure object

Sql> Conn/as sysdba;

Sql> @?/rdbms/admin/utlrp.sql

Open another window to view the execution process, only to 0 to complete.

Sql> SELECT COUNT (*) from obj$ WHERE status in (4, 5, 6);