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);