Archive logs not shipping to standby or datagaurd
++ Error in v$archive_dest from PR.
Run the below sql in PR
SQL>select error,status from gv$archive_dest where dest_id=2;
Below are the error by time to time i get.
ORA 03135: connection lost contact
ORA 12152: TNS:unable to send break message
ORA-16198: Timeout incurred on internal channel during remote archival
ORA-12152: TNS unable to send break message
ORA-12592: TNS bad packet
++Error in standby alert log
RFS :Possible network disconnect with primary database
Fetching gap sequence in thread 1, gap sequence 19565-19664
Thu Aug 14 09:23:01 2014
RFS[2981]: Assigned to RFS process 4390
RFS[2981]: Opened log for thread 1 sequence 19575 dbid 480254220 branch 818176800
CORRUPTION DETECTED: In redo blocks starting at block 1count 2048 for thread 1 sequence 19575
++ Primary databae trace error of alert log
krsb_stream_send: Error 3135 sending stream IOV
RFS network connection lost at host 'MZFCCSTD' error 3135
Error 3135 writing standby archive log file at host 'MZFCCSTD'
*** 2014-08-13 16:48:29.964 4265 krsh.c
LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)
*** 2014-08-13 16:48:29.964 4265 krsh.c
LNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
*** 2014-08-13 16:48:29.964 4265 krsh.c
Error 3135 for archive log file 3 to 'MZFCCSTD'
*** 2014-08-13 16:48:29.964 2864 krsi.c
krsi_dst_fail: dest:2 err:3135 force:0 blast:1
ORA-03135: connection lost contact
Closing Redo Read Context
Diag:
++ ping is working
++ tnsping is working with expected msec( < 2msec)
++ When we trasfer the file it scping with expected bandwidth as like estimate http://oracletechdba.blogspot.com/2014/08/to-calulation-oracle-data-guard-standby.html.
Solution:
++ We are using Juniper switch and by default SQL ALG is enabled.
So as per metalink 1130523.1 we have to disable.
"Work with your Network Administrator to make sure the following Firewall Features are disabled.
SQLNet fixup protocol
Deep Packet Inspection (DPI)
SQLNet packet inspection
SQL Fixup
SQL ALG (Juniper firewall)"
At Juniper switch level command to Disable SQL ALG globally using the "set security alg sql disable".
Or
You can try change the port of the listener in DR with respective change in PR tnsname.ora
++ Error in v$archive_dest from PR.
Run the below sql in PR
SQL>select error,status from gv$archive_dest where dest_id=2;
Below are the error by time to time i get.
ORA 03135: connection lost contact
ORA 12152: TNS:unable to send break message
ORA-16198: Timeout incurred on internal channel during remote archival
ORA-12152: TNS unable to send break message
ORA-12592: TNS bad packet
++Error in standby alert log
RFS :Possible network disconnect with primary database
Fetching gap sequence in thread 1, gap sequence 19565-19664
Thu Aug 14 09:23:01 2014
RFS[2981]: Assigned to RFS process 4390
RFS[2981]: Opened log for thread 1 sequence 19575 dbid 480254220 branch 818176800
CORRUPTION DETECTED: In redo blocks starting at block 1count 2048 for thread 1 sequence 19575
++ Primary databae trace error of alert log
krsb_stream_send: Error 3135 sending stream IOV
RFS network connection lost at host 'MZFCCSTD' error 3135
Error 3135 writing standby archive log file at host 'MZFCCSTD'
*** 2014-08-13 16:48:29.964 4265 krsh.c
LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135)
*** 2014-08-13 16:48:29.964 4265 krsh.c
LNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
*** 2014-08-13 16:48:29.964 4265 krsh.c
Error 3135 for archive log file 3 to 'MZFCCSTD'
*** 2014-08-13 16:48:29.964 2864 krsi.c
krsi_dst_fail: dest:2 err:3135 force:0 blast:1
ORA-03135: connection lost contact
Closing Redo Read Context
Diag:
++ ping is working
++ tnsping is working with expected msec( < 2msec)
++ When we trasfer the file it scping with expected bandwidth as like estimate http://oracletechdba.blogspot.com/2014/08/to-calulation-oracle-data-guard-standby.html.
Solution:
++ We are using Juniper switch and by default SQL ALG is enabled.
So as per metalink 1130523.1 we have to disable.
"Work with your Network Administrator to make sure the following Firewall Features are disabled.
SQLNet fixup protocol
Deep Packet Inspection (DPI)
SQLNet packet inspection
SQL Fixup
SQL ALG (Juniper firewall)"
At Juniper switch level command to Disable SQL ALG globally using the "set security alg sql disable".
Or
You can try change the port of the listener in DR with respective change in PR tnsname.ora
No comments:
Post a Comment