My Oracle Support Banner

EM 13c MIGRATE_DB : ONLINE_DATAGUARD : How To Create Standby Database For Primary Database On Different Oracle Home Of Same Version (Doc ID 2740855.1)

Last updated on JULY 11, 2021

Applies to:

Enterprise Manager for Oracle Database - Version and later
Information in this document applies to any platform.


"migrate_db: verb can be used either to create a standby database using primary database of same version or it can perform switchover of newly created standby to primary database Using Enterprise manager. This can be done via emcli verb and GUI option available.


"ONLINE_DATAGUARD" method is suggested for customers who would like to create standby database/primary database on different oracle home of same version.

Steps outlined in this document are applicable for Enterprise Manager users creating standby databases for primary database and perform switch over of the standby using ONLINE_DATAGUARD method.

a. This method can not be used for creating standby for multitenant database from existing primary multitenant database.
b. This method can be used for migration of databases of same version.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Advantages  of ONLINE_DATAGUARD based approach
 Prerequisites from OEM
 Prerequisites from database
 Migration Steps
 1. Generating Sample Script
 2. Execute ONLINE_DATAGUARD Command

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.