Hi all
We are using Oracle 19.22 on Oracle Linux 8.9
Two databases, both are running fine, connects work fine, Dataguard setup seems okay
Observer Process is running o third server in same network - no firewalls
----------------------------------------------------------------------------------------------------------------
DGMGRL> show configuration verbose
Configuration - golfdb
Protection Mode: MaxAvailability
Members:
golfdb - Primary database
orpunddb - (*) Physical standby database
(*) Fast-Start Failover target
Properties:
FastStartFailoverThreshold = '10'
OperationTimeout = '30'
TraceLevel = 'USER'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '15'
ObserverReconnect = '0'
FastStartFailoverLagGraceTime = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
ConfigurationWideServiceName = 'GOLFDB_CFG'
FastStartFailoverLagType = 'APPLY'
Fast-Start Failover: Enabled in Zero Data Loss Mode
Lag Limit: 30 seconds (not in use)
Lag Type: APPLY
Threshold: 10 seconds
Active Target: orpunddb
Potential Targets: "orpunddb"
orpunddb valid
Observer: rcsgolfdb
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: (none)
Observer Override: FALSE
Lag Grace Time: 0 seconds
Configuration Status:
SUCCESS
---------------------------------------------------------------------------------------------------------------------------------------
DGMGRL> show database verbose golfdb
Database - golfdb
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
GOLFDB
Properties:
DGConnectIdentifier = 'golfdb'
ObserverConnectIdentifier = ''
FastStartFailoverTarget = 'orpunddb'
PreferredObserverHosts = ''
LogShipping = 'ON'
RedoRoutes = ''
LogXptMode = 'SYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '30'
TransportLagThreshold = '30'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
ApplyInstances = '0'
StandbyFileManagement = ''
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '0'
LogArchiveMinSucceedDest = '0'
DataGuardSyncLatency = '0'
LogArchiveTrace = '0'
LogArchiveFormat = ''
DbFileNameConvert = ''
LogFileNameConvert = ''
ArchiveLocation = ''
AlternateLocation = ''
StandbyArchiveLocation = ''
StandbyAlternateLocation = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
LogXptStatus = '(monitor)'
SendQEntries = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'rcsgolfdb'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xxx.xxx.xxx)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=GOLFDB_DGMGRL)(INSTANCE_NAME=GOLFDB)(SERVER=DEDICATED)))'
TopWaitEvents = '(monitor)'
SidName = '(monitor)'
Log file locations:
Alert log : /u01/app/oracle/diag/rdbms/golfdb/GOLFDB/trace/alert_GOLFDB.log
Data Guard Broker log : /u01/app/oracle/diag/rdbms/golfdb/GOLFDB/trace/drcGOLFDB.log
Database Status:
SUCCESS
DGMGRL> show database verbose orpunddb
Database - orpunddb
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 6.00 KByte/s
Active Apply Rate: 1.47 MByte/s
Maximum Apply Rate: 2.46 MByte/s
Real Time Query: OFF
Instance(s):
ORPUNDDB
Properties:
DGConnectIdentifier = 'orpunddb'
ObserverConnectIdentifier = ''
FastStartFailoverTarget = 'golfdb'
PreferredObserverHosts = ''
LogShipping = 'ON'
RedoRoutes = ''
LogXptMode = 'SYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '30'
TransportLagThreshold = '30'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
ApplyInstances = '0'
StandbyFileManagement = ''
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '0'
LogArchiveMinSucceedDest = '0'
DataGuardSyncLatency = '0'
LogArchiveTrace = '0'
LogArchiveFormat = ''
DbFileNameConvert = ''
LogFileNameConvert = ''
ArchiveLocation = ''
AlternateLocation = ''
StandbyArchiveLocation = ''
StandbyAlternateLocation = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
LogXptStatus = '(monitor)'
SendQEntries = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'rcsorpunddb'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xxx.xxxx.xx)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORPUNDDB_DGMGRL)(INSTANCE_NAME=ORPUNDDB)(SERVER=DEDICATED)))'
TopWaitEvents = '(monitor)'
SidName = '(monitor)'
Log file locations:
Alert log : /u01/app/oracle/diag/rdbms/orpunddb/ORPUNDDB/trace/alert_ORPUNDDB.log
Data Guard Broker log : /u01/app/oracle/diag/rdbms/orpunddb/ORPUNDDB/trace/drcORPUNDDB.log
Database Status:
SUCCESS
---------------------------------------------------------------------------------------------------------------------------------------------
DGMGRL> show observer
Configuration - golfdb
Primary: golfdb
Active Target: orpunddb
Observer "rcsgolfdb" - Master
Host Name: rcst02db
Last Ping to Primary: 2 seconds ago
Last Ping to Target: 2 seconds ago
after some hours I can see
DGMGRL> show observer
Configuration - golfdb
Primary: golfdb
Active Target: orpunddb
Observer "rcsgolfdb" - Master
Host Name: rcst02db
Last Ping to Primary: 13284 seconds ago
Last Ping to Target: 13283 seconds ago
DGMGRL> show configuration
Configuration - golfdb
Protection Mode: MaxAvailability
Members:
golfdb - Primary database
Error: ORA-16820: fast-start failover observer is no longer observing this database
orpunddb - (*) Physical standby database
Error: ORA-16820: fast-start failover observer is no longer observing this database
Fast-Start Failover: Enabled in Zero Data Loss Mode
Configuration Status:
ERROR (status updated 26 seconds ago)
We get this anytime I start an observer process afer 3-4 hrs. Restart of the observer works, but should the observer not run “forever” ?
thanks for help
Uwe