@@@@Platform-“OnPrem”
@@@@Product-“Database”
@@@@ReleaseVersion-“26.11”
@@@@info-map-label-“Investigating Logs for Errors”
Investigating Logs for Errors
Use Oracle Trace File Analyzer to analyze all of your logs across your cluster to identify recent errors.
-
To find all errors in the last one day:
$ tfactl analyze -last 1d -
To find all errors over a specified duration:
$ tfactl analyze -last 18h -
To find all occurrences of a specific error on any node, for example, to report
ORA-00600errors:$ tfactl analyze -search "ora-00600" -last 8h