ORACLE AND AWS RDS FOR ORACLE TIP: Where is my alert log at AWS RDS?

Managing your Oracle database on AWS RDS has some differences comparing it with the management of your Oracle database On-Prem. One of these differences is the daily retention of 30 days for the alert log in text and 7 days for the XML type. Therefore, how can I find my alert log? You can use the Amazon CloudWatch Logs to export the logs of your database but if you aren’t using this service you can query alertlog view or a table-like format as below: When you query the alertlog view,…