This discussion is archived
3 Replies Latest reply: Mar 28, 2013 6:41 AM by marksmithusa RSS

Strategy to migrate a 9i single-instance to a 11g RAC database using TTS

Fabricio_Jorge Explorer
Currently Being Moderated
Hi all,

OS: Solaris 11
DB: 11.2.0.3.5

I am doing some tests to migrate a 9i database to a 11g database using TTS, from Solasi 9 to Solaris 11 (no convert required). The cenario is:

ServerA (Oracle 9i, datafiles in filesystem) ---> ServerB (Oracle 11g, datafiles in ASM)

My doubt is: How to copy the datafiles from the filesystem in ServerA throught the network, and put then in ASM on ServerB? After this operation a will attach the datafiles to the new database. I did some tests with RMAN COPY, first i copied (via OS command "cp") the test datafile to a staging area, accessible by both servers, then, logged on ServerB, i tryied to copy this datafile using RMAN COPY, but the error "datafile not found in the recovery catalog" appears to me.

What can i do to solve this "little' issue?

Thanks in advanec.
  • 1. Re: Strategy to migrate a 9i single-instance to a 11g RAC database using TTS
    Kh$n Journeyer
    Currently Being Moderated
    what is your database size?.

    follow below links for how to migrate data from file system to ASM

    http://www.oracleflash.com/10/How-to-migrate-Oracle-datafiles-to-ASM-storage-via-RMAN.html

    http://www.oracleflash.com/15/Migrate-Oracle-Flash-Recovery-Area-to-ASM-storage-via-RMAN.html

    http://www.oracleflash.com/14/How-to-migrate-online-redo-logs-to-Oracle-ASM-storage.html

    also have a link to below mention link

    http://docs.oracle.com/cd/B19306_01/server.102/b14238/expimp.htm#i262247

    for further details consult MOS

    NOTE 351598.1
    NOTE 287197.1



    Edited by: Asad99 on Mar 27, 2013 10:51 PM

    Edited by: Asad99 on Mar 27, 2013 11:03 PM
  • 2. Re: Strategy to migrate a 9i single-instance to a 11g RAC database using TTS
    moreajays Pro
    Currently Being Moderated
    Hi Fabricio,

    Hope Your oracle 9i in 9.2.0.8 ( if not then follow upgrade path 9.2.*.* -> 9.2.0.8 -> 11.2.*.*)

    You need to catalog backup of datafile & archives sets before attempting restore/recovery (post spfile/controlfile restore in mount stage)

    RMAN COPY & SWITCH should work to move FS datafile to ASM DG's

    Also you will need a startup upgrade to open 9i DB on top of 11g binary (catupgrd/catuupst/utlrp.sql)

    Refer below thread which may give you some hint

    recovering a 9i database into 11g from a destroyed database



    Thanks,
    Ajay More
    http://www.moreajays.com
  • 3. Re: Strategy to migrate a 9i single-instance to a 11g RAC database using TTS
    marksmithusa Journeyer
    Currently Being Moderated
    Hi, there,

    I have to say that I thought that the only reason you'd use TTS was to avoid Endian issues (going from AIX to Linux, for instance).

    I tried to move one database (about 500Gb or so) using TTS because we wanted to move it on Linux and it was very cumbersome to the point where the downtime was too great and the potential for data loss was not something the project were willing to sign off on - there are certain data types which won't be moved across using TTS.

    GoldenGate is another option that is supposed to guarantee zero downtime during the upgrade, but that too doesn't deal with some of the obscure data types very well. And it can be a pain to configure initially (a basic configuration is nice and easy, but if goes wrong, the most common solution is to 'start over again')

    I would advise following the standard upgrade process. You could build a 'shell' 9i database on Server B and then upgrade to 10g, build a 10g ASM, move the datafiles to ASM, upgrade the 10g ASM to 11g GI and then upgrade the database to 11gR2. You might have to move to the terminal release for 9i (I can't remember what that is).

    MOS/Metalink has really good upgrade docs, to be honest. They take you step by step through the process and are very thorough.

    Mark

Legend

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