Dataguard Broker Configuration

                                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