My Oracle Support Banner

ORA-16651 while enabling FSFO - DGMGRL (Doc ID 1394470.1)

Last updated on FEBRUARY 06, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.2 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

ORA-16651 While configuring FSFO.

------Primary DRC log 'drcboston.log '-----------

2012-01-05 14:43:33.167 00000000 822206915 DMON: chief lock convert for write op EDIT_DRC
2012-01-05 14:43:33.168 00000000 822206915 DMON: ORA-16651, must select from multiple potential FSFO targets
2012-01-05 14:43:33.201 DMON: persisting FSFO state flags=0x0, version=0, obid=0x49400b9b (1228934043), threshold=30, laglim=45, obslim=30
2012-01-05 14:43:33.248 00000000 822206915 DMON: ORA-16651, failed to enable FSFO
2012-01-05 14:43:33.250 00000000 822206915 DMON: EDIT_DRC: (error=ORA-16651)

DGMGRL> ENABLE FAST_START FAILOVER;
Error: ORA-16651: requirements not met for enabling fast-start failover

Failed.

DGMGRL> show configuration;

Configuration - DG

Protection Mode: MaxPerformance
Databases:
<PRIMARY> - Primary database
<STANDBY>- Physical standby database
<LOGICALSTANDBY>- Logical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

DGMGRL> show database verbose 'PRIMARY_DB';

Database - PRIMARY_DB_NAME

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
<INSTANCE_NAME>

Properties:
DGConnectIdentifier = '<PRIMARY>'
ObserverConnectIdentifier = ''
LogXptMode = 'async'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
LsbyASkipTxnCfgPr = '0,0,0'
LsbyDSkipTxnCfgPr = '0,0,0'
LsbyASkipCfgPr = ''
LsbyDSkipCfgPr = ''
LsbyASkipErrorCfgPr = ''
LsbyDSkipErrorCfgPr = ''
LsbyMaxEventsRecorded = '0'
LsbyPreserveCommitOrder = ''
LsbyRecordSkipErrors = ''
LsbyRecordSkipDdl = ''
LsbyRecordAppliedDdl = ''
StandbyFileManagement = 'MANUAL'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '4'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
LsbyParameters = '(monitor)'
LsbySkipTxnTable = '(monitor)'
LsbySkipTable = '(monitor)'
LsbyFailedTxnInfo = '(monitor)'
HostName = 'NSELVAKU-LAP'
SidName = 'boston'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<HOST_NAME>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<SERVICE_NAME>)(INSTANCE_NAME=<INSTANCE_NAME>)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'ARC%S_%R.%T'
LsbyMaxSga = '0'
LsbyMaxServers = '0'
TopWaitEvents = '(monitor)'

Database Status:
SUCCESS


NOTE : Show configuration and show database verbose will not give the clear picture about what is the issue. We have to corresponding DRC log.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.