DELETE OLD LOG FILES ON AWS RDS

Question

Is there a way to delete old log files and old backup logs from AWS RDS ? I am getting an alert "Storage size 200 GB is approaching the maximum storage ".

On the ON-Premise databases, we would go on the database server and delete old files, what is the solution provided by AWS RDS, Oracle

Answer

hi,

One of the options is to use RMAN tasks on Amazon RDS to backup and move the file to Amazon S3. The procedure to do so is here: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.RMAN.html.  RMAN can be used to backup archived redo logs to Amazon S3. You can create a script that connects to the RDS instance and uses RMAN to backup the logs to S3. You can then schedule this script to run periodically using the operating system's scheduler (e.g., cron on Linux)

Thanks
Arun

DELETE OLD LOG FILES ON AWS RDS

Contenuto pertinente