Hello,
C:\Windows\system32>dgmgrl
DGMGRL for 64-bit Windows: Version 12.1.0.2.0 - 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/XXX@orcl2
Connected as SYSDBA.
DGMGRL> show configuration;
Configuration - ORCL2DR
Protection Mode: MaxPerformance
Members:
orcl2 - Primary database
ORCL2_STBY - Physical standby database
Error: ORA-16664: unable to receive the result from a database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR (status updated 24 seconds ago)
DGMGRL> show database verbose 'ORCL2_STBY';
Database - ORCL2_STBY
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: (unknown)
Apply Lag: (unknown)
Average Apply Rate: (unknown)
Active Apply Rate: (unknown)
Maximum Apply Rate: (unknown)
Real Time Query: OFF
Instance(s):
orcl2
Properties:
DGConnectIdentifier = 'orcl2_stby'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
RedoRoutes = ''
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '8'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = 'orcl2, ORCL2_STBY'
LogFileNameConvert = 'orcl2, ORCL2_STBY'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxx)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=ORCL2_STBY_DGM
GRL)(INSTANCE_NAME=orcl2)(SERVER=DEDICATED)))'
StandbyArchiveLocation = 'USE_DB_RECOVERY_FILE_DEST'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.arc'
TopWaitEvents = '(monitor)'
Database Status:
DGM-17016: failed to retrieve status for database "ORCL2_STBY"
ORA-16664: unable to receive the result from a database
DGMGRL>
okay go to alert logs
--primary
02/22/2016 16:36:48
Site ORCL2_STBY returned ORA-16664.
Data Guard Broker Status Summary:
Type Name Severity Status
Configuration ORCL2DR Warning ORA-16607
Primary Database orcl2 Success ORA-00000
Physical Standby Database ORCL2_STBY Error ORA-16664
--in standby
SPFILE is missing value for property 'LogArchiveTrace' with sid='orcl2'
Warning: Property 'LogArchiveTrace' has inconsistent values:METADATA='0', SPFILE='(missing)', DATABASE='0'
SPFILE is missing value for property 'LogArchiveFormat' with sid='orcl2'
Warning: Property 'LogArchiveFormat' has inconsistent values:METADATA='%t_%s_%r.arc', SPFILE='(missing)', DATABASE='%t_%s_%r.arc'
could you give me some ideas how to fix?
Thank you very much