Select Page

FUN with Oracle Standby Databases!

Chad Cleveland | | November 5, 2019

Man having fun with Oracle Standby Databases

Today I’m going to show you how to migrate a 1.2TB database from an on-site data center to a hosted Colo facility, it’s an upgrade to Oracle 12.2.

 
Here’s what’s nifty about it!

We installed Oracle 11.2 and 12.2 on a new host and patched 12.2 to July PSU + OJVM. I used RMAN Active Duplicate to build a standby database. Then I let the standby database run for about a week. From there I cleaned up the primary database by fixing all issues via Oracle’s and Datavail’s pre-upgrade checks. Datavail is the KING of database migrations and upgrades.

The Nifty Continues: Round #1

  • Set Restore point,
  • Stopped Log Apply,
  • Opened Database, allowed Apps to validate connectivity and basic app shakedown of New Hosts
  • Flashed back database, reset Standby and recaptured logs
  • Back to business

Round #2:

  • Set new Restore point,
  • Stopped Log Apply,
  • Upgraded database to 12.2,
  • Turned over to App Team to configure to new hosts and upgraded database
  • Shake down, validation…etc.

 

Then I reset the database to 11.2 via Restore points and then back to business! I removed unnecessary Oracle database components in primary. Database was originally built with DBCA and everything installed and turned on. The removal of unused Components will speed up the Upgrade Process, reduces user issues, and can help to avoid license issues.

select substr(comp_id,1,15) comp_id,substr(comp_name,1,30) comp_name,substr(version,1,10) version,status from dba_registry;SQL> SQL> SQL> SQL>

 

COMP_ID COMP_NAME VERSION STATUS
APEX Oracle Application Express 3.2.1.00.1 INVALID –> not needed
SDO Spatial 11.2.0.4.0 VALID –> Not used
ORDIM Oracle Multimedia 11.2.0.4.0 VALID –> Not used
XDB Oracle XML Database 11.2.0.4.0 VALID –> Need for 12.2
EXF Oracle Expression Filter 11.2.0.4.0 VALID –> Not used
RUL Oracle Rules Manager 11.2.0.4.0 VALID –> Not used
OWM Oracle Workspace Manager 11.2.0.4.0 VALID –> Not used
CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID
CATPROC Oracle Database Packages and T 11.2.0.4.0 VALID
JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 VALID
XML Oracle XDK 11.2.0.4.0 VALID
CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID
RAC Oracle Real Application Cluster 11.2.0.4.0 VALID

Round #3

  • Set new Restore point,
  • Stopped Log Apply,
  • Upgrade database to 12.2
  • Turned over to app team to configure new hosts and upgraded database
  • Shake down, validation…etc.

 

The Database upgrade time decreased by approximately 30 minutes. The app team reconfigured speed increased, app startup and testing to resume much faster.

Repeated Roll Back

Round #4

  • Same steps completed, but this was Go Live.
  • Completed Migration of both databases and applications in less than 90 Minutes.
  • Downtime was acceptable and repeated testing allowed prevention of unknown issues and sped up tasks by DBA and app teams.

 

And boom: Satisfaction by Users A+! That’s what Datavail aims for. We’re always seeking the best ways to migrate databases and as professionals continue to look for unique ways to test and plan for all of your database needs.

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Scripting Out the Logins, Server Role Assignments, and Server Permissions

Imagine over one hundred logins in the source server, you need to migrate them to the destination server. Wouldn’t it be awesome if we could automate the process?

JP Chen | October 1, 2015
sharepoint ideas

9 Awesome Things You Can Do with SharePoint

This blog post discusses out-of-the-box uses for SharePoint that you can execute in just a few clicks without using any code.

Amol Gharat | May 23, 2017

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS