Troubleshoot using logs
Learn to troubleshoot common issues using OCI logging and logs found in your deployment backups, and collect diagnostics from your OCI GoldenGate deployment.
Related Topics
Process and error logs
You can integrate OCI Logging with OCI GoldenGate to enable, manage, and search GoldenGate process and error logs. Integration with the Logging service is optional.
- Error logs: Contain content from the
ggserr.log
file that logs processing events, messages, errors, and warnings generated by GoldenGate. - Process logs: Contain content from several log files for Administration Service, Distribution Service, Performance Metrics Service, Receiver Service, and Extract/Replicat Events.
Before you start using OCI Logging:
- Get familiar with basic concepts and terminology used in the OCI Logging service. See Logging Overview in the OCI Logging documentation.
- Create a group to manage access to log groups and log content. See Working with Groups in the OCI IAM documentation.
- Add policies to enable public logging for OCI GoldenGate.
Note:
You manage the lifecycle of the logs including logs that are automatically created for you by OCI GoldenGate. Logs aren't deleted when the job and job runs are deleted. Learn more about Observability and management pricing.Add policies to use OCI Logging with OCI GoldenGate
To enable service logs, you must grant your user manage access on the log group, and
access to the resource. Logs and log groups use the log-group
resource-type, but to search the contents of logs, you must use the
log-content
resource-type. Add the following policies:
allow group <group-name> to manage log-groups in compartment <compartment-name>
allow group <group-name> to manage log-content in compartment <compartment-name>
Enable Logging using the Oracle Cloud console
- On the Deployments page, select the deployment you want to enable logging for.
- On the Deployment details page, under resources select Logs.
- In the Logs table, under the Enable log column, select the Not enabled toggle to enable either Process logs or Error logs.
- In the Enable log panel, from the Compartment dropdown, select a compartment.
- For Log group, you can:
- Select a group from the dropdown
- Create a new group
- Leave it blank, and a default group is automatically assigned
- For Log name, enter a name.
- For Log retention, select the number of months from the dropdown.
- Click Enable log.
Wait for the status to become Active. After it is active, the Diagnostic Logs feature is turned on for the process and error logs. The process and error logs are technically 'Service logs' as they come from an Oracle Cloud Infrastructure native service like OCI GoldenGate.
Enable Logging for OCI GoldenGate in the OCI Logging service
Create a log group and configure a service log in the Logginge service if you don't have one already:
Deployment backup logs
You can manually backup an OCI GoldenGate deployment to Oracle Object Storage, and then download the backup locally. You can then locate the deployment logs to troubleshoot health issues.
To learn how to create a manual back up, see managing deployment backups.
The manual deployment backup contains the full GoldenGate deployment directory structure and files, including log and trail files. The directories and files that are helpful for troubleshooting include:
- /etc: configuration
- /etc/ogg: parameter files
- /var: log files, checkpoint, trail files, and so on
- /var/checkpt: checkpoint
- /var/data: trail files
- /var/report: report files
- /var/log: log files
- ER-events.log
- ggserr.log
- restapi.log
- adminsrvr.log
- pmsrvr.log
- distsrvr-stdout.log
- recsrvr-stdout.log
- distsrvr.log
- recvsrvr.log
- extract.log
- replicat.log
Collect diagnostics
Collect diagnostics to analyze or share information about your OCI GoldenGate deployment. The information collected can be shared with My Oracle Support if you encounter any issues.
- On the Deployments page, select the deployment for which to collect diagnostics.
- On the deployment's Details page, from the More actions menu, select Collect diagnostics.
- In the Collect diagnostics panel, complete the following fields, and then click
Collect diagnostics:
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.