Recently I have been playing around with my test database. It has dataguard replication set up and I am always making changes, testing things out etc.
I noticed the other day once I had set replication back up that I was seeing a lot of errors with ORA-16826: apply service state is inconsistent with the DelayMins property.
I done a quick google around, and a couple of sites were recommending stopping the apply services ands restoring standby database again with the current control file. It also mentioned to start a new recovery session.
Luckily enough this was a very simple resolution on this occasion. I loaded DGMGRL and ran the following commands
DGMGRL> connect /Connected.DGMGRL> show configuration
Configuration Name: DG
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
orcl - Primary database
orclstby - Physical standby database
Current status for "DG":Warning: ORA-16608: one or more databases have warnings
DGMGRL> show database verbose 'orcl'
Database
Name: orcl
Role: PRIMARY
Enabled: YES
Intended State: ONLINE
Instance(s):
orcl
Properties:
InitialConnectIdentifier = 'orcl'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
Dependency = ''
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '180'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'MANUAL'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '2'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'oraconsole'
SidName = 'orcl'
LocalListenerAddress = '(ADDRESS=(PROTOCOL=tcp)(HOST=oraconsole)(PORT=1521))'
StandbyArchiveLocation = 'dgsby_orcl'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
LatestLog = '(monitor)'
TopWaitEvents = '(monitor)'
Current status for "orcl":
Warning: ORA-16792: configuration property value is inconsistent with database setting
DGMGRL> show database verbose 'orclstby';
Database
Name: orclstby
Role: PHYSICAL STANDBY
Enabled: YES
Intended State: ONLINE
Instance(s):
ORCLSTBY
Properties:
InitialConnectIdentifier = 'orclstby'
ObserverConnectIdentifier = ''
LogXptMode = 'ARCH'
Dependency = ''
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '180'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'MANUAL'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '2'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'oraclebackup'
SidName = 'ORCLSTBY'
LocalListenerAddress = '(ADDRESS=(PROTOCOL=tcp)(HOST=oraclebackup)(PORT=1521))'
StandbyArchiveLocation = '/backups'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
LatestLog = '(monitor)'
TopWaitEvents = '(monitor)'
Current status for "orclstby":
Warning: ORA-16826: apply service state is inconsistent with the DelayMins property
DGMGRL> disable configuration
Disabled.
DGMGRL> enable configuration
Enabled.
DGMGRL> show configuration
Configuration
Name: DG
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
orcl - Primary database
orclstby - Physical standby database
Current status for "DG":
SUCCESS
I am always interested in your thoughts so if you have any comments or feedback then please feel free to add any comments, or you can mail me here.