Database Migration and Upgrade from Oracle 11g to 12c.
Hello Friends, hope you are
doing well.
I recently did a database
migration to new hardware/servers and then upgraded from 11.2.0.4 to 12.1.0.2.
For this migration and upgrade
activity, followed the below approach to minimize the downtime as possible.
This migration and upgrade activity
can be broadly split into two phases.
1. Migrate
the database to new hardware/servers. (e.g. OS version RHEL 6.x to 7.x)
2. Upgrade
the database from 11g to 12c
1.
Migrate
the database to new servers
·
Setup two node Oracle 12c cluster in new servers
The below
Oracle document can be referred to know how to setup Oracle 12c Cluster in new
servers:
·
Install RDBMS software 11.2.0.4 in new servers.
This 11g
Oracle home is needed to setup physical standby database first for migrating
the 11g database from old server to this new server.
·
Setup a Physical standby database 11.2.0.4 in
new servers so that both the databases in old and new servers are in synch with
Data guard replication
The below
Oracle document can be referred to know how to create Oracle 11g physical
standby database and how to perform database switchover (Database role
transitions):
·
During the change window, activate physical
standby database so that it will become primary database (Read and Write mode).
·
Now the 11g database is up and running in new
servers
2.
Upgrade
database from 11g to 12c in new servers
·
Install Oracle 12c RDBMS software in new servers.
·
Now upgrade this 11.2.0.4 database to 12c, in
new servers (This 11g database has been migrated to this new servers as
explained in above steps).
By default upgraded database will be Non-CDB.
The below
Oracle document can be referred to know how to upgrade the database to Oracle
12c:
References:
·
· Oracle 12c Database Upgrade Guide, for upgrading database to 12c
· Oracle 11gR2 - Data Guard Concepts and Administration
No comments:
Post a Comment