Download Amazon Relational Database Service User Guide

Amazon Relational Database Service User Guide
Oracle Database Log Files
The Oracle audit files provided are the standard Oracle auditing files. While Fine Grained Auditing is a
supported feature, log access does not provide access to Fine-Grained Auditing (FGA) events stored in
the SYS.FGA_LOG$ table and that are accessible through the DBA_FGA_AUDIT_TRAIL view.
The DescribeDBLogFiles API action that lists the Oracle log files that are available for a DB instance
ignores the MaxRecords parameter and returns up to 1000 records.
Switching Online Log files
In order to deliver a managed service experience, Amazon RDS does not provide shell access to DB
instances, and restricts access to certain system procedures and tables that require advanced privileges.
You can use the following Amazon RDS-specific implementations to switch online log files.
Oracle Method
Amazon RDS Method
alter system switch logfile;
exec rdsadmin.rdsadmin_util.switch_logfile;
Working with Oracle Trace Files
This section describes Amazon RDS-specific procedures to create, refresh, access, and delete trace
files.
Listing Files
Two procedures are available to allow access to any file within the background_dump_dest. The first
method refreshes a view containing a listing of all files currently in the background_dump_dest:
exec rdsadmin.manage_tracefiles.refresh_tracefile_listing;
Once the view is refreshed, use the following view to access the results.
rdsadmin.tracefile_listing
An alternative to the previous process (available beginning with version 11.2.0.3.v1) is to use "from table"
to stream non-table data in a table-like format to list DB directory contents:
SELECT * FROM table(rdsadmin.rds_file_util.listdir('BDUMP'));
The following query shows text of a log file:
SELECT text FROM table(rdsad
min.rds_file_util.read_text_file('BDUMP','alert_xxx.log'));
Generating Trace Files
Since there are no restrictions on alter session, many standard methods to generate trace files in
Oracle remain available to an Amazon RDS DB instance. The following procedures are provided for trace
files that require greater access.
API Version 2014-10-31
599