Tracing can also be enabled in dataguard using the parameter "Log_Archive_Trace"
The values can be set using DG-Broker (if configured) or at SQL prompt as below.
// Tracing primary site
DGMGRL> edit database 'primary_db_name' set property LogArchiveTrace='1';
// Tracing standby site
DGMGRL> edit database 'standby_db_name' set property LogArchiveTrace='1';
Also this parameter can be set by issuing a SQL statement :
SQL> ALTER SYSTEM SET LOG_ARCHIVE_TRACE=1;
dgmgrl -debug / shutdown command will shutdown instance, generate trace file and then exit. Tracefiles will be generated in the specific dump location.
Values for LOG_ARCHIVE_TRACE are described in table bellow:
No comments:
Post a Comment