Home » Server Options » Data Guard » Using DGMGRL on Sun Cluster 3.1 (Ora 10.2.0.2, Solaris 9,)
Using DGMGRL on Sun Cluster 3.1 [message #294330] Thu, 17 January 2008 04:23
aarmst
Messages: 1
Registered: January 2008
Junior Member
I have a 2 node Sun Cluster hosting a single instance database. I have successfully set up Dataguard to replicate to a disaster recovery server. However I have some issues using DGMGRL. When I set up the primary database in DGMGRL it shows the database as having a hostname of the currently active cluster node.

DGMGRL> show database verbose 'ABC1'

Database
Name: ABC1
Role: PRIMARY
Enabled: YES
Intended State: ONLINE
Instance(s):
MVF

Properties:
InitialConnectIdentifier = 'abc1'
LogXptMode = 'ASYNC'
Dependency = ''
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '180'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'auto'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '2'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'node1'
SidName = 'ABC'
LocalListenerAddress = '(ADDRESS=(PROTOCOL=TCP)(HOST=cluster)(Port=1525))'
StandbyArchiveLocation = '/usr/abc/data/dbase/arch'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'arch.log%t_%s_%r.dbf'
LatestLog = '(monitor)'
TopWaitEvents = '(monitor)'


I can connect to DGMGRL from either cluster node (node1 and node2) and it works fine. However if my cluster switches the database over from node1 to node2 I get this error when I try to show configuration

$ dgmgrl sys/stayout@ABC1
DGMGRL for Solaris: Version 10.2.0.2.0 - 64bit Production

Copyright (c) 2000, 2005, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> show configuration
Error: ORA-16596: object not part of the Data Guard broker configuration

Configuration details cannot be determined by DGMGRL

Does anyone know how to make DGMGRL to work regardless of which cluster node is currently hosting the database. I have tried to change the hostname property to cluster, but then I get the same error when I try to re-enable the configuration.

Previous Topic: Switchover status
Next Topic: Standbydatabase error
Goto Forum:
  


Current Time: Sat Dec 10 09:14:26 CST 2016

Total time taken to generate the page: 0.09115 seconds