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

标题: ORACLE 11.2.0.4通过数据库传输升级至19.3 [打印本页]

作者: windjack 时间: 2020-11-20 18:15
标题: ORACLE 11.2.0.4通过数据库传输升级至19.3

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

升级步骤略

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)