Sync RAC Standby 19c Database with ASM from RAC Primary Using Service
Due to unavailability of space in Data Diskgroup, standby was out of sync and after adding space it was not able to sync as the required archive logs were not available. Let's check the gap first. SQL> SELECT PROCESS, STATUS,THREAD#,SEQUENCE#,BLOCK# FROM v$managed_standby;
PROCESS STATUS THREAD# SEQUENCE# BLOCK#
--------- ------------ ---------- ---------- ----------
ARCH CLOSING 2 42265 4096
DGRD ALLOCATED 0