Oracle Alert log view does not show Oracle Alert Log data older than three days (4309681)

Foglight does not show any alert log data older than few days. The calendar timeline was changed to include dates relative to the Oracle alert log file. Also the number of lines to retrieve data was increased in the agent properties, but no data older than few days appeared.

The data retention of the topology purge value is 3 days by default.

Please follow the steps below the change the data retention:

1. In the Foglight web console browse to "Administration | Data | Manage Retention Policies"
2. From the drop down field select "DB_Oracle"
3. Locate object "DBO_Alert_Log" and change the "Purge" value from 3 days to a larger value (1 month, 3 months).
4. Save changes

Note: This is a global Oracle agent value and will affect all Oracle agents. It can cause a data growth. It is advised to monitor the FMS repository database growth and expect to add additional storage if necessary or reduce the retention to compensate the growth.