Dataguard Broker Configuration
Step1:-Creating a Service Listener in primary and standby
side(Both Side)
primary
SQL> select name ,open_mode,database_role,protection_level from v$database;
NAME OPEN_MODE DATABASE_ROLE PROTECTION_LEVEL
--------- -------------------- ---------------- --------------------
PROD READ WRITE PRIMARY MAXIMUM PERFORMANCE
standby
SQL> SELECT name DB_NAME, db_unique_name FROM v$database;
DB_NAME DB_UNIQUE_NAME
--------- ------------------------------
PROD prodstby
