Oracle Faq

Hi,
1. Verify that the primary database is setup to remotely archive by checking the parameter log_archive_dest_2=’SERVICE=tnsname alias lgwr’;
2. Verify that remote archiving to the logical standby is successful.
Use the following query to determine the error
SQL> SELECT DEST_ID “ID”,STATUS “DB_status”,DESTINATION “Archive_dest”,ERROR “Error” FROM V$ARCHIVE_DEST;
When there is no error output is as shown
ID […]

Hi All,
Generally when Oracle dataguard is configured it is necessary to check progress of your database so as to make sure that archive logs are getting shipped to physical standby.
In order to check the progress of the dataguard you can use the following queries.
From Primary Destination.
SQL> select status,error from gv$archive_dest where dest_id=2; (where […]