Question: I have set-up a Primary 11g
database which successfully ships and applies logs to a Single
Standby (on the same server) as expected. Manual switchovers work
fine; however, I cannot do switchovers with the Data Guard Broker
The switchover is successful- but the broker cannot
restart the Primary instance. The strange thing is that when I
perform a switchover in the opposite direction (i.e. the new Primary
goes back to standby again) it works fine. The error on switchover
ORA-12514: TNS: listener does not currently know
of service requested in connect descriptor.
I can manually start the failover instance, but how do I
get my instance to re-start automatically after a switchover?
Answer: The book "Oracle
Data Guard" has working examples of Data Guard
switchover/failover in the code depot download:
Also see my
notes on the ORA-12514 error
Here are some issues with the ORA-12514 during Data
Guard failover. First, run these Data Guard broker commands to
see the status of the standby instance:
DGMGRL> show database
DGMGRL> switchover to 'mystandbysid';
Some DBA's suggest that this startup error may be because the
special service db_unique_name_DGMGRL has not been
registered properly with the listener.
If you want to enable
DGMGRL to automatically re-start a standby database instance, you
list create a listener service and register the service with the
local listener on both the primary and failover/standby instance.
The value GLOBAL_DBNAME should be a concatenation of
the db_name and the domain name: e. g.
LISTENER = (DESCRIPTION
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.