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…
Day: November 11, 2019
ORACLE AND AWS RDS FOR ORACLE TIP: ORA-20900: RDS only supports Oracle Managed Files. Check ddl and remove any
I have started to migrate some database On-Prem to AWS RDS. I have been migration Oracle On-Prem to AWS Oracle RDS which means that it will be a Homogeneous migration process. Then as one of the steps to migrate this database, I have taken all the DDL of the tablespaces On-Prem and decided to create in my target RDS database. Therefore, in the creation process I stuck in this error: According to Amazon documentation “Amazon RDS only supports Oracle Managed Files (OMF) for data files, log files, and control files.…