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.

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply