Hi all,

I am trying to build a single standby db for a 2 node RAC db on RHEL 4 using Oracle 10.2.0.1

I am having the following errors:

In node1 of the LIVE RAC db:

Code:
select message from v$dataguard_status;
Error 1017 received logging on to the standby
PING[ARC0]: Heartbeat failed to connect to standby 'mmgdrs'. Error is 16191.
Error 1017 received logging on to the standby
PING[ARC0]: Heartbeat failed to connect to standby 'mmgdrs'. Error is 16191.
Error 1017 received logging on to the standby
PING[ARC0]: Heartbeat failed to connect to standby 'mmgdrs'. Error is 16191.
Error 1017 received logging on to the standby
PING[ARC0]: Heartbeat failed to connect to standby 'mmgdrs'. Error is 16191.
Error 1017 received logging on to the standby
PING[ARC0]: Heartbeat failed to connect to standby 'mmgdrs'. Error is 16191.
Error 1017 received logging on to the standby
I understand one of the causes for the the above is not having the same password for sys in the password file. I have ensured that this is the same. When I ty a remote connect from node 1 to DRS i can occasionally log in but sometimes I get SQL connection timeout errors!

On node 2 I am seeing the following errors:

Code:
PING[ARC0]: Heartbeat failed to connect to standby 'mmgdrs'. Error is 1031.
Error 1031 received logging on to the standby
PING[ARC0]: Heartbeat failed to connect to standby 'mmgdrs'. Error is 1031.
Error 1031 received logging on to the standby
PING[ARC0]: Heartbeat failed to connect to standby 'mmgdrs'. Error is 1031.

MESSAGE
--------------------------------------------------------------------------------
Error 1031 received logging on to the standby
PING[ARC0]: Heartbeat failed to connect to standby 'mmgdrs'. Error is 1031.
PING[ARC0]: Heartbeat failed to connect to standby 'mmgdrs'. Error is 16058.
Now for the strangest thing: In the standby alert log i see:

Code:
Wed May  7 00:23:32 2008
RFS[1]: Archived Log: '+MMGDRS1/mmgdrs/archivelog/2008_05_07/thread_2_seq_6938.1128.654049215'
Wed May  7 00:26:49 2008
RFS[1]: Archived Log: '+MMGDRS1/mmgdrs/archivelog/2008_05_07/thread_2_seq_6939.1127.654049413'
Wed May  7 00:30:07 2008
RFS[1]: Archived Log: '+MMGDRS1/mmgdrs/archivelog/2008_05_07/thread_2_seq_6940.1130.654049611'
Wed May  7 00:33:23 2008
RFS[1]: Archived Log: '+MMGDRS1/mmgdrs/archivelog/2008_05_07/thread_2_seq_6941.1120.654049807'
Wed May  7 00:36:38 2008
RFS[1]: Archived Log: '+MMGDRS1/mmgdrs/archivelog/2008_05_07/thread_2_seq_6942.1103.654050003'
It seems to be fetching the logs from somewhere, but only for thread 2! However its not applying them. I am posting the Dataguard specific parameters :

LIVE RAC:
Code:
SQL> show parameter log_archive

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_config                   string      dg_config=(mmgdrs,BOF2)
log_archive_dest                     string
log_archive_dest_1                   string      LOCATION=+LOG/BOF2
log_archive_dest_10                  string
log_archive_dest_2                   string      service=mmgdrs valid_for=(ALL_
                                                 LOGFILES,PRIMARY_ROLE) db_uniq
                                                 ue_name=mmgdrs
DRS:

Code:
SQL> show parameter log_archive

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_config                   string      dg_config=(mmgdrs,bof2)
log_archive_dest                     string
log_archive_dest_1                   string      LOCATION=+MMGDRS1/
log_archive_dest_10                  string
log_archive_dest_2                   string      service=bof2 valid_for=(online
                                                 _logfiles,primary_role) db_uni
                                                 que_name=bof2
Any help will be highy appreciated
Chucks