This discussion is archived
5 Replies Latest reply: Nov 23, 2012 5:34 AM by onedbguru RSS

data migration from 10RAC to 11gRAC

LANCERIQUE Newbie
Currently Being Moderated
Hi Gurus,

We need to migrate Data from 10gRAC to 11gRAC without downtime. Migration need to performed from AIX to LINUX i.e. Big to little endian format.Also, 10gRAC is non ASM where 11gRAC is using ASM for storage. Both DB are at different locations. Please let me know different approaches, ideas for the migration.


Below are the specification's.

Old DB

DB - 10g RAC
OS - AIX.
DB prod size - 250GB
Schema size - 150Gb

New DB

DB - 11g RAC
OS - RHEL 6.2

Regards,
Nikhil Mehta.

Edited by: LANCERIQUE on Nov 21, 2012 10:34 PM
  • 1. Re: data migration from 10RAC to 11gRAC
    P.Forstmann Guru
    Currently Being Moderated
    See Re: DB upgrade 11g without stop the database

    I think that you cannot use transient logical standby because of the platform change: but you should be able to use Streams or Golden Gate.

    Edited by: P. Forstmann on 22 nov. 2012 13:10
  • 2. Re: data migration from 10RAC to 11gRAC
    LANCERIQUE Newbie
    Currently Being Moderated
    Hi Forstmann,

    Thanks for your reply.

    We are not having provision for golden gate. Is it possible to use any of the 11gR2 features like RMAN, impdp, traditional imp/exp??

    Regards,
    NM
  • 3. Re: data migration from 10RAC to 11gRAC
    user12028775 Newbie
    Currently Being Moderated
    LANCERIQUE wrote:
    Hi Forstmann,

    Thanks for your reply.

    We are not having provision for golden gate. Is it possible to use any of the 11gR2 features like RMAN, impdp, traditional imp/exp??
    See this:
    http://levipereira.wordpress.com/2011/01/23/how-convert-full-database-10g-linux-x86-64bit-to-aix-64bit-different-endian-format/
    Old DB
    DB - 10g RAC
    OS - AIX.
    New DB
    DB - 11g RAC
    OS - RHEL 6.2
    We need to migrate Data from 10gRAC to 11gRAC without downtime.
    No, with RMAN is not possible without downtime. (zero downtime with cross-platform is pretty hard, why you need zero downtime????)
  • 4. Re: data migration from 10RAC to 11gRAC
    LANCERIQUE Newbie
    Currently Being Moderated
    Thanks for your time.

    Zero down time is required as client don't want to have current production down impacting business. Idea is to make data migration online from DB end, change the pointers of current web,app server to new servers meanwhile take incremental backup on current production and then restore the same.

    Issue is we cant take incremental backup through exp/imp. If we take through RMAN, how we will change the backup to be compatible on cross platform.

    Regards,
    Nikhil Mehta.
  • 5. Re: data migration from 10RAC to 11gRAC
    onedbguru Pro
    Currently Being Moderated
    LANCERIQUE wrote:
    Thanks for your time.

    Zero down time is required as client don't want to have current production down impacting business. Idea is to make data migration online from DB end, change the pointers of current web,app server to new servers meanwhile take incremental backup on current production and then restore the same.
    If this was like-for-like platforms, this might be a possibility. however, you now have an endian change making this tenuous at best. How big is the database? What is the schema complexity (ie: triggers, foreign key constraints etc...)?

    Issue is we cant take incremental backup through exp/imp. If we take through RMAN, how we will change the backup to be compatible on cross platform.
    You **might** be able to use expdp (data pump) - again depending on schema complexity. Bottom line is that there WILL be downtime and to expect ZERO downtime is quite unrealistic.
    Regards,
    Nikhil Mehta.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points