Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Data Guard: ORA-16534: no more requests accepted
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?
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Sep 16 2007 - 10:59:41 CDT