Hi,
Running a X5-2 ODA box in RAC mode. 18.3 grid, 12.1.2.0 database and v6 of linux (I believe).
Standard Dataguard only and not using the broker.
I have over 50 databases and growing.
All primary databases are shipping their logs to the secondary for backup.... except one. I've looked and looked and I've missed something.
When I restart the MRP process on secondary, the logs catchup and then just stop. No errors in the alert log, no errors in v$dataguard.
I do see this in the secondary alert log:
Media Recovery Log /u01/app/oracle/fast_recovery_area/datastore/fowldr/FOWLDR/archivelog/2020_03_06/o1_mf_2_952_h658zrmt_.arc
Media Recovery Waiting for thread 2 sequence 953
Fri Mar 06 14:26:55 2020
Media Recovery Log /u01/app/oracle/fast_recovery_area/datastore/fowldr/FOWLDR/archivelog/2020_03_06/o1_mf_2_953_h658zx2h_.arc
Media Recovery Waiting for thread 2 sequence 954
Fri Mar 06 14:30:30 2020
Direct NFS: Please check the permissions for server nas-dev.
Fri Mar 06 14:30:30 2020
Note: Some NFS servers require 'insecure' to be specified as part of the export.
Fri Mar 06 15:30:39 2020
Expanded controlfile section 28 from 819 to 1638 records
Requested to grow by 819 records; added 6 blocks of records
Thread Last Seq Received Last Seq Applied
---------- ----------------- ----------------
1 121 121
2 953 953
sequence 953 was processed but the secondary never see's 954. It acts like its hung and this is the only database acting this way.
Any thoughts on what I could check? Continually restarting MRP for this guy is not an option.
Thank you in advance for any help.
Mark