Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Database - Cross Platform Migration from 9i to 11g

user641642May 12 2014 — edited May 13 2014

Hi All,

I am into oracle database migration project.I need your help for this migration.

Please find the below details and suggest me the best method to implement this migration.

Oracle Database migration from 9i to 11g.

Source Details:

Database Version: 9i

OS: Sunsolaris (Big Endian)

Database size: 3.7 TB

Environment: Production(Standalone)

Target Details:

Database Version: 11g

OS: Linux (Little Endian)

Environment: Production (Standalone)

Since the source and target OS are in different Endian format,seems it should be the cross platform migration.

Since it is a production environment the downtime should be less.

Please suggest me the best method for this migration.

Thanks in Advance...

Comments

jgarry May 12 2014

How much space is there on the original system?  Can you isolate some of the data that is not being modified and convert it before any production conversion window?  How big is the window?  Do you have enterprise edition?  Do you have a fast network connection between them?

J.A. May 12 2014

Hi

  • Is there any historical information on your database ?, so maybe you can move this historical information to other tables and then do the migration in two parts transactional information and historical information ?
  • Or maybe you can do the migration by Application ? migrate the schemas that belong only to one application and other day the next application
  • I think you can use export to do the migration.
  • Could you do a test with export to test the time it takes you to export a Few GB ?

Regards

Warrior25 May 13 2014

Kindly provide the details...

Alvaro May 13 2014 — edited on May 13 2014

In my personal opinion,

You would be better off splitting this in two parts:

1) Upgrade prod to 11.2.0.4. It would be an out of place upgrade, minimal downtime only to run post upgrade scripts. Validate performance, check for new plans, all that good post upgrade performance stuff.

2) Then, use XTTS + Incremental Backups to migrate and convert tablespaces reducing downtime.

Your only options as it is now is either logical migration or traditional transportable tablespaces which depend on factors like: Network speed, size of data, how many objects (size of metadata) and so on, while your production remains read only for the whole process. If you can't do this migration in phases, which is often the case, I think the strategy above would actually sum up to be less downtime then a bulk migration of the whole database straight from 9i.

Srini Chavali-Oracle May 13 2014

Pl quantify "less" - zero downtime options are available - see the upgrade workshop presentation at Oracle Database Upgrade

The cost of performing the upgrade is indirectly proportional to the downtime requirement.

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 10 2014
Added on May 12 2014
6 comments
1,237 views