本文我们介绍一下升级暨迁移的其他技术
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;
/
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
bakcup_cdbxf.sh
############################################################################
rman target / log=/rmanbak/cdbxf/cdbxf11gbak_20190629.log <<EOF
run {
ALLOCATE CHANNEL ch01 TYPE disk;
ALLOCATE CHANNEL ch02 TYPE disk;
ALLOCATE CHANNEL ch03 TYPE disk;
ALLOCATE CHANNEL ch04 TYPE disk;
backup as compressed backupset database format '/rmanbak/cdbxf/db_xf11g_full_%U' plus archivelog format '/rmanbak/cdbxf/db_xf11g_arch_%U';
backup current controlfile format '/rmanbak/cdbxf/db_xf_ctl_%U';
RELEASE CHANNEL ch01;
RELEASE CHANNEL ch02;
RELEASE CHANNEL ch03;
RELEASE CHANNEL ch04;
}
EOF
############################################################################
由于我们采用异机升级方式所以需要将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 。。。。
$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 / 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>
$ 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>
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 NEWNAME
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-
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
