I need further details about the speed!!
Siegfried Ley, July 15, 2016 - 12:08 pm UTC
Hello,
thank you.
I need details to speed. how long does it last to run an upgrade to 10g on a v880 with 20000 tablespaces?
how long does it last to convert the 20000 tablespaces with rman to little endianess?
how long does it last to expdp the 20000 tablespaces on v880 ora10g?
how long does it last to impdp the 20000 tablespaces on a ora linux 7.2 with ora 12c?
many thanks in advance
BR
Siegfried
July 16, 2016 - 4:52 am UTC
An upgrade is typically unrelated to the size of the database, because it is predominantly the dictionary objects that are upgrade. Of course, if you have millions of objects in the database, then this could have an impact.
Converting tablespaces with RMAN is a read-entire-file-write-entire-file operation, so I'd expect it to be similar to the time/cost to backup the entire database.
But in all of these cases, no matter what *I* tell you, to get the best estimates for timings is for you to do some benchmarking on your own system.
another question in this case
A reader, July 18, 2016 - 9:39 am UTC
Ok i will talk about opion 1 because our team will favor this option! because we will switch to 12c and powerful machine as soon as possible.
let me repeat option 1: one is from the 9i system exporting all TS's with exp and go directly to the 12c and do with imp
all tablespaces in the new database
but this option does not work I guess because of the differnt endianess of Solaris sparc 10 and OL 7.2 and because of the not working direct connection between 9i and 12c.
Doing:
1.export them on 9i with exp .. transportable_tablespace=Y
2.copy datafile to 10g (same endianess),
3.import with imp .. transportable_tablespace=Y
4.exp them on 10g .. transportable_tablespace=Y
5. copy datafile to 12c
6.imp it in 12c .. transportable_tablespace=Y
Does this present a possible way?
BR
Siegfried
July 20, 2016 - 11:24 pm UTC
Yes - on the assumption that you are doing the endian conversion as part of your 10g =>12c.