Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DataGuard FSFO observer process stops after some hours

Uwe AppmeierJul 11 2025

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

Comments
Post Details
Added on Jul 11 2025
0 comments
143 views