Use ATCONFIG
commands to protect TMF audit trails until Extract has processed them. Manager uses ATCONFIG
commands to determine how to preserve audit files that are needed by Extracts.
The ATCONFIG
command specification can be abbreviated as AT
.
For details about managing audit resources, see Keeping Necessary Audit Available for Extract.
Use ADD ATCONFIG
to configure audit management options. With the ADD ATCONFIG
options, you can:
Duplicate to an alternative subvolume
Duplicate all audit files or a specified number of files
Purge audit trails from the alternative subvolume
You can override any previously specified option by adding NO
, as in NO PURGE
.
Note:
Contact Oracle GoldenGate support before using the DUP
, DUPFILES
, or PURGE
options. These options require storage that is not necessary if large enough audit trails can be specified when TMF is configured.
Syntax
ADD ATCONFIG at_name [, ALTLOC alt_subvolume] [, DUP | NO DUP | DUPFILES num_files | NO DUPFILES | PURGE | NO PURGE]
at_name
The audit trail designation, that is MAT
, AUX
nn
. The audit trail can also be expressed as a wildcard.
ALTLOC
alt_subvolume
Identifies an alternative subvolume to which audit trails are duplicated or restored from tape. ALTLOC
directs Extract to read audit from the alternative subvolume rather than from the production area.
Specify up to seven characters for the volume name.
DUP | NODUP
Duplicates audit files to the volume specified by ALTLOC
. DUP
has no effect if the file already exists as a TMF disk dump. DUP
copies audit files that are still needed by an Extract group.
DUPFILES
num_files
| NO DUPFILES
Duplicates up to num_files
audit files to the volume specified by ALTLOC
. Unlike DUP, DUPFILES
limits the number of files that can be copied to the alternative subvolume. When num_files
is reached on the alternative subvolume, the oldest audit file is purged to make room for the newest file. Enter ALTLOC
when this option is used.
PURGE | NOPURGE
Purges audit trails from the alternative subvolume when they are no longer needed. PURGE
has no effect when DUPFILES
is specified since DUPFILES
keeps a constant number of backup files.
Example
The following examples show the MAT
trail being added and an AUX
trail being altered.
ADD AT MAT DUPFILES 6, ALTLOC $DATA1.ALTTMF ALTER AT AUX01, ALTLOC $DATA1.EXTRACT, PURGE, DUP
Use ALTER
to change existing audit trail configuration parameters.
Syntax
ALTER ATCONFIG at_name [, ALTLOC alt_subvolume] [, DUP | NO DUP | DUPFILES num_files | NO DUPFILES | PURGE | NO PURGE]
See the ADD ATCONFIG
command for option descriptions.
Use STATUS AUDITTRAIL
to determine which audit trail files are still required by any Extract group. This command determines if a file exists, then supplies:
The location of the file.
Whether it is the original audit file (ORIG
), a duplicate audit file (DUP
), or a dump (DUMP
).
Whether the file is on tape or disk. If audit is on tape, this provides the information needed to restore dumps before processing — useful when an operator is not available while Extract processes are running.