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:
SQL> CREATE TABLESPACE "TECHDATABASKETTBS" DATAFILE '/rdsdbdata/db/techdatabasket/datafile/techdatabasket01.dbf' SIZE 1073741824, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket04.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket03.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket02.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket14.dbf' SIZE 4294967296, 2 3 4 '/rdsdbdata/db/techdatabasket/datafile/techdatabasket13.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket12.dbf' SIZE 17179869184, 5 6 7 '/rdsdbdata/db/techdatabasket/datafile/techdatabasket11.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket10.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket09.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket08.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket07.dbf' SIZE 17179869184, '/rdsdbdata/db/techdatabasket/datafile/techdatabasket06.dbf' SIZE 17179869184, 8 9 10 '/rdsdbdata/db/techdatabasket/datafile/techdatabasket05.dbf' SIZE 17179869184 LOGGING ONLINE PERMANENT BLOCKSIZE 16384 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO; 11 12 13 14 15 16 17 18 CREATE TABLESPACE "TECHDATABASKETTBS" DATAFILE * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-20900: RDS only supports Oracle Managed Files. Check ddl and remove any named identifiers ORA-06512: at "RDSADMIN.RDSADMIN_TRIGGER_UTIL", line 235 ORA-06512: at line 2
According to Amazon documentation “Amazon RDS only supports Oracle Managed Files (OMF) for data files, log files, and control files. When you create data files and log files, you can’t specify the physical file names. “. Also, Amazon recommends the use of a Bigfile instead of Smallfile. Once when you create a Smallfile tablespace you will have to add a new datafile everytime because it is not possible to resize Smallfile tablespaces with Amazon RDS for Oracle. Then I decided to follow the recommendations and created my tablespace:
SQL> CREATE BIGFILE TABLESPACE TECHDATABASKETTBS DATAFILE SIZE 50G; Tablespace created.
Hi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)