Tag Archives: Dataguard

Data Guard Setup Step by Step

FacebooktwitterredditpinterestlinkedinmailFacebooktwitterredditpinterestlinkedinmail

just follow the below steps top setup dataguard:

Environment             Server       Database Name

Production Primary  192.168.31.100 ORACLE

Production Standby  192.168.31.101 ORACLE

2.2 Setup the Primary Site (192.168.31.100)

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

ORACLE_SID= ORACLE

$ env | grep ORA

2.Start a sqlplus session connected as sysdba

$ sqlplus / as sysdba

SRead more