Oracle Dataguard errors/confusion
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