DB migration assistance tool

abhinivesh.jain

DB migration is complex process due to multiple factors involved in it like-

1. DB size

2. DB version

3. Endian

4. OS

5. RAC/Non-RAC

6. ASM/Non-ASM

7. Engineered system Vs. Non-engineered system

8. DB edition

9. Available downtime

10.Connectivity between source and target server

11. In-place Vs out of place etc.

Similarly there are many migration methods

1.Physical migration methods (like- RMAN, Data Guard, Transportable tablespace, transportable database, cross platform backup & Restore, ASM rebalance etc.)

2. Logical migration (like- CTAS, Golden Gate, Streams, Data pump, Export-import etc.)

3. Storage based

So why not create one tool "DB migration advisor" that will take various inputs like above and will suggests appropriate methods.

What do you think about this?

Thanks,

Abhi

ctrieb

In MOS is the Upgrade planner available:

https://support.oracle.com/epmos/faces/PatchHome?_adf.ctrl-state=9alp0k6dc_9&_afrLoop=44428763747593

bornesel

very nice idea... Oracle has very useful upgrade blog: https://blogs.oracle.com/UPGRADE/entry/welcome_to_the_oracle_database

Why not one tool?

abhinivesh.jain

Thanks for providing the details on Upgrade planner tool and upgrade blog.

Lothar Flatz

Maybe you should state what is different with your idea?

abhinivesh.jain

Lothar Flatz, Thanks for the suggestion. Here are key benefits of this Idea-

1. Such tool will reduce the time required for migration project.

2. Tool will help in choosing the right method Vs. randomly trying few methods or choosing method based on someone's limited knowledge.

3. Tool will help in faster decision making in migration projects since customer will have confidence in Oracle recommended migration methods

4. Faster decision making and faster project will eventually result in more business for Oracle.

Pravin Takpire

good idea. with 12C EM this can be done seamlessly including backup and other tasks.

abhinivesh.jain

good idea. with 12C EM this can be done seamlessly including backup and other tasks.

Thanks Praveen. Using EM to implement DB migration advisor related recommendations look like an extension of this idea. Good thought..

abhinivesh.jain

I am wondering if we get any reply from Oracle on feasibility of given Idea.