June 2013
Beginner
404 pages
9h 40m
English
Follow these steps to change DB_UNIQUE_NAME of a database in the Data Guard broker configuration.
DGMGRL> show database 'INDIA_UN'; Database - INDIA_UN Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds Apply Lag: 0 seconds Real Time Query: ON Instance(s): INDIA Database Status: SUCCESS DGMGRL> disable database 'INDIA_UN'; Disabled.
DB_UNIQUE_NAME value of the standby database as follows:SQL> select db_unique_name,database_role from v$database; DB_UNIQUE_NAM DATABASE_ROLE ------------- ---------------- india_un PHYSICAL STANDBY SQL> alter system set db_unique_name='INDIA_NEW' ...