Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Data Guard: ORA-16534: no more requests accepted

Data Guard: ORA-16534: no more requests accepted

From: Kevin Lidh <kevin.lidh_at_gmail.com>
Date: Sun, 16 Sep 2007 09:59:41 -0600
Message-Id: <1189958381.8500.8.camel@lidhfed.lidh.com>


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-l
Received on Sun Sep 16 2007 - 10:59:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US