Hi All,
Greetings.
In our SAP Landscape environment, business decided to upgrade to 19c on SLES 15 onto a new server from Oracle 12.1.0.2 which are running on SLES 11 SP3/SP4. Would like know from experts about the Migration and upgrade approach.
Source DB: Oracle 12.1.0.2
Source OS : SLES 11 SP3/SP4
New Server:
Target DB : Oracle 19.5.0.0.0
Target OS: SLES 15 SP1.
Our proposed Plans are :
1) R3load utility by SAP (it's time taking process)
2) RMAN incremental Backups
- On target server SLES 15 SP1 OS (new), install Oracle 19c GRID/RDBMS binaries
- Perform Pre upgrade checks on Source Database (12.1.0.2) by using 19c preupgrade check scripts
- Take RMAN incremental backups and restore into target database 19c
- Apply archive logs till the time of Upgrade window time
- start the database in 'startup upgrade' mode in target server (19c)
- Run the catctl.pl with catupgrade.sql
- Perform the postpatch scripts.
3) Using Physical standby database
- Configure the Physical standby database on Target server with compatibility as 12.1.0.2 (as source)
- sync the standby database
- during upgrade window, break the sync
- Enable flashback and Create a guaranteed restore point
- Convert physical standby into primary
- Restart DB in upgrade mode (read write)
- Execute catupgrd.sql in the server (took 50 Mins)
- Start the DB with normal startup command (open mode)
- Check for invalid objects
- Execute utlrp.sql
- Verify Invalid objects
- Check the DB version and components as well
- Change compatibility parameter to 19.3.0.0.0
Need your advice/suggestions for below points as well.
Is 2 & 3 are the right approaches to follow the Upgrade procedure either in Oracle or SAP?
Is it possible to use dbua.sh or dbua.sap.sh when there is no source DB and Home available in new target server? (i.e to set the SOURCE HOME directory)
Only Manual upgrade is the option in this scenario? If so, could you please share the link or Note for manual upgrade steps. I will also search for the same).
Thanks in advance for your time and help.
Regards,
Prakash