Data Guard: ORA-16534: no more requests accepted
- From: Kevin Lidh <kevin.lidh@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 16 Sep 2007 09:59:41 -0600
We have an environment Solaris (SPARC) 9 with Oracle 10.2.0.1.0 with a
two-node RAC database. We used Grid Control to create a standby on
another node and it was successful. We then tried to do a switchover
using DGMGRL. The new primary was up and successful but the standby
opened on node 2 and logs weren't being shipped. I shutdown the standby
on node 2 and started the database manually on node 1 with the
'alter database recover managed standby database through all switchover
disconnect using current logfile'
All of a sudden logs were being shipped and applied. Then CRS started
the instance on node 2 and all was good.
I then angered the DG gods by attempting to switch back from the 1-node
primary back to the 2-node standby. If I do a "verify configuration"
from Grid Control, it gives me an ORA-16534 saying it won't accept
anymore requests. The "action" specified is to wait but nothing is
happening. Metalink has one example of this error but it was when a
listener wasn't defined correctly and the switchover failed.
What I'm wondering is, is there any way to clear the DG queue and
attempt the switchover again?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
