Observe Resource Logs with OCI Logging Service

The Oracle Cloud Infrastructure Logging service is a highly scalable and fully managed single pane of glass for all the logs in your tenancy.

Oracle Autonomous Database on Dedicated Exadata Infrastructure is an Oracle Cloud Infrastructure service that emits service logs, and you can enable or disable capturing these logs using the OCI Logging Service.

Logging provides access to logs from Oracle Cloud Infrastructure resources. These logs include critical diagnostic information that describes how resources are performing and being accessed. Refer to the OCI Logging Service for more details.

Privileges needed to view logs for Autonomous Database resources:
  • For an Autonomous Container Database (ACD), the user must have AUTONOMOUS_CONTAINER_DATABASE_INSPECT privilege.
  • For an Autonomous Database (ADB), the user must have AUTONOMOUS_DATABASE_CONTENT_READ privilege.

List of Oracle Autonomous Database on Dedicated Exadata Infrastructure Logs

Table - Autonomous Database Logs

Log Scope Description
Attention Logs Autonomous Container Database (ACD) The attention log is a JSON formatted file to capture critical events, making system diagnostics easier. There is a single attention log for each ACD. The attention log is extracted from the following path : 
$ORACLE_BASE/diag/rdbms/<ORACLE_UNQNAME>/$ORACLE_SID/log/attention.log
Alert Logs Autonomous Container Database (ACD) Alert logs contain important information about error messages and exceptions that occur during database operations. There is a single alert log for each ACD. The alert log is extracted from the following path: 
$ORACLE_BASE/diag/rdbms/<ORACLE_UNQNAME>/$ORACLE_SID/alert_$ORACLE_SID.log
Migration Logs Autonomous Database (ADB) The migration logs are the logs for Oracle Data Pump export and import operations. The data pump export and import logs are extracted from the following path:
/u02/data/dbfs/$CDB_NAME/$PDBGUID/import*.log
"/u02/data/dbfs/$CDB_NAME/$PDBGUID/export*.log

Note:

Attention Logs and Alert logs are collectively known as Database Logs.

You can view the sample log files for Database Logs and Migration Logs.

For more information on using Oracle Data Pump to export data from Oracle Autonomous Database on Dedicated Exadata Infrastructure, See Export Data Using Oracle Data Pump. For more information on the logs generated at the Autonomous Exadata VM Cluster and Exadata Infrastructure levels, See Auditing Capabilities in Autonomous Database.

Prerequisites to Enable OCI Logs

To enable service logs in a resource, a user must be granted manage access in the log group and access to the resource. In general, inspect access for the resource is enough, but check for specific resources. Inspect access provides permission to update the resource and permission for the log group that contains the log. In addition to the permissions to work with the log group, you must have the update permission for the resource, to add service logs to a resource. See Required IAM Policy for more details.

Enable Logging for an Autonomous Database Resource

You can enable logging for an ACD or an ADB. The procedure to enable logs for an ACD or ADB is the same as the procedure followed for any OCI resource. See Enabling Logging for a Resource for more details.
  • From the Logs section in the Logging service, click Enable Service Log.
  • Choose your compartment, select Autonomous Database Dedicated as the service, and choose the corresponding resource (the specific ACD or ADB).
  • For ACD the Log Category must be Database Logs and for an ADB it must be Migration Logs.
  • Provide a name for your log file.
For an ACD resource, you can create a database log (for database versions 23ai onwards), which consists of an Attention log and an Alert log. For an ADB, you can create a migration log which consists of data pump logs.

Note:

Attention logs are available from database versions 21c onwards.

Viewing Logs for an Autonomous Database Resource

You can search and filter the Database logs and Migration logs of your Autonomous Database resource from the OCI console.
  • Open the navigation menu and select Observability & Management. Under Logging, select Search.
  • You can use custom filters. Additionally, you can search for logs based on their type. You can also filter and limit logs based on time.
  • The log data in the Explore and Visualize tabs is reloaded according to your filter settings.
See Search Logs using the OCI console for more details.