From your standby database, you will find similar alerts from drcORACLE_SID.log
DG 2012-02-03-09:44:17 0 2 0 RSM0: HEALTH CHECK WARNING: ORA-16826: apply service state is inconsistent with the DelayMins property
DG 2012-02-03-09:44:17 0 2 774264859 Operation CTL_GET_STATUS continuing with warning, status = ORA-16826
DG 2012-02-03-09:44:17 0 2 774264859 Operation CTL_GET_STATUS continuing with warning, status = ORA-16826
The issue is also noticed in Data Guard Command-Line Interface:
Code: Select all
DGMGRL> SHOW DATABASE verbose 'STANDBY_DB';
Database
Name: STANDBY_DB
Role: PHYSICAL STANDBY
Enabled: YES
Intended State: ONLINE
Instance(s):
ORCLA10
Properties:
InitialConnectIdentifier = 'STANDBY_DB'
ObserverConnectIdentifier = ''
LogXptMode = 'ARCH'
Dependency = ''
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '180'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '2'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'dgstan.localdomain'
SidName = 'ORCLA10'
LocalListenerAddress = '(ADDRESS=(PROTOCOL=tcp)(HOST=dgstan.localdomain)(PORT=1521))'
StandbyArchiveLocation = '+VOL1'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
LatestLog = '(monitor)'
TopWaitEvents = '(monitor)'
Current status for "STANDBY_DB":
Warning: ORA-16826: apply service state is inconsistent with the DelayMins property
Solution:
Simply restart the Data Guard Broker:
On Standby Database,
SQL> alter system set DG_BROKER_START=false;
System altered.
SQL> alter system set DG_BROKER_START=true;
System altered.
On Primary Database,
SQL> alter system set DG_BROKER_START=false;
System altered.
SQL> alter system set DG_BROKER_START=true;
System altered.
Verify that the issue is fixed.
DGMGRL> show database verbose 'STANDBY_DB';
Code: Select all
DGMGRL> show database verbose 'STANDBY_DB';
Database
Name: STANDBY_DB
Role: PHYSICAL STANDBY
Enabled: YES
Intended State: ONLINE
Instance(s):
ORCLA10
Properties:
InitialConnectIdentifier = 'STANDBY_DB'
ObserverConnectIdentifier = ''
LogXptMode = 'ARCH'
Dependency = ''
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '180'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '2'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'dgstan.localdomain'
SidName = 'ORCLA10'
LocalListenerAddress = '(ADDRESS=(PROTOCOL=tcp)(HOST=dgstan.localdomain)(PORT=1521))'
StandbyArchiveLocation = '+VOL1'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
LatestLog = '(monitor)'
TopWaitEvents = '(monitor)'
Current status for "STANDBY_DB":
SUCCESS
DGMGRL>