Error: ORA-16664: unable to receive the result from a member

Error: ORA-16664: unable to receive the result from a member

[oraprd@prd1 STANDBY]$ ./show_dg.sh
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Sat May 29 10:19:47 2021
Version 19.8.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> Connected to "LAPPRIMDB"
Connected as SYSDBA.
DGMGRL>
Configuration - DRsolution
  Protection Mode: MaxPerformance
  Members:
  LAPPRIMDB - Primary database
    lapdrdb   - Physical standby database
      Error: ORA-16664: unable to receive the result from a member========> How to Resolve this Error.

Fast-Start Failover:  Disabled

Configuration Status:
ERROR   (status updated 39 seconds ago)
DGMGRL>
Configuration - DRsolution
  Protection Mode: MaxPerformance
  Members:
  LAPPRIMDB - Primary database
    lapdrdb   - Physical standby database
      Error: ORA-16664: unable to receive the result from a member
  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    TraceLevel                      = 'USER'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    ObserverReconnect               = '0'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'
    ObserverOverride                = 'FALSE'
    ExternalDestination1            = ''
    ExternalDestination2            = ''
    PrimaryLostWriteAction          = 'CONTINUE'
    ConfigurationWideServiceName    = 'LAP_CFG'
Fast-Start Failover:  Disabled
Configuration Status:
ERROR
DGMGRL>

PROCESS

---------

DGRD

ARCH

DGRD

ARCH

ARCH

ARCH

DGRD

LNS

DGRD

9 rows selected.

[oraprd@prd1 STANDBY]$ ./stat.sh

NAME      DATABASE_ROLE    OPEN_MODE            DB_UNIQUE_NAME                 PROTECTION_MODE      PROTECTION_LEVEL

--------- ---------------- -------------------- ------------------------------ -------------------- --------------------

LAP       PRIMARY          READ WRITE           LAPPRIMDB                      MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE ====> lets Change Mode to Max Avaialability.

Solutions:-

1===>Add Standby Redolog on both Primary And Standby Database.

[oraprd@prd2 STANDBY]$ cat add_standby_redo.sh

sqlplus -s / as sysdba <<eof

recover managed standby database cancel;

alter database add standby logfile group 4 ('/u001/oradata/LAP/redo04.log') size 200m reuse;

alter database add standby logfile group 5 ('/u001/oradata/LAP/redo05.log') size 200m reuse;

alter database add standby logfile group 6 ('/u001/oradata/LAP/redo06.log') size 200m reuse;

alter database add standby logfile group 7 ('/u001/oradata/LAP/redo07.log') size 200m reuse;

eof

[oraprd@prd2 STANDBY]$

2===>Its show ASYNC Here on Standby Database & primary Database.

DGMGRL> show database verbose 'LAPDRDB';

Database - lapdrdb

  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: 2.00 KByte/s

  Active Apply Rate:  81.00 KByte/s

  Maximum Apply Rate: 82.00 KByte/s

  Real Time Query:    OFF

  Instance(s):

    LAPDRDB

  Properties:

    DGConnectIdentifier             = 'lapdrdb'

    ObserverConnectIdentifier       = ''

    FastStartFailoverTarget         = ''

    PreferredObserverHosts          = ''

    LogShipping                     = 'ON'

    RedoRoutes                      = ''

    LogXptMode                      = 'ASYNC'====>Change to 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                        = 'prd2.hana.com'

    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prd2.hana.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=LAPDRDB_DGMGRL.hana.com)(INSTANCE_NAME=LAPDRDB)(SERVER=DEDICATED)))'

    TopWaitEvents                   = '(monitor)'

    SidName                         = '(monitor)'

  Log file locations:

    Alert log               : /oracle/PRD/diag/rdbms/lapdrdb/LAPDRDB/trace/alert_LAPDRDB.log

    Data Guard Broker log   : /oracle/PRD/diag/rdbms/lapdrdb/LAPDRDB/trace/drcLAPDRDB.log

Database Status:

SUCCESS

Please update the SYNC Value on DR and Primary database.

dgmgrl

connect sys/abc#123@lapprimdb

EDIT DATABASE 'lapdrdb' SET PROPERTY 'LogXptMode'='SYNC';

EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

[oraprd@prd1 STANDBY]$ 

dgmgrl <<eof

connect sys/abc#123@lapprimdb

EDIT DATABASE 'lapprimdb' SET PROPERTY 'LogXptMode'='SYNC';

EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

show configuration;

exit;

eof

3====> Also bounce a standby database.

[oraprd@prd2 STANDBY]$ cat start_standby.sh

export ORACLE_SID=LAPDRDB

sta()

{

sqlplus -s / as sysdba <<eof

startup nomount

alter database mount standby database;

alter database recover managed standby database disconnect from session;

select process from v\$managed_standby;

set lines 200

col destination for a40

select destination,status,error from v\$archive_dest_status

where rownum< 3;

eof

}

stp()

{

sqlplus -s / as sysdba <<eof

alter database recover managed standby database cancel;

shut immediate;

eof

}

stp

sta

[oraprd@prd2 STANDBY]$

[oraprd@prd1 STANDBY]$ ./show_dg.sh

DGMGRL for Linux: Release 19.0.0.0.0 - Production on Sat May 29 10:34:20 2021

Version 19.8.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Welcome to DGMGRL, type "help" for information.

DGMGRL> Connected to "LAPPRIMDB"

Connected as SYSDBA.

DGMGRL>

Configuration - DRsolution

  Protection Mode: MaxPerformance

  Members:

  LAPPRIMDB - Primary database

    lapdrdb   - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:

SUCCESS   (status updated 58 seconds ago)

DGMGRL>

See the error is gone.