1

I have a requirement to extract data from a third party RDS Oracle table whenever it is updated or inserted. I thought of creating a trigger in the third party DB and calling a Lambda function to extract data when an insert happens. The third party has refused to allow external overheads like triggers in their system for our purpose. Considering this, I am analyzing over utlizing Cloudwatch logs to watch for inserts without intervening their DB setup. When instance table is inserted/updated, can this info be logged in cloudwatch or no?

Shivani
  • 85
  • 5

1 Answers1

2

Yes, you can configure your Amazon RDS for the Oracle DB instance to publish log data to a log group in Amazon CloudWatch Logs. With CloudWatch Logs, you can analyze the log data, and use CloudWatch to create alarms and view metrics. Amazon RDS publishes each Oracle database log as a separate database stream in the log group. For example, if you configure the export function to include the audit log, audit data is stored in an audit log stream in the /aws/rds/instance/my_instance/audit log group. RDS for Oracle supports the following logs:

  • Alert log
  • Trace log
  • Audit log
  • Listener log
  • Oracle Management Agent log enter image description here

Ref: Publishing database logs to Amazon CloudWatch Logs

Arpit Jain
  • 1,599
  • 9
  • 23
  • hi Arpit, okay thank you for this information. Will go through the link you provided as well. But these seem more like general instance metrics being logged. I hope you went through the specific ask of say, we have a data table named TableA in the instance. When this TableA has an insert, need to know of the same. Is this recorded under any of the categories you have provided? thanks. – Shivani Mar 31 '23 at 15:59
  • 1
    I believe it should be captured with General Logs. – Arpit Jain Mar 31 '23 at 17:47
  • 1
    That is great, should do I think. I will check more on this, thank you. – Shivani Apr 03 '23 at 11:53