Managing Oracle Database and Oracle Grid Infrastructure Diagnostic Data

21 Managing Oracle Database and Oracle Grid Infrastructure Diagnostic Data

This section enables you to manage Oracle Database and Oracle Grid Infrastructure diagnostic data and disk usage snapshots.

Managing Automatic Diagnostic Repository Log and Trace Files
Use the managelogs command to manage Automatic Diagnostic Repository log and trace files.
Managing Disk Usage Snapshots
Use tfactl commands to manage Oracle Trace File Analyzer disk usage snapshots.
Purging Oracle Trace File Analyzer Logs Automatically
Use these tfactl commands to manage log file purge policy for Oracle Trace Analyzer log files.

21.1 Managing Automatic Diagnostic Repository Log and Trace Files

Use the managelogs command to manage Automatic Diagnostic Repository log and trace files.

The -purge command option removes files managed by Automatic Diagnostic Repository. This command clears files from “ALERT”, "INCIDENT", "TRACE", "CDUMP", "HM", "UTSCDMP", "LOG" under diagnostic destinations. The -purge command also provides details about the change in the file system space.

If the diagnostic destinations contain large numbers of files, then the command runs for a while. Check the removal of files in progress from the corresponding directories.

To remove files, you must have operating system privileges over the corresponding diagnostic destinations.

To manage Automatic Diagnostic Repository log and trace files:

To limit purge, or show operations to only files older than a specific time:

$ tfactl managelogs -older nm|h|d Files from past 'n' [d]ays or 'n' [h]ours or 'n' [m]inutes

For example:

$ tfactl managelogs -purge -older 30d -dryrun 

$ tfactl managelogs -purge -older 30d

To get an estimate of how many files are removed and how much space is freed, use the –dryrun option:
For example:
```
$ tfactl managelogs -purge -older 30d -dryrun
```

To remove files and clean disk space:

For example:

$ tfactl managelogs -purge -older 30d 

$ tfactl managelogs -purge -older 30d –gi

$ tfactl managelogs -purge -older 30d -database

To view the space usage of individual diagnostic destinations:

For example:

$ tfactl managelogs -show usage

$ tfactl managelogs -show usage –gi

$ tfactl managelogs -show usage -database

Related Topics

tfactl managelogs

21.2 Managing Disk Usage Snapshots

Use tfactl commands to manage Oracle Trace File Analyzer disk usage snapshots.

Oracle Trace File Analyzer automatically monitors disk usage, records snapshots, and stores the snapshots under tfa/repository/suptools/node/managelogs/usage_snapshot/.

By default, the time interval between snapshots is 60 minutes.

To manage disk usage snapshots:

To change the default time interval for snapshots:
```
$ tfactl set diskUsageMonInterval=minutes
```
where minutes is the number of minutes between snapshots.
To turn the disk usage monitor on or off:
```
$ tfactl set diskUsageMon=ON|OFF
```

21.3 Purging Oracle Trace File Analyzer Logs Automatically

Use these tfactl commands to manage log file purge policy for Oracle Trace Analyzer log files.

Automatic purging is enabled by default on a Domain Service Cluster (DSC), and disabled by default elsewhere. When automatic purging is enabled, every 60 minutes, Oracle Trace File Analyzer automatically purges logs that are older than 30 days.

To purge Oracle Trace File Analyzer logs automatically:

To turn on or off automatic purging:
```
$ tfactl set manageLogsAutoPurge=ON|OFF
```

To adjust the age of logs to purge:

$ tfactl set manageLogsAutoPurgePolicyAge=nd|h

To adjust the frequency of purging:

$ tfactl set manageLogsAutoPurgeInterval=minutes