重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 26|回复: 0

[升级] ORACLE 11.2.0.4通过数据库传输升级至19.3

[复制链接]
发表于 2020-11-20 18:15:30 | 显示全部楼层 |阅读模式
ORACLE 11.2.0.4通过数据库传输升级至19.3

<手动升级>

--------------------------------------------------------------------------------------------------------------------

源库:

         OS:Redhad 7.5-64bit (Core)

         Hostname:dbserver

         IP:192.168.133.120

         DB: Enterprise Edition Release 11.2.0.4 - 64bit Production

         ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1

目标库:

         OS:CentOS Linux release 7.8.2003 (Core)

         Hostname:dbserver1

         IP:192.168.133.121

         DB:Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0

         ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1

--------------------------------------------------------------------------------------------------------------------

操作步骤如下:



1.源库进行RMAN导出文件

sql>startup mount;

sql>alter database open readonly;

rman>CONVERT DATABASE ON TARGET PLATFORM CONVERT SCRIPT 'convert.sql' TRANSPORT SCRIPT 'crdb.sql' NEW DATABASE 'newdb' FORMAT '/tmp/%U';



2.目标库创建相关目录

mdkir /u01/app/oracle/oradata/newdb/ -p

mkdir /u01/app/oracle/admin/newdb/adump




3.传输文件spfile,crdb.sql,convert.sql,datafile到目标库

scp /home/oracle/convert.sql /home/oracle/crdb.sql init_tt_00vdiiu2_1_0.ora  192.168.133.120:/home/oracle/convert

scp /u01/app/oracle/oradata/orcl/*.* 192.168.133.120:/u01/app/oracle/oradata/newdb/




4.目标库修改参数文件init_tt_00vdiiu2_1_0.ora和crdb.sql

(略)



5.目标库启动到nomount

sql>startup nomount pfile='/home/oracle/init_tt_00vdiiu2_1_0.ora';

sql>create spfile from pfile='/home/oracle/init_tt_00vdiiu2_1_0.ora';

sql>startup force nomount;

sql>CREATE CONTROLFILE REUSE SET DATABASE "NEWDB" RESETLOGS  ARCHIVELOG

    MAXLOGFILES 16

    MAXLOGMEMBERS 3

    MAXDATAFILES 100

    MAXINSTANCES 8

    MAXLOGHISTORY 292

LOGFILE

  GROUP 1 '/u01/app/oracle/oradata/newdb/redo01.log'  SIZE 50M BLOCKSIZE 512,

  GROUP 2 '/u01/app/oracle/oradata/newdb/redo02.log'  SIZE 50M BLOCKSIZE 512,

  GROUP 3 '/u01/app/oracle/oradata/newdb/redo03.log'  SIZE 50M BLOCKSIZE 512

DATAFILE

  '/u01/app/oracle/oradata/newdb/system01.dbf',

  '/u01/app/oracle/oradata/newdb/sysaux01.dbf',

  '/u01/app/oracle/oradata/newdb/users01.dbf',

  '/u01/app/oracle/oradata/newdb/example01.dbf',

  '/u01/app/oracle/oradata/newdb/undotbs01.dbf'

CHARACTER SET WE8ISO8859P1

;



sql>alter database open resetlogs upgrade;




6.目标库升级到19C

$ORACLE_HOME/bin/dbupgrade

升级步骤略


回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2020-11-28 17:11 , Processed in 0.107479 second(s), 21 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表