The Standby Site Does Not Receive Logs Archived by the Primary Database If the standby site is not receiving the logs, the first thing you should do is obtain information about the archiving status of the primary database by querying the V$ARCHIVE_DEST view. Check especially for error messages. For example, enter the following query: SQL> SELECT DEST_ID "ID", 2> STATUS "DB_status", 3> DESTINATION "Archive_dest", 4> ERROR "Error" 5> FROM V$ARCHIVE_DEST; ID DB_status Archive_dest Error -- --------- ------------------------------ ------------------------------------ 1 VALID /vobs/oracle/work/arc_dest/arc 2 ERROR standby1 ORA-16012: Archivelog standby database identifier mismatch 3 INACTIVE 4 INACTIVE 5 INACTIVE 5 rows selected. If the output of the query does not help you, check the following list of possible issues. If any of the following conditions exist, the primary database will fail to archive to the standby site: 1. The service name for the standby instance is not configured correctly in the tnsnames.ora file at the primary site. 2. The service name listed in the LOG_ARCHIVE_DEST_n parameter of the primary initialization parameter file is incorrect. 3. The LOG_ARCHIVE_DEST_STATE_n parameter specifying the state of the standby archiving destination has the value DEFER. 4. The listener.ora file has not been configured correctly at the standby site. 5. The listener is not started. 6. The standby instance is not started. 7. You have added a standby archiving destination to the primary initialization parameter file, but have not yet enabled the change. 8. You used an invalid backup as the basis for the standby database (for example, you used a backup from the wrong database, or did not create the standby control file using the correct method).