Different Upgrade Methods For Upgrading Your Database (Doc ID 419550.1)

0    780    3

Tags:

👉 本文共约3365个字,系统预计阅读时间或需13分钟。

APPLIES TO:

Oracle Database - Standard Edition - Version 9.2.0.1 to 12.1.0.1 [Release 9.2 to 12.1]
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 19.12.0.0.0 [Release 12.1 to 19]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

GOAL

This note applies to all the database upgrades to 9iR2 and higher.

SOLUTION

The different upgrade methods you can use to upgrade your database to the new Oracle Database 9i release or higher are:

1) AutoUpgrade Tool (Oracle Database 12c Release 2 and higher)
2) Database Upgrade Assistant (DBUA)
3) Manual Upgrade
4) Export/Import
5) Data Copying
6) Golden Gate

1) AutoUpgrade Tool :

AutoUpgrade Tool can be used on upgrading to below Oracle Database releases:

Oracle Database 21c (21.3 and newer)
Oracle Database 19c (19.3 and newer)
Oracle Database 18c (18.5 and newer)
Oracle Database 12c Release 2 (12.2 + DBJAN2019RU and newer)

Oracle Database AutoUpgrade allows DBAs to upgrade one or many databases without human intervention, all with one command and a single configuration file.

Refer: AutoUpgrade Tool (Doc ID 2485457.1)

2) DBUA (Database Upgrade Assistant)

The Database Upgrade Assistant (DBUA) interactively steps you through the upgrade process and configures the database for the new Oracle Database release. The DBUA automates the upgrade process by performing all of the tasks normally performed manually. The DBUA makes appropriate recommendations for configuration options such as tablespaces and redo logs. You can then act on these recommendations. This method is very easy and user friendly. But if any error occurs it will take time to diagnose the error as the upgrade process is done automatically by the upgrade assistant.
For more information, refer to the following link:

本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务,私聊QQ646634621或微信dbaup66,谢谢!
AiDBA后续精彩内容已被站长无情隐藏,请输入验证码解锁本文!
验证码:
获取验证码: 请先关注本站微信公众号,然后回复“验证码”,获取验证码。在微信里搜索“AiDBA”或者“dbaup6”或者微信扫描右侧二维码都可以关注本站微信公众号。

标签:

Avatar photo

小麦苗

学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

您可能还喜欢...

发表回复