Oracle10g到11g的数据库迁移实验

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了Oracle10g到11g的数据库迁移实验，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含4675字，纯文字阅读大概需要7分钟。

内容图文

用rman来实现，实现跨库跨服务器的迁移 10g服务器：192.168.182.133 Oracle 10.2.0.1.0 RHEL 4 32bit 11g服务器： 服务器192.168

用rman来实现，实现跨库跨服务器的迁移
10g服务器：192.168.182.133 Oracle 10.2.0.1.0 RHEL 4 32bit

11g服务器：
服务器192.168.182.131 OEL5.8_32 Oracle 11.2.0.1.0 32bit
[oracle@oelr5u8-1 admin]$ uname -a
Linux oelr5u8-1.localdomain 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST 2012 i686 i686 i386 GNU/Linux

SYS@PROD>select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

将服务器192.168.182.133上的10g库PROD2迁移至服务器192.168.182.131上的11g数据库PROD4

1. Preparations
1.1 setup auxiliary instance
1.1.1 orapwd
on 131-源库服务器
cd $ORACLE_HOME/dbs
orapwd file=orapwPROD4 password=oracle

1.1.2 export ORACLE_SID=PROD4
on 131

1.1.3 mkdir
on 131
mkdir -p /u01/app/oracle/admin/PROD4/{a,b,c,u}dump
mkdir -p /u01/app/oracle/oradata/PROD4/

1.1.4 pfile
on 133-目标库服务器
cd $ORACLE_HOME/dbs
sqlplus / as sysdba
create pfile from spfile;

scp initPROD2.ora oelr5u8-1:/u01/app/oracle/product/11.2.0/db_1/dbs/initPROD4.ora

on 131
cd cd $ORACLE_HOME/dbs
vi initPROD4.ora
PROD2.__db_cache_size=167772160
PROD2.__java_pool_size=4194304
PROD2.__large_pool_size=4194304
PROD2.__shared_pool_size=100663296
PROD2.__streams_pool_size=0
*.aq_tm_processes=1
*.audit_file_dest='/u01/app/oracle/admin/PROD2/adump'
*.background_dump_dest='/u01/app/oracle/admin/PROD2/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/PROD2/control01.ctl','/u01/app/oracle/oradata/PROD2/control02.ctl','/u01/app/oracle/oradata/PROD2/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/PROD2/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='PROD2'
*.dispatchers=''
*.job_queue_processes=10
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.session_cached_cursors=200
*.sga_target=285212672
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/PROD2/udump'

改为符合辅助实例和11g数据库的要求

PROD4.__db_cache_size=167772160
PROD4.__java_pool_size=4194304
PROD4.__large_pool_size=4194304
PROD4.__shared_pool_size=100663296
PROD4.__streams_pool_size=0
*.aq_tm_processes=1
*.audit_file_dest='/u01/app/oracle/admin/PROD4/adump'
*.control_files='/u01/app/oracle/oradata/PROD4/control01.ctl','/u01/app/oracle/oradata/PROD4/control02.ctl','/u01/app/oracle/oradata/PROD4/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='PROD4'
*.dispatchers=''
*.job_queue_processes=10
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.session_cached_cursors=200
*.sga_target=285212672
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
## for auxiliary instance
DB_FILE_NAME_CONVERT='PROD2','PROD4'
LOG_FILE_NAME_CONVERT='PROD2','PROD4'

1.1.5 startup nomount on auxiliary instance
on 131

export ORACLE_SID=PROD4
sqlplus / as sysdba
create spfile from pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initPROD4.ora';

1.1.6 setup listener and tnsnames
on 133
vi tnsnames.ora
add:
PROD4_oelr5u8-1=
(description=
(address=(protocol=tcp)(host=oelr5u8-1)(port=1521))
(connect_data=
(server=dedicated)
(service_name=PROD4)
)
)

on 131
vi listener.ora
add into sid_list_listener:
(sid_desc=
(global_dbname=PROD4)
(oracle_home=/u01/app/oracle/product/11.2.0/db_1)
(sid_name=PROD4
)

lsnrctl start

vi tnsnames.ora
PROD2_odd-oelr4u8 =
(description =
(address = (protocol = tcp)(host = odd-oelr4u8)(port = 1521))
(connect_data =
(server = dedicated)
(service_name = PROD2)
)
)

1.2 check target database's backup
on 133
ensure that archive log mode is on

rman target /
list backup of database;
note: cannot use backup as compressed backupset... errors will be reported when duplicating

2. duplicate

rman target sys/oracle@PROD2 auxiliary sys/oracle@PROD4_oelr5u8-1

Recovery Manager: Release 10.2.0.1.0 - Production on Sat Apr 5 15:37:35 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: PROD2 (DBID=1490667694)
connected to auxiliary database: PROD4 (not mounted)

RMAN> duplicate target database to PROD4;

内容总结

以上是互联网集市为您收集整理的Oracle10g到11g的数据库迁移实验全部内容，希望文章能够帮你解决Oracle10g到11g的数据库迁移实验所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---