script to check the DG sync status from primary Database

set time on
set echo off
set verify off
set feedback off
set pagesize 999 lines 200
col dest_name for a40
col destination for a40
col applied_seq# for 999999999
col archived_seq# for 999999999
select dest_name,status,destination,archived_seq#,applied_seq#
from v$archive_dest_status
where status='VALID';