What are the methods provided by oracle to enable us to upgrade Oracle database?
meda Changed status to publish 16/07/2022
And while upgrading an oracle RAC database, you must perform the following steps:
- You should first upgrade the Grid infrastructure (Oracle clusterware and ASM) software.
- prepare for the installation of oracle database software based on instructions from oracle documentation.
- Install the oracle database software using oracle universal installer (OUI).
- Execute the pre-upgrade script found at ORACLE_HOME/rdbms/admin/preupgrd.sql just to preview the types of items that the database upgrade assistant (DBUA) checks.
- Run the root.sh script.
- Finally do the upgrading process using database upgrade assistant (DBUA).
Ezana Answered question 10/07/2022
Oracle has many methods or features to upgrade a database to higher version.
Here below are some of the methods that enables us to upgrade oracle database:
- Data pump
- GoldenGate
- Full transportable export/import
- Transportable tablespace(TTS)
- Manual upgrade
- create table as select
- Database Upgrade assistant (DBUA)
meda Edited answer 05/04/2022