本文我们介绍一下升级暨迁移的其他技术

SQL>selectdbms_stats.get_prefs('CONCURRENT')fromdual;DBMS_STATS.GET_PREFS('CONCURRENT')--------------------------------------------------------------------------------FALSESQL>

如果并发收集设置部'FALSE'，进行如下设置

begindbms_stats.set_global_prefs('CONCURRENT','FALSE');end;/2、在源库执行dbupgdiag.sql收集诊断信息

cp dbupgdiag.sql $ORACLE_HOME/rdbms/admin

$sqlplus/assysdbaSQL*Plus:Release11.2.0.4.0ProductionCopyright(c)1982,2013,Oracle.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProductionWiththePartitioning,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsSQL>@?/rdbms/admin/dbupgdiag.sqlEntervaluefor1:/tmpSQL>@?/rdbms/admin/preupgrd.sqlResultsofthechecksarelocatedat:/u01/app/oracle/cfgtoollogs/CDBXF/preupgrade/preupgrade.logPre-UpgradeFixupScript(runinsourcedatabaseenvironment):/u01/app/oracle/cfgtoollogs/CDBXF/preupgrade/preupgrade_fixups.sqlPost-UpgradeFixupScript(runshortlyafterupgrade):/u01/app/oracle/cfgtoollogs/CDBXF/preupgrade/postupgrade_fixups.sql3、在源库11g执行rman备份，这里我们采用压缩备份方式

bakcup_cdbxf.sh

############################################################################

rmantarget/log=/rmanbak/cdbxf/cdbxf11gbak_20190629.log<<EOFrun{ALLOCATECHANNELch01TYPEdisk;ALLOCATECHANNELch02TYPEdisk;ALLOCATECHANNELch03TYPEdisk;ALLOCATECHANNELch04TYPEdisk;backupascompressedbackupsetdatabaseformat'/rmanbak/cdbxf/db_xf11g_full_%U'plusarchivelogformat'/rmanbak/cdbxf/db_xf11g_arch_%U';backupcurrentcontrolfileformat'/rmanbak/cdbxf/db_xf_ctl_%U';RELEASECHANNELch01;RELEASECHANNELch02;RELEASECHANNELch03;RELEASECHANNELch04;}EOF

############################################################################

由于我们采用异机升级方式所以需要将11g的rman备份集拷贝到12c的服务器上

$scpdb_xf11g_*oracle@ip:/rmanbak/cdbxfTheauthenticityofhost''can'tbeestablished.。。。。Areyousureyouwanttocontinueconnecting(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'

$ echo $ORACLE_SID

CDBXF12

$sqlplus/assysdbaSQL*Plus:Release12.1.0.1.0ProductiononCopyright(c)1982,2013,Oracle.Allrightsreserved.Connectedtoanidleinstance.SYS@CDBXF>startupnomountpfile='initCDBRXFora';ORACLEinstancestarted.SYS@CDBXF>8、在rman下连接到AUXLIARY

$exportORACLE_SID=CDBRXF$rmanauxiliary/RecoveryManager:ReleaseCopyright(c)1982,2013,Oracleand/oritsaffiliates.Allrightsreserved.connectedtoauxiliarydatabase:12CXF(notmounted)RMAN>9、使用12c rman执行duplicate

RMAN>connectauxiliary/contentsofMemoryScript:{sqlclone"createspfilefrommemory";}executingMemoryScriptsqlstatement:createspfilefrommemorycontentsofMemoryScript:{shutdowncloneimmediate;startupclonenomount;}executingMemoryScript。。。。executingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAME10、进行升级

SYS@CDBXF>alterdatabaseopenresetlogsupgrade;

$cd$ORACLE_HOME/rdbms/admin$pwd/u01/12.1.0.1/oracle/product/db_1/rdbms/admin$ORACLE_HOME/perl/bin/perlcatctl.pl-n4-l$ORACLE_HOME/diagnosticscatupgrd.sql$ORACLE_HOME/perl/bin/perlcatctl.pl-n4-l$ORACLE_HOME/diagnosticscatupgrd.sql$ORACLE_HOME/perl/bin/perlcatctl.pl-n4-l$ORACLE_HOME/diagnosticscatupgrd.sqlAnalyzingfilecatupgrd.sqlLogfilesin/u01/12.1.0.1/oracle/product/db_1/diagnostics14scriptsfoundinfilecatupgrd.sqlNextpath:catalog.sql32scriptsfoundinfilecatalog.sqlNextpath:catproc.sql37scriptsfoundinfilecatproc.sqlNextpath:catptabs.sql61scriptsfoundinfilecatptabs.sqlNextpath:catpdbms.sql205scriptsfoundinfilecatpdbms.sqlNextpath:catpdeps.sql77scriptsfoundinfilecatpdeps.sqlNextpath:catpprvt.sql260scriptsfoundinfilecatpprvt.sqlNextpath:catpexec.sql26scriptsfoundinfilecatpexec.sqlNextpath:cmpupgrd.sql16scriptsfoundinfilecmpupgrd.sql[Phase0]typeis1with1Filescatupstr.sql[Phase1]typeis1with3Filescdstrt.sqlcdfixed.sqlcdcore.sql[Phase2]typeis1with1Filesora_restart.sql[Phase3]typeis2with18Filescdplsql.sqlcdsqlddl.sqlcdmanage.sqlcdtxnspc.sqlcdenv.sqlcdrac.sqlcdsec.sqlcdobj.sqlcdjava.sqlcdpart.sqlcdrep.sqlcdaw.sqlcdsummgt.sqlcdtools.sqlcdexttab.sqlcddm.sqlcatldr.sqlcdclst.sql[Phase4]typeis1with1Filesora_restart.sqltypeis2with122Filesprvtbpui.plbprvtdput.plbprvtmeta.plbprvtmeti.plbprvtmetu.plbprvtmetb.plbprvtmetd.plbprvtmet2.plbprvtdp.plbprvtbpc.plbprvtbpci.plbprvtbpw.plbprvtbpm.plbprvtbpfi.plbprvtbpf.plbprvtbpp.plbprvtbpd.plbprvtbpdi.plbprvtbpv.plbprvtbpvi.plbprvtdpcr.plbprvtplts.plbprvtpitr.plbprvtreie.plbprvtrwee.plbprvtidxu.plbprvtrcmp.plbprvtchnf.plbprvtedu.plbprvtlsby.plbprvtlsib.plbprvtlssb.plbprvtsmv.plbprvtsma.plbprvtbxfr.plbprvtbord.plbprvtjdbb.plbprvtslrt.plbprvtslxp.plbprvtatsk.plbprvtmntr.plbprvtsmgu.plbprvtdadv.plbprvtadv.plbprvtawr.plbprvtawrs.plbprvtawri.plbprvtash.plbprvtawrv.plbprvtsqlf.plbprvtsqli.plbprvtsqlt.plbprvtautorepi.plbprvtautorep.plbprvtfus.plbprvtmp.plbprvthdm.plbprvtaddm.plbprvtrtaddm.plbprvt_awr_data_cp.plbprvtcpaddm.plbprvtuadv.plbprvtsqlu.plbprvtspai.plbprvtspa.plbprvtratmask.plbprvtspmi.plbprvtspm.plbprvtsmbi.plbprvtsmb.plbprvtfus.plbcatfusrg.sqlprvtwrk.plbprvtsmaa.plbprvtxpln.plbprvtstat.plbprvtstai.plbprvtsqld.plbprvtspcu.plbprvtodm.plbprvtkcl.plbprvtdst.plbprvtcmpr.plbprvtilm.plbprvtpexei.plbprvtpexe.plbprvtcapi.plbprvtfuse.plbprvtfspi.plbprvtpspi.plbprvtdnfs.plbprvtfs.plbprvtadri.plbprvtadr.plbprvtadra.plbprvtadmi.plbprvtutils.plbprvtxsrs.plbprvtsc.plbprvtacl.plbprvtds.plbprvtns.plbprvtdiag.plbprvtkzrxu.plbprvtnacl.plbprvtredacta.plbprvtpdb.plbprvttlog.plbprvtsqll.plbprvtappcont.plbprvtspd.plbprvtspdi.plbprvtpprof.plbprvtsqlm.plbprvtpart.plbprvtrupg.plbprvtrupgis.plbprvtrupgib.plbprvtpstdy.plbprvttsdp.plbprvtqopi.plbprvtlog.plb[Phase34]typeis1with1Filesora_load_with_comp.sql[Phase35]typeis1with1Filesora_restart.sql[Phase36]typeis1with4Filescatmetinsert.sqlcatpcnfg.sqlutluppkg.sqlcatdph.sql

-end-