Data Guard

Oracle Data Guard Chapter 3 - Implementing Standby Databases

Verify the Physical Standby Database

From
   V$ARCHIVE_DEST
SEE CODE DEPOT FOR FULL SCRIPT
 
Status    Error
--------- ----------------------------------------------
ERROR     ORA-12541: TNS:no listener

This view can be a starting point for troubleshooting any problem in Data Guard configuration. The same information can be gathered from the alert log file on the primary database. The content of the alert log file will look like the following:

Tue Sep 23 09:02:04 2003
Errors in file /oracle/appsdb/admin/bdump/appsdb_arc0_11977.trc:
ORA-12541: TNS:no listener

There will not be any error seen in the alert log file of the standby database. When the listener is started on both the databases and an Oracle Net connection is established, the arch process of the primary database will transfer the archived redo logs to the Oracle instance when the next redo log is archived on the primary database. An extract from the alert log file is given in the following example to explain this scenario:

Errors in file /oracle/appsdb/admin/bdump/appsdb_arc0_11977.trc: