Migrating Oracle 18c To 19c
本文包含了以下两个知识点:
[[email?protected] ~]$ rman target / Recovery Manager: Release 19.0.0.0.0 - Production on Sun May 5 15:47:32 2019 Version 19.3.0.0.0 Copyright (c) 1982,2019,Oracle and/or its affiliates. All rights reserved. connected to target database (not started) RMAN> set dbid 2122265785 executing command: SET DBID RMAN> startup nomount; Oracle instance started Total System Global Area 4294965360 bytes Fixed Size 9144432 bytes Variable Size 771751936 bytes Database Buffers 3506438144 bytes Redo Buffers 7630848 bytes RMAN> restore controlfile from ‘/u02/orabak/controlfile_CDB_19_1‘; Starting restore at 05-MAY-2019 15:48:12 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=773 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete,elapsed time: 00:00:04 output file name=+DATA/CDB/CONTROLFILE/current.257.1007480897 output file name=+FRA/CDB/CONTROLFILE/current.256.1007480897 Finished restore at 05-MAY-2019 15:48:19 RMAN> alter database mount; released channel: ORA_DISK_1 Statement processed 3.2 创建spfile并注册资源RMAN> create spfile=‘+data/cdb/spfilecdb.ora‘ from pfile; Statement processed [[email?protected] ~]$ srvctl add database -db cdb -oraclehome /u01/app/oracle/product/19.0.0/db_1 -pwfile $ORACLE_HOME/dbs/orapwcdb -spfile ‘+DATA/CDB/spfilecdb.ora‘ -dbname cdb -diskgroup data,fra [[email?protected] ~]$ echo ‘SPFILE=‘+DATA/CDB/spfilecdb.ora‘‘ >$ORACLE_HOME/dbs/initcdb.ora 3.3 恢复整个数据库--在rman中运行如下命令进行全库恢复 run { allocate channel c1 device type disk; restore database; recover database; release channel c1; } 恢复完成后,以upgrade方式打开数据库并向temp表空间添加数据文件: RMAN> alter database open resetlogs upgrade; RMAN> alter tablespace temp add tempfile ‘+data‘ size 50M autoextend on next 100m maxsize unlimited; 3.4 执行dbupgrade进行升级操作[[email?protected] ~]$ dbupgrade -u sys Argument list for [/u01/app/oracle/product/19.0.0/db_1/rdbms/admin/catctl.pl] For Oracle internal use only A = 0 Run in c = 0 Do not run in C = 0 Input Directory d = 0 Echo OFF e = 1 Simulate E = 0 Forced cleanup F = 0 Log Id i = 0 Child Process I = 0 Log Dir l = 0 Priority List Name L = 0 Upgrade Mode active M = 0 SQL Process Count n = 0 SQL PDB Process Count N = 0 Open Mode Normal o = 0 Start Phase p = 0 End Phase P = 0 Reverse Order r = 0 AutoUpgrade Resume R = 0 Script s = 0 Serial Run S = 0 RO User Tablespaces T = 0 Display Phases y = 0 Debug catcon.pm z = 0 Debug catctl.pl Z = 0 catctl.pl VERSION: [19.0.0.0.0] STATUS: [Production] BUILD: [RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417] /u01/app/oracle/product/19.0.0/db_1/rdbms/admin/orahome = [/u01/app/oracle/product/19.0.0/db_1] /u01/app/oracle/product/19.0.0/db_1/bin/orabasehome = [/u01/app/oracle/product/19.0.0/db_1] catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.0.0/db_1] Analyzing file /u01/app/oracle/product/19.0.0/db_1/rdbms/admin/catupgrd.sql Log file directory = [/tmp/cfgtoollogs/upgrade20190505160915] catcon::set_log_file_base_path: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20190505160915/catupgrd_catcon_44738.lst] catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20190505160915/catupgrd*.log] files for output generated by scripts catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20190505160915/catupgrd_*.lst] files for spool files,if any Enter Password: Number of Cpus = 4 Database Name = cdb DataBase Version = 18.0.0.0.0 catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/cdb/upgrade20190505160957/catupgrdcdbroot_catcon_44738.lst] catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/cdb/upgrade20190505160957/catupgrdcdbroot*.log] files for output generated by scripts catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/cdb/upgrade20190505160957/catupgrdcdbroot_*.lst] files for spool files,if any Log file directory = [/u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/cdb/upgrade20190505160957] Parallel SQL Process Count (PDB) = 2 Parallel SQL Process Count (CDB$ROOT) = 4 Concurrent PDB Upgrades = 2 Generated PDB Inclusion:[PDB$SEED RHNDB SPWDB] Components in [CDB$ROOT] Installed [APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM SDO XDB XML XOQ] Not Installed [APEX EM MGW ODM RAC WK] ...... Grand Total Time: 2468s [SPWDB] LOG FILES: (/u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/cdb/upgrade20190505160957/catupgrdspwdb*.log) Upgrade Summary Report Located in: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/cdb/upgrade20190505160957/upg_summary.log Time: 1992s For CDB$ROOT Time: 4505s For PDB(s) Grand Total Time: 6497s LOG FILES: (/u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/cdb/upgrade20190505160957/catupgrdcdbroot*.log) Upgrade Summary Report Located in: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/cdb/upgrade20190505160957/upg_summary.log Grand Total Upgrade Time: [0d:1h:48m:17s] 如果源库中存在多个pdb,那么这个升级过程会比较耗时。升级完成后,可以验证所有的组件以升级到19.0.0.0版本,如下图所示: col comp_name for a40 set wrap off set pagesize 999 select comp_name,version,status from dba_registry; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |