In this article, we can upgrade the 11g database to 12c with the help of DataGaurd

Primary DB Name Standby DB Name Database Version Upgrade Version
UPGDB UPGDB 11.2.0.4.0 12.1.0.2.0

Step 1: Install 12.1.0.2 binaries on both Primary and Standby Server.

Step 2: Shut down Primary Database.

Step 3: Shut down Standby Database.

Step 4: At standby database server copy init file and password file to new home

Step 5: Copy listener.ora and tnsnames.ora file to new Oracle home

Step 6: Change an oracle_home value in a listener.ora file

Step 7: Start database in mount stage  with new home exported

Remember database is not still upgraded so trying open database will result in the following error :

Step 8: Upgrade Primary database with DBUA

Select a database and click next.

We can check more details by selecting a particular prerequisite and clicking on more details.

It shows we can remove em repository prior to up gradation. Run emremove file to remove em repository.

After successful removal of em repository click next.

select checkbox according to your requirement or keep them default and click on next.

Click on next.

Click on next.

Select listeners, you want to migrate to new Oracle home and click next.

Select backup policy in case of upgrade failure and click on next.

Check database upgrades summary and click on Finish Button.

Check progress of upgrade .  .  .  .  .

Once an upgrade is finished you can see upgrade results.

After successful completion of  Primary database upgrade. Start recovery on a standby database.

Standby database will be upgraded through redo apply.

After completion of all redo apply we can open a database in open mode.

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.