I may increase it based on the demand and requirements. In this video I am demonstrating the steps to create a Physical Standby database using OEM.
Oracle dataguard is an indispensable part of oracle’s high availability solutions. In a real world scenario the Primary and Phsyical standby databases reside on geographically different locations or different data centers to make sure that even if one region goes completely down, your database is still available and intact. In this tutorial and the series I am using a virtual environment for demonstration purpose.
Steps, SQLs used and Prerequisites in Details:
My other series on YouTube:
Mastering OEM 13c (Full Series):
Oracle VirtualBox Virtual Machines:
OEM Named Credentials:
The Database Configuration Assistant (DBCA) can also be used as a simple
command-line method to create an Oracle Data Guard physical standby database.
The DBCA command qualifier used to create the physical standby database is
createDuplicateDB. The basic createDuplicateDB command has the following syntax:
Creating a Standby Database with Active Database Duplication
To use the RMAN DUPLICATE command to create a standby database from files that
are active in the primary database, you must specify both the FOR STANDBY and FROM
ACTIVE DATABASE options. You can specify other options as well, such as DORECOVER.
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER;
Take the opportunity to connect and share this video with your friends and family if you find it useful.