LOG_ARCHIVE_TRACE

Property	Description
Parameter type	Integer
Default value	0
Modifiable	ALTER SYSTEM
Range of values	0, 1, 2, 4, 8, 16, 32, 64, 128, 256, 512, 1024, 2048, 4096, 8192
Basic	No
Real Application Clusters	Multiple instances can have different values.

LOG_ARCHIVE_TRACE controls output generated by the archivelog process.

This process can be initiated by any of the following:

· An ARCn background process (designated as ARCn in the output logs)

· An explicit session-invoked foreground process (designated as ARCH in the output logs)

The valid values have the following meanings:

· 0: Disable archivelog tracing (this is the default)

· 1: Track archival of redo log file

· 2: Track archival status of each archivelog destination

· 4: Track archival operational phase

· 8: Track archivelog destination activity

· 16: Track detailed archivelog destination activity

· 32: Track archivelog destination parameter modifications

· 64: Track ARCn process state activity

· 128: Track FAL (fetch archived log) server related activities

· 256: Track RFS Logical Client

· 512: Track LGWR redo shipping network activity

· 1024: Track RFS Physical Client

· 2048: Track RFS/ARCn Ping Heartbeat

· 4096: Track Real Time Apply

· 8192: Track Redo Apply (Media Recovery or Physical Standby)

You can combine tracing levels by adding together the values of the desired tracing levels. For example, a setting of 3 will generate level 1 and level 2 trace output. You can set different values for the primary and standby database.

When this parameter is set to the default value of 0, Oracle will still generate appropriate alert and trace entries in response to error conditions. If you change the value of this parameter dynamically in an ALTER SYSTEM statement, the changes will take effect at the start of the next archivelog operation.

Note:

1. This parameter was introduced in 8.1.6.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘LOG_ARCHIVE_TRACE’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
log_archive_trace	0	TRUE	FALSE	IMMEDIATE	TRUE	FALSE	Establish archivelog operation tracing level

Oracle initializatoin parameters