DB Migration from the 11G in AIX to 12C R2 in Windows

I am migrating DB which contains Two Databases in Oracle 11G(AIX) to 12C R2 in Windows. I am facing difficulty  while full Transportable export, Because the EXPD command in AIX(Big Endien) doesn't support Transportable=always parameter.
I have decided to use approach where I  will create tablespaces and users first in Target DB and then import the Schemas one by one using parfile.

I have done below steps:
1. Exported the DB from the 11G using below command
         expdp system/password@VPMDB1 full=Y directory=xxxx logfile=xxxx
         expdp system/password@VPMDB2 full=Y directory=xxxx logfile=xxxx
2. Created Container DB in 12C and added pluggable DB
3. Executing SQL file to create table spaces, users in to pluggable DB but Pluggable DB has max limit of datafiles. But source db contains datafiles which exceeds max limit.

Is it possible to increase max limit or do I need install Oracle patch?
For second approach I used existing exported dump,So please let me know If above expdp queries will work or not?
Is there any other fastest way to export db. I need export databases from around ~30 Sites

Many Thanks In Advance
vinayak yAsked:
Who is Participating?
 
johnsoneSenior Oracle DBACommented:
You can use transportable tablespaces.  You just need to add a step to convert the Endian.

I will point you to the RMAN documentation that describes the whole process here.  I highly recommend reading the whole section, as moving data like this is pretty important and you shouldn't skim over it.  The specific pieces that you are looking for should be in this section.

Another approach would be to get everything running in Windows on 11g using an RMAN backup and convert.  Then do the upgrade as a second step.
1
 
Mark GeerlingsDatabase AdministratorCommented:
It should work to do DataPump exports and imports as you tried.  And yes, creating the tablespace and users in advance in the new database should make this process *MUCH* more likely to succeed.

If you have the tablespaces pre-created, it shouldn't matter how many data files the old system had.  This assumes that you created the tablespaces large enough to accommodate the data you need to import, or manually added enough additional data files to accommodate the data.
1
 
vinayak yAuthor Commented:
Thank you Johnson and Mark
0
 
Seth SimmonsSr. Systems AdministratorCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Split:
-- johnsone (https:#a42446236)
-- Mark Geerlings (https:#a42446621)


If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

seth2740
Experts-Exchange Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.