Migrating Oracle 11g R2 To Oracle 19c

生成的trace文件路径可以通过alter日志进行查看，然后根据实际情况进行修改。修改完后在目标端执行，如下：

[[email?protected] ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 28 19:14:24 2019
Version 19.3.0.0.0

Copyright (c) 1982,2019,Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> CREATE CONTROLFILE REUSE DATABASE "RHNDB" RESETLOGS  NOARCHIVELOG
  2      MAXLOGFILES 16
  3      MAXLOGMEMBERS 3
  4      MAXDATAFILES 100
  5      MAXINSTANCES 8
  6      MAXLOGHISTORY 2920
  7  LOGFILE
  8    GROUP 1 ‘+DATA/rhndb/redo01.log‘  SIZE 50M BLOCKSIZE 512,9    GROUP 2 ‘+DATA/rhndb/redo02.log‘  SIZE 50M BLOCKSIZE 512,10    GROUP 3 ‘+DATA/rhndb/redo03.log‘  SIZE 50M BLOCKSIZE 512
 11  -- STANDBY LOGFILE
 12  DATAFILE
 13    ‘+DATA/RHNDB/DATAFILE/system.258.1006801423‘,14    ‘+DATA/RHNDB/DATAFILE/undotbs1.257.1006801423‘,15    ‘+DATA/RHNDB/DATAFILE/users.261.1006801653‘,16    ‘+DATA/RHNDB/DATAFILE/sysaux.260.1006801653‘,17    ‘+DATA/RHNDB/DATAFILE/spacewalk.259.1006801653‘
 18  CHARACTER SET AL32UTF8;

Control file created.

9、以resetlogs方式打开数据库并创建临时表空间

SQL> startup mount
ORACLE instance started.

Total System Global Area 3221222464 bytes
Fixed Size                  8901696 bytes
Variable Size             671088640 bytes
Database Buffers         2533359616 bytes
Redo Buffers                7872512 bytes
Database mounted.
SQL> alter database open resetlogs;

Database altered.
SQL> alter tablespace temp add tempfile ‘+data‘ size 50M autoextend on next 100m maxsize unlimited;

Tablespace altered.

10、重启数据库至upgrade模式

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup upgrade
ORACLE instance started.

Total System Global Area 3221222464 bytes
Fixed Size                  8901696 bytes
Variable Size             671088640 bytes
Database Buffers         2533359616 bytes
Redo Buffers                7872512 bytes
Database mounted.
Database opened.

使用dbupgrade进行升级操作：

[[email?protected] ~]$ dbupgrade -u sys

此命令执行完后，会重启数据库至migrate模式，然后运行下面的命令即可完成升级。

SQL> @?/rdbms/admin/utlirp.sql
SQL> shutdown immediate
SQL> startup
SQL> @?/rdbms/admin/utlrp.sql

（编辑：淮北站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!