Discussions
Categories
- 385K All Categories
- 2.6K Data
- 582 Big Data Appliance
- 2K Data Science
- 452.1K Databases
- 222.3K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 575 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 575 SQLcl
- 4K SQL Developer Data Modeler
- 187.7K SQL & PL/SQL
- 21.5K SQL Developer
- 12 Data Integration
- 12 GoldenGate
- 297.7K Development
- 3 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 294.3K Development Tools
- 118 DevOps
- 3.1K QA/Testing
- 646.4K Java
- 30 Java Learning Subscription
- 37K Database Connectivity
- 185 Java Community Process
- 107 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 172 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 583 LiveLabs
- 41 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 191 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 240 Portuguese
Migration and upgrade to 19c from 12.1.0.2 on new server with SLES 15 SP1
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
Answers
-
I would definitely go with option #3. It is the easiest and the one with the least down time. I would suggest that you use AutoUpgrade to do the upgrade instead of the manual upgrade. It is easier and it does support having source Oracle Home and target Oracle Home on two different servers. Take a look at the Database Upgrade Quick Start Guide which shows how to get started with the tool. In your case you would execute "analyze" and "fixups" mode on the source system and wait for the changes to be applied on the standby. Then you break the connection and you can eventually do the upgrade using the "upgrade" mode. In your configuration file instead of specifying a "target_home" you should specify "target_version" instead.
Regards,
Daniel