Database Administration (MOSC)

MOSC Banner

Primary DB unique name and standby DB MRP process confusing

edited Sep 22, 2015 10:08AM in Database Administration (MOSC) 5 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center