How to Troubleshoot Logical standby database?
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 […]