重庆分公司
重庆分公司，新征程启航
为企业提供网站建设、域名注册、服务器等服务
Oracle12c迁移-某风险报告类系统升级暨迁移至12c-3-创新互联
本文我们介绍一下升级暨迁移的其他技术
rman升级的主要步骤
1、在源库11.2，检查获取统计对象的并发收集设置
SQL> select dbms_stats.get_prefs('CONCURRENT') from dual;
DBMS_STATS.GET_PREFS('CONCURRENT')
--------------------------------------------------------------------------------
FALSE
SQL>
如果并发收集设置部'FALSE'，进行如下设置
begin
dbms_stats.set_global_prefs('CONCURRENT','FALSE');
end;
/
2、在源库执行dbupgdiag.sql收集诊断信息
cp dbupgdiag.sql $ORACLE_HOME/rdbms/admin
$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> @?/rdbms/admin/dbupgdiag.sql Enter value for 1: /tmp SQL> @?/rdbms/admin/preupgrd.sql Results of the checks are located at: /u01/app/oracle/cfgtoollogs/CDBXF/preupgrade/preupgrade.log Pre-Upgrade Fixup Script (run in source database environment): /u01/app/oracle/cfgtoollogs/CDBXF/preupgrade/preupgrade_fixups.sql Post-Upgrade Fixup Script (run shortly after upgrade): /u01/app/oracle/cfgtoollogs/CDBXF/preupgrade/postupgrade_fixups.sql
3、在源库11g执行rman备份，这里我们采用压缩备份方式
bakcup_cdbxf.sh
############################################################################
rman target / log=/rmanbak/cdbxf/cdbxf11gbak_20190629.log <############################################################################
4、将备份集传输到目标服务器上
由于我们采用异机升级方式所以需要将11g的rman备份集拷贝到12c的服务器上
$ scp db_xf11g_* oracle@ip:/rmanbak/cdbxf The authenticity of host '' can't be established. 。。。。 Are you sure you want to continue connecting (yes/no)? yes 。。。。5、在12c数据库上创建密码文件
$ORACLE_HOME/bin/orapwd file=orapwCDBXFpassword=oracle
6、准备12c的参数文件
db_name=CDBXF12
*.compatible='12.1.0.0.0'
*.db_block_size=16384
*.db_file_name_convert='+data/cdbrxf','+data/cdbxf12'
*.log_file_name_convert='+data/cdbxf','+data/cdbxf12'
control_files='+data/cdbxf12/control01.ctl'
7、将辅助实例启动到nomount状态
$ echo $ORACLE_SID
CDBXF12
$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SYS@ CDBXF >startup nomount pfile='initCDBRXFora'; ORACLE instance started. SYS@ CDBXF>8、 在rman下连接到AUXLIARY
$ export ORACLE_SID=CDBRXF $ rman auxiliary / Recovery Manager: Release Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. connected to auxiliary database: 12CXF (not mounted) RMAN>9、使用12c rman执行duplicate
RMAN> connect auxiliary / contents of Memory Script: { sql clone "create spfile from memory"; } executing Memory Script sql statement: create spfile from memory contents of Memory Script: { shutdown clone immediate; startup clone nomount; } executing Memory Script 。。。。 executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME10、进行升级
SYS@ CDBXF >alter database open resetlogs upgrade;$ cd $ORACLE_HOME/rdbms/admin $ pwd /u01/12.1.0.1/oracle/product/db_1/rdbms/admin $ORACLE_HOME/perl/bin/perl catctl.pl -n 4 -l $ORACLE_HOME/diagnostics catupgrd.sql $ORACLE_HOME/perl/bin/perl catctl.pl -n 4 -l $ORACLE_HOME/diagnostics catupgrd.sql $ORACLE_HOME/perl/bin/perl catctl.pl -n 4 -l $ORACLE_HOME/diagnostics catupgrd.sql Analyzing file catupgrd.sql Log files in /u01/12.1.0.1/oracle/product/db_1/diagnostics 14 scripts found in file catupgrd.sql Next path: catalog.sql 32 scripts found in file catalog.sql Next path: catproc.sql 37 scripts found in file catproc.sql Next path: catptabs.sql 61 scripts found in file catptabs.sql Next path: catpdbms.sql 205 scripts found in file catpdbms.sql Next path: catpdeps.sql 77 scripts found in file catpdeps.sql Next path: catpprvt.sql 260 scripts found in file catpprvt.sql Next path: catpexec.sql 26 scripts found in file catpexec.sql Next path: cmpupgrd.sql 16 scripts found in file cmpupgrd.sql [Phase 0] type is 1 with 1 Files catupstr.sql [Phase 1] type is 1 with 3 Files cdstrt.sql cdfixed.sql cdcore.sql [Phase 2] type is 1 with 1 Files ora_restart.sql [Phase 3] type is 2 with 18 Files cdplsql.sql cdsqlddl.sql cdmanage.sql cdtxnspc.sql cdenv.sql cdrac.sql cdsec.sql cdobj.sql cdjava.sql cdpart.sql cdrep.sql cdaw.sql cdsummgt.sql cdtools.sql cdexttab.sql cddm.sql catldr.sql cdclst.sql [Phase 4] type is 1 with 1 Files ora_restart.sql type is 2 with 122 Files prvtbpui.plb prvtdput.plb prvtmeta.plb prvtmeti.plb prvtmetu.plb prvtmetb.plb prvtmetd.plb prvtmet2.plb prvtdp.plb prvtbpc.plb prvtbpci.plb prvtbpw.plb prvtbpm.plb prvtbpfi.plb prvtbpf.plb prvtbpp.plb prvtbpd.plb prvtbpdi.plb prvtbpv.plb prvtbpvi.plb prvtdpcr.plb prvtplts.plb prvtpitr.plb prvtreie.plb prvtrwee.plb prvtidxu.plb prvtrcmp.plb prvtchnf.plb prvtedu.plb prvtlsby.plb prvtlsib.plb prvtlssb.plb prvtsmv.plb prvtsma.plb prvtbxfr.plb prvtbord.plb prvtjdbb.plb prvtslrt.plb prvtslxp.plb prvtatsk.plb prvtmntr.plb prvtsmgu.plb prvtdadv.plb prvtadv.plb prvtawr.plb prvtawrs.plb prvtawri.plb prvtash.plb prvtawrv.plb prvtsqlf.plb prvtsqli.plb prvtsqlt.plb prvtautorepi.plb prvtautorep.plb prvtfus.plb prvtmp.plb prvthdm.plb prvtaddm.plb prvtrtaddm.plb prvt_awr_data_cp.plb prvtcpaddm.plb prvtuadv.plb prvtsqlu.plb prvtspai.plb prvtspa.plb prvtratmask.plb prvtspmi.plb prvtspm.plb prvtsmbi.plb prvtsmb.plb prvtfus.plb catfusrg.sql prvtwrk.plb prvtsmaa.plb prvtxpln.plb prvtstat.plb prvtstai.plb prvtsqld.plb prvtspcu.plb prvtodm.plb prvtkcl.plb prvtdst.plb prvtcmpr.plb prvtilm.plb prvtpexei.plb prvtpexe.plb prvtcapi.plb prvtfuse.plb prvtfspi.plb prvtpspi.plb prvtdnfs.plb prvtfs.plb prvtadri.plb prvtadr.plb prvtadra.plb prvtadmi.plb prvtutils.plb prvtxsrs.plb prvtsc.plb prvtacl.plb prvtds.plb prvtns.plb prvtdiag.plb prvtkzrxu.plb prvtnacl.plb prvtredacta.plb prvtpdb.plb prvttlog.plb prvtsqll.plb prvtappcont.plb prvtspd.plb prvtspdi.plb prvtpprof.plb prvtsqlm.plb prvtpart.plb prvtrupg.plb prvtrupgis.plb prvtrupgib.plb prvtpstdy.plb prvttsdp.plb prvtqopi.plb prvtlog.plb [Phase 34] type is 1 with 1 Files ora_load_with_comp.sql [Phase 35] type is 1 with 1 Files ora_restart.sql [Phase 36] type is 1 with 4 Files catmetinsert.sql catpcnfg.sql utluppkg.sql catdph.sql-end-
文章题目：Oracle12c迁移-某风险报告类系统升级暨迁移至12c-3-创新互联
转载来于：http://cqcxhl.cn/article/didsdh.html