Data Guard Setup Step by Step


just follow the below steps top setup dataguard:

Environment  Server Database Name

Production Primary ORACLE

Production Standby ORACLE

2.2 Setup the Primary Site (

Assumptions: The db_unique_name parameter has to be set to ORACLE_A in the initORACLE.ora.

Step Procedure

1.Logon to the dm3cvs server has the oradpi user

Confirm that the ORACLE_SID and ORACLE_BASE environment variables are set properly

ORACLE_BASE= /u01/app/oracle


$ env | grep ORA

2.Start a sqlplus session connected as sysdba

$ sqlplus / as sysdba

SRead more