Sun Cluster Geographic Edition Data Replication Guide for Oracle Data Guard

ProcedureHow to Verify That Your Configuration Is Working Correctly

  1. Verify that the log file transmission is working.

    When the SQL> prompt is displayed, log in to one of the database instances on the cluster-paris cluster and perform a couple log switches.

    oracle (phys-paris-1)$ sqlplus '/ as sysdba'
    SQL> alter system switch logfile;
    SQL> alter system switch logfile;
  2. Check the ${ORACLE_HOME}/admin/sales/bdump/alert_sales1.log for any problems that might have prevented the logs from being archived.

    If there are errors, correct them. This process might take time. You can check that the network connectivity is correct by using the following command:

    oracle (phys-paris-1)$ tnsping salesdr-svc
    oracle (phys-newyork-1)$ tnsping sales-svc