In this post, we are going to have look on steps creation of Standby Database From OEM 13c Cloud Control.

Creating or adding standby database for an existing primary database is a matter of few clicks in OEM 13c cloud control.

Prerequisites:

  1. Source database is already registered in cloud control.
  2. An agent is deployed target host.
  3. Oracle binary is installed on target host ( same version and patchset of source DB).

STEPS:

 1. Go to primary database homepage in cloud console

AVAILABILITY -> ADD STANDBY DATABASE

PROVIDE SYS USER DETAILS

SELECT CREATE NEW PHYSICAL STANDBY DATABASE

SELECT ONLINE RMAN BACKUP METHOD

PROVIDE PRIMARY DB HOST oracle credential and mention parallelism

PROVIDE STANDBY DATABASE NAME and STANDBY DB HOST and ORACLE_HOME

PROVIDE THE STANDBY DB LISTENER

 

Click on VIEW JOB to see the progress

Now standby database is ready.

You can check the details in a database.

-- PRIMARY DATABASE

SQL> select name,DATABASE_ROLE,DATAGUARD_BROKER from v$database;
NAME DATABASE_ROLE DATAGUAR
--------- ---------------- --------
NONCDB PRIMARY ENABLED

-- STANDBY DATABASE

SQL> select name,DATABASE_ROLE,DATAGUARD_BROKER from v$database;
NAME DATABASE_ROLE DATAGUARD
--------- ---------------- --------
NONCDB PHYSICAL STANDBY ENABLED

Thank you for giving your valuable time to read the above information.

Source

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Anuradha’s LinkedIn: https://www.linkedin.com/in/dbaanuradhamudgal/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.