This content has been marked as final. Show 3 replies
what is your database size?.
follow below links for how to migrate data from file system to ASM
also have a link to below mention link
for further details consult MOS
Edited by: Asad99 on Mar 27, 2013 10:51 PM
Edited by: Asad99 on Mar 27, 2013 11:03 PM
Hope Your oracle 9i in 18.104.22.168 ( if not then follow upgrade path 9.2.*.* -> 22.214.171.124 -> 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
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.