Step by Step to Create Standby Database From OEM 13c Cloud Control

 Step by Step to Create 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 patch–set of source DB).

STEPS:

  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 CREDENTIALS & 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

standby database is available Now.

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