I have created a database and am importing a full dump file from another server, using expdp/impdp. I am only concered with impdp. The dmp file is around 2.5GB, and I had to increase the REDO logs from 50MB to 100MB as I kept running into the ORA-00257: Archiver error. Connect internal only until freed" error. The full database, once imported, is supposed to be roughly 7GB so I'm not even sure 100MB is the ideal size for redo logs.
Now, I want to import the dump file into a new schema and tablespace, for certain testing purposes. This is where I'm having issues. I'm using the options to remap the schema and to remap the tablespace. I believe I have everything in tact, but I'm again running into the same ORA-00257 issue. Based on the impdp routine below, is there anything different I should be doing? It all seems fairly straight forward but I'm getting tired of wrestling with this redo log issue. Maybe 100MB isn't large enough?
impdp system/passward dumpfile=expdat.dmp nologfile=y REMAP_SCHEMA=company:companytemp full=y REMAP_TABLESPACE=company_prod:companytemp_prod
I know there is an redo log advisor I can use, but I don't even have the tables imported yet or user connections to analyze against.
Oracle 10G on Linux Ent