Oracle Database - Windows 11.2.0.3 to Linux 11.2.0.4 Standard Edition SE Migrate (on Cloud)

I was recently tasked with a Standard Edition migration from on premise to cloud.

The migration -
1. Source - 11.2.0.3 Windows (2008 x64 Bit)
2. Destination - 11.2.0.4 Oracle Linux 7
3. Database - Standard Edition
4. Db Size - 10GB - 2TB (multiple)
5. Downtime - 6 hours
 
Challenges
 1. No Dataguard possible in Standard Edition
2. No Transportable Tablespaces possible in Standard Edition
3. Export / Import - too slow to run because of parallelism restriction in Standard Edition
4. 11.2.0.3 not supported on  Linux 7 (only 11.2.0.4)
5. Limited B.W available between sites 

Solution(s)
Direct Upgrade Small Database

1. Cold Backup 11.2.0.3
2. Transfer to Linux 
3. Restore on Linux (RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support (Doc ID 1079563.1) 
4. Upgrade Database

• Source Db run utlu112i.sql (and other preqs as in Oracle documentation such as dictionary stats etc). Make fixes as required.
• Backup database and transfer to Linux
• restore database;
• alter database open resetlogs upgrade;
• catupgrd
• start database
• catupst
• Post migration (catupst, utlrp, utlu112s)

Sync Upgrade Big Database
 
1. Setup Intermediate VM on cloud - Linux 6.9
2. Install Linux Linux 6 and Linux 7
3. Setup Standard Edition Dataguard - using scripts to recover database continuously. (Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration (Doc ID 413484.1)    
4. Do final sync of Primary and Standby 
5. Activate Physical Standby and Open it
6. Upgrade the database to 11.2.0.4
7. Migrate (or attach the volume ) to Linux 7

Sync Upgrade Big Database Direct solution

1. Setup DG between 11.2.0.3 Windows and 11.2.0.4 on Linux 7
Mixed Oracle Version support with Data Guard Redo Transport Services (Doc ID 785347.1)    
2. Activate and open reset logs upgrade
3. Follow Upgrade Steps of Small Database