Issue:
Faced issue while setup new DR instance, getting below error in standby alert log.
CORRUPTION DETECTED: In redo blocks starting at block 135169 count 2048 for thread 1 sequence 15821
RFS[2]: Possible network disconnect with primary database
Solution:
The default port assignment for SQL*Net is 1521. This value used by Oracle for SQL*Net but Oracle Data Guard uses the same TCP Port – 1521.
For Cisco firewalls you can disable the SQL*Net ALG globally and then enable it as needed per policy using policy-maps.
Need to Turn off SQL*Net inspect.
We can use "fixup protocol sqlnet" for Turn off SQL*Net.
Ex:
no fixup protocol sqlnet 1521
Faced issue while setup new DR instance, getting below error in standby alert log.
CORRUPTION DETECTED: In redo blocks starting at block 135169 count 2048 for thread 1 sequence 15821
RFS[2]: Possible network disconnect with primary database
Solution:
The default port assignment for SQL*Net is 1521. This value used by Oracle for SQL*Net but Oracle Data Guard uses the same TCP Port – 1521.
For Cisco firewalls you can disable the SQL*Net ALG globally and then enable it as needed per policy using policy-maps.
Need to Turn off SQL*Net inspect.
We can use "fixup protocol sqlnet" for Turn off SQL*Net.
Ex:
no fixup protocol sqlnet 1521
No comments:
Post a Comment