Primary DB unique name and standby DB MRP process confusing
Hi Gurus,
I have a primary database with two standby databases for it.
Primary:
SQL> select database_role, db_unique_name, primary_db_unique_name from v$database;
DATABASE_ROLE DB_UNIQUE_NAME PRIMARY_DB_UNIQUE_NAME
---------------- ------------------------------ ------------------------------
PRIMARY EBSP1 EBSP1_MMK
SQL> select name, value from v$parameter where name like '%unique%';
NAME VALUE
-------------------- --------------------
db_unique_name EBSP1
First Standby:
SQL> select database_role, db_unique_name, primary_db_unique_name from v$database;
DATABASE_ROLE DB_UNIQUE_NAME PRIMARY_DB_UNIQUE_NAME
---------------- ------------------------------ ------------------------------
PHYSICAL STANDBY EBSP1_MMK EBSP1
$ ps -aef|grep mrp