Oracle 11g to 12c database upgrade with Data Guard and ASM

Name: Oracle 11g to 12c database upgrade with Data Guard and ASM
Rating: 4.0 (107 reviews)

Video course to focus on Oracle Data Guard upgrade from 11g to 12c with ASM

Created byArun Kumar

Last updated 12/2017

English

English [Auto],

What you'll learn

How to upgrade Oracle 11g to 12c in Data Guard configuration with ASM
Configure primary and standby servers with Data Guard and ASM
How to upgrade physical standby and primary
How to upgrade grid home and Oracle Home

Course content

4 sections • 20 lectures • 1h 36m total length

Before you start0:18
Practice environment overview0:23
How to upgrade standalone database?3:30
Upgrade a standalone Oracle database by comparing manual upgrades with the DMU graphical option, and outline steps for configuring Oracle, grid, and database homes to simplify the process.
How to upgrade standalone database with data guard?4:45
Upgrade a data guard configuration by upgrading the standby to 12c first, start mrp to apply redo, then upgrade the primary; redo ships automatically to the standby.
How to upgrade standalone database with ASM (GRID_HOME)2:38
Upgrade a standalone Oracle database with ASM using grid home by upgrading the grid first, then the database home binaries, in a Data Guard-free setup.
How to upgrade standalone database with data guard and ASM (GRID_HOME)4:09
Upgrade a standalone Oracle database with Data Guard and ASM by upgrading the standby first, enabling MRP, then upgrading GRID_HOME and Oracle Home on the standby, and finally the primary.

Grid Home pre-upgrade steps on physical standby13:22
Upgrade the grid software on the physical standby first, then upgrade the database on standby, while disabling the data guard broker and backing up its configuration, before upgrading the primary.
Install and upgrade 12c grid on physical standby7:37
Upgrade the grid infrastructure from 11g to 12c on a physical standby, using the installer to upgrade grid infrastructure and automatic storage management while the standby remains active.
Grid home post-upgrade steps on physical standby1:44
Update the bash profile to point to the new grid home after the upgrade, then start the database manually and plan upgrading the primary and physical standby software.
Install 12c database software on physical standby6:25
Upgrade grid software first, then install the 12c database software into an Oracle home on standby. The standby is upgraded via software installation only, coordinated from the primary via MRP.
Prepare physical standby database for upgrade14:45
Prepare the physical standby for upgrade by updating Oracle home and environment. Copy parameter and password files, DNS names, and listener configuration to enable Data Guard and MRP upgrades.
Review upgrade steps7:18
Learn how to upgrade Oracle 11g to 12c in a Data Guard setup by upgrading the standby first, configuring new Oracle homes, and using MRP to apply logs automatically.

Grid Home pre-upgrade steps on primary4:56
Plan downtime for grid infrastructure upgrade by disabling Oracle restart on the primary, shutting down the database, and verifying listener and oracle home configurations on both primary and standby.
Install and upgrade 12c grid on primary2:52
Upgrade the primary grid to 12c using the default upgrade path. Set the correct grid home, run prerequisites check, and update the grid user's environment variables to the new home.
Grid home post upgrade steps1:08
Upgrade the grid environment by updating the oracle home to 12.3 and refreshing the bash profile, then perform grid upgrade steps that mirror the primary and standby process.
Install 12c database software on primary5:18
Upgrade the 12c database software on the primary in a grid environment using the run installer, then perform the database upgrade and verify standby readiness.
Database pre-upgrade steps on primary4:30
Copy dns names to new home, update Oracle home and listener, and modify the Oracle user's bash profile; VB upgrade copies dbms folder automatically, but not parameter or password files.
Invoke DBUA to upgrade primary database from 11g to 12c8:47
Learn to invoke DBUA to upgrade a primary database from 11g to 12c, validating environment variables and Oracle home, checking standby sync, and reviewing upgrade progress and alert logs.
Post-upgrade summary on primary1:07
Review the upgrade progress and step timings for the primary database, confirming the upgrade results as successful and noting that the standby database is upgraded automatically.

Requirements

You should know how to install Oracle standalone database with ASM
You should be able to configure physical standby on 11g
Must have working experience of Oracle Database Administration

Description

Upgrading oracle database from 11g to 12c in standalone configuration is easy and sometimes straight forward. The complexity increases when you have standalone 11g database configured with oracle data guard. This complexity even increases further when you have same 11g standalone database with data guard and ASM configured.

Master Oracle 11g to 12c Database Upgrade with ASM in Data Guard configuration (Physical Standby)

Install and configure oracle 11g on virtual box along with grid and ASM
Setup physical standby from primary server to standby server
Talk about different types of upgrade methods inside Oracle database
Upgrade GRID + ASM from 11g to 12c on primary and standby
Upgrade Oracle from 11g to 12c on primary and standby
Maintain databases in sync even after upgrade is finished

Experience the GRID + ASM + Database upgrade from 11g to 12c in Data Guard configuration on VirtualBox

This course is designed to help you learn oracle 11g to 12c upgrade in data guard configuration along with ASM and GRID home. You first stat with environment setup, prepare your Virtual machines, configure data guard, setup physical standby and perform the upgrade. All the activities and videos are executed on Virtual Box setup.

This course is designed for DBAs who are good at database administration but struggle to understand how to perform Oracle database upgrade in data guard configuration with ASM and GRID Home.

Enroll into the course and start learning how to upgrade oracle database with physical standby configured on top of ASM!

Who this course is for:

Oracle RAC DBAs
Oracle advanced DBAs
Any Oracle administrator who wants to learn the 11g to 12c Data Guard upgrade with ASM

Oracle 11g to 12c database upgrade with Data Guard and ASM

What you'll learn

Explore related topics

Course content

How upgrades are done6 lectures • 16min

Physical standby upgrade6 lectures • 51min

Primary upgrade7 lectures • 29min

Summary1 lecture • 1min

Requirements

Description

Who this course is for: