ORACLE AND AWS RDS FOR ORACLE TIP: Archive log retention and switch log file in AWS RDS Oracle

I have an issue while I was migrating my Oracle database On-Prem to AWS RDS for Oracle. My archive area went 100% full and I wasn’t enable to connect in my database. When you create your database in AWS Cloud have in mind that you will also need to consider an additional space to your archive area. So the purpose of this post is to show to you how to check the retention of the archive logs in your RDS Oracle database plus to learn how to generate a new…