upgrade from Oracle Database 18c to 19c

[hoshu_partner]

Hello,

We are planning to upgrade oracle from 18. to oracle 19.

Database size now is more than 10TB, since downtime is quite critical for us,

therefore export and import is not possible, do you have any suggestions how we can achieve this and reduce downtime to minimum?

Requirements are:

1. same hardware(Linux Redhat7)

2. DB: Oracle upgrade from 18.9.0.0 to 19 (maybe 19.8)

3. Downtime minimum

thanks a lot.

Best regards,

Hosyu

[janos_mucsi-besze]

Hi,

I guess you could use the RMAN to export and import the DB. As it is working between different RDBMS releases.

If you have access to MOS then you can read the article:

Migration Of An Oracle Database Across OS Platforms (Generic Platform) (Doc ID 733205.1)

[mamartins]

Please look onto these SAP notes:

2817074 - Oracle Database 19c: Integration in SAP environment
2540847 - SAP Guides for Oracle Database Upgrade
2800001 - Upgrading to Oracle Database 19c (DBUA)
2799981 - Using a Guaranteed Restore Point as Recovery Strategy for an Upgrade Error

Basically, the steps are:

1. Install 19c side-by-side with 18c, then patch it.
2. Stop SAP instance, stop 18c DB and change ORACLE_HOME environment variable to point to 19c
3. mount the database on 19c
4. run DBUA