Hello,
during the sanity check of dataguard configuration I've found strange entry for
StaticConnectIdentifier for both prim and standby :
prim:
StaticConnectIdentifier =
'(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER))(CONNECT_DATA=(SERVICE_NAME=DBNAME_L1_DGMGRL)(INSTANCE_NAME=DBNAME)(SERVER=DEDICATED)))'
standby:
StaticConnectIdentifier =
'(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER))(CONNECT_DATA=(SERVICE_NAME=DBNAME_L2_DGMGRL)(INSTANCE_NAME=DBNAME)(SERVER=DEDICATED)))'
Does this seem legit to You in any circumstances ? Normally I would expect tcp
and host as an entry .
The whole report for database configuration goes like this :
DGMGRL> show database verbose "DBNAME_L1" ;
Database - DBNAME_L1
Enterprise Manager Name: DBNAME
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
DBNAME
Properties:
DGConnectIdentifier =
'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1.2.3.200)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DBNAME_L1)(SERVER=DEDICATED)))'
ObserverConnectIdentifier = ''
LogXptMode = 'SYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '1800'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = '/u04/oradata/DBNAME/,
/u04/oradata/DBNAME/, /u05/oradata/DBNAME/, /u05/oradata/DBNAME/'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'DBNAME'
StaticConnectIdentifier =
'(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER))(CONNECT_DATA=(SERVICE_NAME=DBNAME_L1_DGMGRL)(INSTANCE_NAME=DBNAME)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/u03/backup/DBNAME_L1/standbyarchiveslog'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'log%T_%S_%R.arc'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
DGMGRL> show database verbose "DBNAME_L2"
Database - DBNAME_L2
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: OFF
Instance(s):
DBNAME
Properties:
DGConnectIdentifier =
'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1.2.3.201)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DBNAME_L2)(SERVER=DEDICATED)))'
ObserverConnectIdentifier = ''
LogXptMode = 'SYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '1800'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = '/u04/oradata/DBNAME/,
/u04/oradata/DBNAME/, /u05/oradata/DBNAME/, /u05/oradata/DBNAME/'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'DBNAME'
StaticConnectIdentifier =
'(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER))(CONNECT_DATA=(SERVICE_NAME=DBNAME_L2_DGMGRL)(INSTANCE_NAME=DBNAME)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/u03/backup/DBNAME_L2/standbyarchiveslog'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'log%T_%S_%R.arc'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
The ip and dbname has been changed to protect the innocence . DB 11.2.0.3 with
12 psu single instance no clusterware .
REgards .
GG
--
//www.freelists.org/webpage/oracle-l
