Jump to content
ks.sivakumar

AWS Oracle RDS Instance Maintenance

Recommended Posts

Hi Team,

 

one of our Oracle DB was into AWS oracle RDS instance, Hence unlike our usual HP servers , we are not option to login into the server

and manage / remove archive log etc.,

 

Hence in the above situation how do I remove my archive logs from in AWS RDS instance.

 

else, where will I get the support for AWS oracle RDS instance Manintenance. Please advice.

 

Thanks in Advance,

Siva.

Share this post


Link to post
Share on other sites

Hi Siva,

Welcome to the perils of the cloud!

As you know, there is no way to remove OS files without access to the server file system!

We would expect that AWS would monitor for full mount points, but they may just wait until your DB licks up, trying to write a new archived redo log.

Amazon sez that you can use these SQL*Plus commands to adjust the archived redo log retention period:

set serveroutput on exec rdsadmin.rdsadmin_util.show_configuration;

See details here:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.Log.html

Good luck!

Share this post


Link to post
Share on other sites

Hi Burleson,

Many Thanks for your support and reply.

I too know those retention options which supports rdsadmin.rdsadmin_util.

But if we want to delete old archive log files how shall we do ???.

FYI: I too set the system for archive log retention for only 2 hours, but still old archive log files are exist 

in the system.

Kindly help for the above.

Siva..

 

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×