This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,039 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

DB migration assistance tool

abhinivesh.jain
abhinivesh.jain Member Posts: 307 Blue Ribbon
edited Jan 11, 2016 5:53PM in Database Ideas - Ideas

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

abhinivesh.jainctriebManish ChaturvediborneselLothar FlatzPravin TakpireKiran Pawarvinaykumar2
9 votes

Active · Last Updated

Comments