Oracle DataGuard – Step-by-Step – Create a Physical Standby Database Using OEM

Channel Avatar
Comment
X
Share
Oracle DataGuard - Step-by-Step - Create a Physical Standby Database Using OEM
Oracle DataGuard – Step-by-Step – Create a Physical Standby Database Using OEM
Welcome to this new series on oracle DataGuard. Including this pilot episode, I will upload more tutorials in this series that will cover everything you need to know to effective manage and use Oracle DataGuard and become a master in it. My plan is to make this a minimum 10 part series but
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:
https://drive.google.com/file/d/1cS7fGxAm_10PnAwUO5VhgdAfOfORl7EL/view?uspshare_link

My other series on YouTube:

Mastering OEM 13c (Full Series):
https://www.youtube.com/playlist?listPLgWj5dy2RoFZLk49TIxMjW5g8C5K0ntjq

Oracle VirtualBox Virtual Machines:
https://www.youtube.com/playlist?listPLgWj5dy2RoFZTLn2tIdZ-P0Yhj_WbOQ9U

OEM Named Credentials:
https://youtu.be/sF2A3WdcW9Y

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:

dbca -createDuplicateDB
-gdbName global_database_name
-primaryDBConnectionString easy_connect_string_to_primary
-sid database_system_identifier
[-createAsStandby
[-dbUniqueName db_unique_name_for_standby]]
[-customScripts scripts_list]

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.
For example:
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.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *