This discussion is archived
9 Replies Latest reply: Jul 22, 2012 6:44 PM by 849425 RSS

error in swithover to standby

621217 Newbie
Currently Being Moderated
In my 11g r2 database on enterprise linux 5.5。I configured one physical standby named "pc01sby1" for the primary database called "pc01prmy".I have configured DG configuration correctly.
When I switchover to the standby,the process interrupt.

DGMGRL> switchover to pc01sby1;
Performing switchover NOW, please wait...
Error: ORA-16552: error occurred while generating directives for client
Error: ORA-16501: the Data Guard broker operation failed

Failed.
Unable to switchover, primary database is still "pc01prmy"

But after I startup the old primary database into mount and startup the new primary database.All is ok,redo transport and apply have no error,also dg configuration is ok.
Now I switchover back to the old primary database
DGMGRL> switchover to pc01prmy;
Performing switchover NOW, please wait...
New primary database "pc01prmy" is opening...
Operation requires shutdown of instance "pc01sby1" on database "pc01sby1"
Shutting down instance "pc01sby1"...
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "pc01sby1" on database "pc01sby1"
Starting instance "pc01sby1"...
ORACLE instance started.
Database mounted.
Switchover succeeded, new primary is "pc01prmy"

This operation success with no error message.
Where is the clue?
The configuration of the two database is :
DGMGRL> show database verbose pc01sby1;

Database - pc01sby1

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
pc01sby1

Properties:
DGConnectIdentifier = 'pc01sby1'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '/u01/app/oracle/oradata/pc01prmy, /u01/app/oracle/oradata/pc01sby1'
LogFileNameConvert = '/u01/app/oracle/oradata/pc01prmy, /u01/app/oracle/oradata/pc01sby1'
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'node3.jhs'
SidName = 'pc01sby1'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node3.jhs)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=pc01sby1_DGMGRL)(INSTANCE_NAME=pc01sby1)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'

Database Status:
SUCCESS

DGMGRL> show database verbose pc01prmy;

Database - pc01prmy

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: OFF
Instance(s):
pc01prmy

Properties:
DGConnectIdentifier = 'pc01prmy'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'auto'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = '/u01/app/oracle/oradata/pc01sby1, /u01/app/oracle/oradata/pc01prmy'
LogFileNameConvert = '/u01/app/oracle/oradata/pc01sby1, /u01/app/oracle/oradata/pc01prmy'
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'node3.jhjjzd.com'
SidName = 'pc01prmy'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node3.jhjjzd.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=pc01prmy_DGMGRL)(INSTANCE_NAME=pc01prmy)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'

Database Status:
SUCCESS


Is this the bug on 11g release 2?
Can anybody help me?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points