Troubleshooting the dataguard KM

The following section provides dataguard troubleshooting information:

  • The connection to standby instance is always made with sys/<Standby SYS Password>@<Standby TNS Entry> as sysdba. If the connection is not successful, you will get a corresponding error message.
  • When you change the password for the standby instances, you must remove and reconfigure the standby instance.
  • For any changes of the standby TNS entry at a primary instance, you need to remove and reconfigure the standby instance.
  • The ORACLE_DATAGUARD KM does not detect change of standby type, for example, the standby instance changes from a physical to a logical standby. In such mode change, you need to remove and configure the standby instance.
  • During the standby configuration, a primary instance might not be displayed in the primary instance list due to the following reasons:
    • The instance is not configured in PATROL for Oracle.
    • The instance is configured but it is not in open or in mount stage.
    • The instance is configured but disabled for monitoring PATROL for Oracle.
    • The instance does not have the "service=" entry in any of the log_archive_dest_n destinations.
Was this page helpful? Yes No Submitting... Thank you

Comments