RFS issue

From: vinod kumar <kuvinod29_at_gmail.com>
Date: Wed, 21 Feb 2024 19:54:35 +0530
Message-ID: <CADKomcxpAp-LeuvgKBcaq_a-RWW5et10LU+AnK1ZktRxy+YCag_at_mail.gmail.com>

Dear Experts,

Please help me with below RFS issue below. RFS was not working. In production database alert log network disconnect with primary database reported. I have asked to check with the network team, but as per the network team no issue from their end . Issue resolved by the customer after adding lgwr in log_archive_dest_2. I don't understand what has been changed at the network layer after adding LGWR in log_archive_dest_2. And what would be the impact of the performance of the database?

TNS-12535: TNS:operation timed out
ns secondary err code: 12609
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.31.15.44)(PORT=22631)) 2024-02-09T22:05:55.647031+05:30
rfs (PID:26657): Possible network disconnect with primary database <<<<< Network issue

rfs (PID:26657): while processing B-1132782267.T-1.S-0 BNUM:0 BCNT:0
rfs (PID:26657): Current process action IDLE, elapsed idle time 10
rfs (PID:26657): RFS client GAP MANAGER (PID:31020)

2024-02-09T22:05:56.069664+05:30

alter system set log_archive_dest_2='service=STANDBY lgwr async noaffirm valid_for=(all_logfiles,primary_role) db_unique_name=STANDBY'; alter system set log_archive_dest_2='service=STANDBY async noaffirm valid_for=(all_logfiles,primary_role) db_unique_name=STANDBY';

Regards
Vinod

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 21 2024 - 15:24:35 CET