Enable trace for SQLNET or network for Dataguard Environment

Enable trace for SQLNET or network trace for Dataguard Environment

Enable the trace on Primary Server for check the network issue

SQL> alter system set log_archive_dest_state_2=defer;
SQL> alter system switch logfile;
SQL> alter system set log_archive_trace=4095;
SQL> alter system set log_archive_dest_state_2=enable;
SQL> alter system switch logfile;

Disable the trace on Primary Server

SQL> alter system set log_archive_dest_state_2=defer;
SQL> alter system switch logfile;
SQL> alter system set log_archive_trace=0;
SQL> alter system set log_archive_dest_state_2=enable;
SQL> alter system switch logfile;

Command give you more detail of process running during dataguard

select inst_id, process, pid, client_process, client_pid, status,thread#,sequence# from gv$managed_standby;

Note:
Tracefiles are generated in ‘TRACE_DIRECTORY_SERVER’ in SQLNET.ora
TRACK following things:
ARCs Process activity.
RFS connection.
LGWR redo shipping network activity.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.