1.8 Audit trail commands

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.

1.8.1 ADD ATCONFIG

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, AUXnn. 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

1.8.2 ALTER ATCONFIG

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.

1.8.3 DELETE ATCONFIG

Use DELETE ATCONFIG to delete audit management configuration. After this command is carried out, Manager will not manage the associated audit trails.

Syntax

DELETE ATCONFIG at_name

at_name: The audit trail designation, that is MAT, AUXnn. The audit trail can also be expressed as a wildcard.

1.8.4 INFO ATCONFIG

Use INFO ATCONFIG to view processing information about audit trails that are defined by ADD ATCONFIG or ALTER ATCONFIG.

Syntax

INFO ATCONFIG at_name

at_name: The audit trail designation, that is MAT, AUXnn. The audit trail can also be expressed as a wildcard.

1.8.5 STATUS AUDITTRAIL

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.

Syntax

STATUS AUDITTRAIL at_name

at_name: The audit trail designation, that is MAT, AUXnn. The audit trail can also be expressed as a wildcard.