Details for Autonomous AI Database on Dedicated Exadata Infrastructure

Logging details for Autonomous AI Database on Dedicated Exadata Infrastructure logs.

Resources

Autonomous Container Database
Autonomous AI Database

Log Categories


API value (ID):	Console (Display Name)	Description
`databaselogs`	Database logs	Contains content from log files: Attention logs: $ORACLE_BASE/diag/rdbms/`<ORACLE_UNQNAME>`/$ORACLE_SID/log/attention.log Alert logs: $ORACLE_BASE/diag/rdbms/`<ORACLE_UNQNAME>`/$ORACLE_SID/trace/alert_$ORACLE_SID.log
`migrationlogs`	Migration logs	Contains content from log files: /u02/data/dbfs/`<CDB_NAME>`/`<PDBGUID>`/import.log /u02/data/dbfs/`<CDB_NAME>`/`<PDBGUID>`/export.log
`unifiedauditlogs`	Unified Audit Log	Contains content from the following log file:`/var/opt/oracle/log/unified_audit_logs/` For example, `/var/opt/oracle/log/unified_audit_logs/logtest1_syslog-unified-audit-db_251219_070438.json`

Database Log

The database log captures important system events and alerts from the Autonomous Container Database. Use these logs to monitor database health and quickly detect issues


Property	Description
level	The severity level of the log entry (for example, `INFO`, `ERROR`).
message	The text describing what the log entry reports, often details from the alert or attention log.
resourceId	The OCID of the Autonomous Container Database resource.
@version	Version of this log record format.
avmClusterId	OCID identifying the Autonomous VM Cluster associated with the database.
host	The hostname of the machine where the log was generated.
logFileType	Type of log file (for example, `syslog`, `alertlog`).
msg	The actual content or technical message from the log file.
oracle.logid	OCID of the log object in Logging.
path	File system path of the log file on the database server.
ts	Time of the log record, in epoch milliseconds.
id	Unique identifier for this log record.
oracle.compartmentid	OCID of the OCI compartment.
oracle.ingestedtime	When the log was ingested by OCI Logging, in ISO timestamp format.
oracle.loggroupid	OCID of the log group containing the log.
oracle.tenantid	OCID of the tenancy owning the resource.
source	The source hostname for the log record.
specversion	Version of the logging event specification (example: `1.0`).
subject	Description or source path associated with the log event.
time	Timestamp (ISO format) when the log event occurred.
type	Type of log entry, such as `ALERTLOGS`.
regionId	OCI region identifier for the resource.

Sample Autonomous Container Database Log

{
  "results": [
    {
      "data": {
        "datetime": 1700000000000,
        "logContent": {
          "data": {
            "@version": "1",
            "avmClusterId": "ocid1.autonomousvmcluster.publicsample..exampleuniqueid",
            "host": "db-host-example-01",
            "logFileType": "syslog",
            "msg": "NET (PID:123456): Archived Log entry 99999 added for B-EXAMPLE.T-1.S-100 LOS:0x0000000000000000 NXS:0x0000000000000000 NAB:12345 ID 0xdeadbeef LAD:1 [krse.c:0000]",
            "oracle": {
              "logid": "ocid1.log.publicsample..exampleuniqueid"
            },
            "path": "/path/to/oracle/diag/rdbms/DB_UNIQUE_NAME/DB_NAME/trace/alert_DB_NAME.log",
            "ts": 1700000000000
          },
          "id": "ocid1.autonomousvmcluster.publicsample..exampleuniqueid-1700000000000",
          "oracle": {
            "compartmentid": "ocid1.compartment.publicsample..exampleuniqueid",
            "ingestedtime": "2025-01-01T00:00:00.000Z",
            "loggroupid": "ocid1.loggroup.publicsample..exampleuniqueid",
            "logid": "ocid1.log.publicsample..exampleuniqueid",
            "tenantid": "ocid1.tenancy.publicsample..exampleuniqueid"
          },
          "source": "source-host-example-01",
          "specversion": "1.0",
          "subject": "/path/to/oracle/diag/rdbms/DB_UNIQUE_NAME/DB_NAME/trace/alert_DB_NAME.log",
          "time": "2025-01-01T00:00:00.000Z",
          "type": "ALERTLOGS"
        },
        "regionId": "example-region-1"
      }
    }
  ]
}

Migration Log

The migration log tracks Data Pump import and export operations for your Autonomous Database. Use these logs to audit migrations and troubleshoot data movement.


Property	Description
level	The severity level of this migration log entry (for example, `INFO`, `ERROR`).
message	Description of contents—typically about Data Pump import/export job results.
resourceId	The OCID of the Autonomous Database (PDB) being migrated or operated on.
@version	Version of the log record format.
avmClusterId	OCID of the Autonomous VM Cluster associated with the log.
host	Name of the host machine generating the log.
logFileType	Type of log file (generally `syslog` for migration events).
msg	Actual log content, typically the output or result of a migration (import/export) job.
oracle.logid	OCID of the log in OCI Logging.
path	File path of the Data Pump log (typically export/import log files).
ts	Epoch timestamp for the log event.
id	Unique identifier for this migration log record.
oracle.compartmentid	OCID of the OCI compartment for the resource.
oracle.ingestedtime	When the log event was ingested into OCI Logging (ISO timestamp).
oracle.loggroupid	OCID of the log group in which this log resides.
oracle.tenantid	OCID for the tenancy containing the resource.
source	Source hostname for the log event.
specversion	Version of the log event specification.
subject	Description or identifier for the resource or file connected to this log entry.
time	Time of the event (ISO date/time format).
type	Type of migration log, such as `DATAPUMPLOGS`.
regionId	OCI region code where the event occurred.

Sample Autonomous AI Database Migration Log

{
  "results": [
    {
      "data": {
        "datetime": 1700000000000,
        "regionId": "example-region-1",
        "logContent": {
          "data": {
            "@version": "1",
            "avmClusterId": "ocid1.cloudautonomousvmcluster.publicsample..exampleuniqueid",
            "host": "db-host-example-01",
            "logFileType": "syslog",
            "msg": "Job \"ADMIN\".\"SYS_EXPORT_SCHEMA_01\" successfully completed at Mon Jan 01 00:00:00 2025 elapsed 0 00:00:45",
            "oracle": {
              "logid": "ocid1.log.publicsample..exampleuniqueid"
            },
            "path": "/path/to/dbfs/logs/export.log",
            "ts": 1700000000000
          },
          "id": "ocid1.cloudautonomousvmcluster.publicsample..exampleuniqueid-1700000000000",
          "oracle": {
            "compartmentid": "ocid1.compartment.publicsample..exampleuniqueid",
            "ingestedtime": "2025-01-01T00:00:05.000Z",
            "loggroupid": "ocid1.loggroup.publicsample..exampleuniqueid",
            "logid": "ocid1.log.publicsample..exampleuniqueid",
            "tenantid": "ocid1.tenancy.publicsample..exampleuniqueid"
          },
          "source": "db-host-example-01",
          "specversion": "1.0",
          "subject": "/path/to/dbfs/logs/export.log",
          "time": "2025-01-01T00:00:00.000Z",
          "type": "DATAPUMPLOGS"
        }
      }
    }
  ]
}

Unified Audit Log

The Unified Audit Log provides detailed records of security and compliance events in an Autonomous Container Database (ACD), including user sign-ins, SQL actions, and both successful and failed operations. ACD collects records from the UNIFIED_AUDIT_TRAIL view and exports them every 10 minutes to files under /var/opt/oracle/log/unified_audit_logs/ on the database host. Then, the files are ingested into OCI Logging.


Property	Description
AUDIT_TYPE	Shows what kind of audit event this is (such as `Standard`).
SESSIONID	Unique number for each sign-in session.
PROXY_SESSIONID	Proxy session number, if someone is acting on behalf of another user.
OS_USERNAME	Username on the OS running the session.
USERHOST	The host name or location the command came from.
TERMINAL	Terminal session used, if used.
INSTANCE_ID	Identifies the database instance where the event happened.
DBID	The unique ID of the database.
AUTHENTICATION_TYPE	How the user connected (`database`, `network`, and so on).
DBUSERNAME	Name of the database account used.
CLIENT_PROGRAM_NAME	Program or tool used (like SQL*Plus).
ENTRY_ID	Internal event entry number.
STATEMENT_ID	ID for the SQL statement in this session.
EVENT_TIMESTAMP	Date and time when the action happened.
ACTION_NAME	What action was performed (for example, WRITE DIRECTORY).
RETURN_CODE	0 means the action succeeded; any other number is an error code.
OBJECT_SCHEMA	The database schema affected by the action.
OBJECT_NAME	The specific object (such as a table or directory) affected.
SQL_TEXT	The SQL command that was run, if available.
CURRENT_USER	The user currently signed in.
ADDITIONAL_INFO	Any extra facts, such as the unique name of the database.
UNIFIED_AUDIT_POLICIES	Which audit rule or policy matched this event.

Sample Unified Audit Log

Here's an example of a Unified Audit Log entry:

{
  "AUDIT_TYPE": "Standard",
  "SESSIONID": 1234567890,
  "PROXY_SESSIONID": 0,
  "OS_USERNAME": "os-user-example",
  "USERHOST": "host-example-01",
  "TERMINAL": "terminal-example",
  "INSTANCE_ID": 1,
  "DBID": 1111111111,
  "AUTHENTICATION_TYPE": "(TYPE=(DATABASE));(CLIENT ADDRESS=((PROTOCOL=beq)(HOST=169.254.0.1)));",
  "DBUSERNAME": "DB_USER_EXAMPLE",
  "CLIENT_PROGRAM_NAME": "client-program-example",
  "ENTRY_ID": 15,
  "STATEMENT_ID": 20,
  "EVENT_TIMESTAMP": "2025-01-01T00:00:00.000000",
  "ACTION_NAME": "WRITE DIRECTORY",
  "RETURN_CODE": 0,
  "OBJECT_SCHEMA": "SCHEMA_EXAMPLE",
  "OBJECT_NAME": "DIRECTORY_EXAMPLE",
  "SQL_TEXT": "BEGIN\n  -- Example statement for documentation only\n  NULL;\nEND;",
  "CURRENT_USER": "DB_USER_EXAMPLE",
  "ADDITIONAL_INFO": "DB_UNIQUE_NAME=\"db_unique_name_example\";",
  "UNIFIED_AUDIT_POLICIES": "AUDIT_POLICY_EXAMPLE"
}

Oracle Cloud Infrastructure Documentation