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

windjack

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

升级步骤略