Max,
Yes you can have a source of 10.2 to go to 11.2.0.4.
As with anything it would be highly recommended to practice this a few
times in a non-production environment that is hopefully similar
(duplicate?) of Production. By the time you get to Production it should be
easy to perform.
Alfredo
On Tue, May 19, 2015 at 12:23 PM, max scalf <oracle.blog3@xxxxxxxxx> wrote:
I believe the 11.2.0.4 is the destination, the source can be 10.2 ?
On Tue, May 19, 2015 at 11:57 AM, Alfredo Abate <alfredo.abate@xxxxxxxxx>
wrote:
Max,
Yes you can move from one version to another but I believe XTTS is only
available from 10.1 and up (the start of Data Pump).
The biggest concern I would have with the XTTS route is given the massive
size of your database. I personally have only performed this on databases
under 1 TB and the most time consuming part was the copy from one host to
another (I'm sure others may have some creative solutions around that).
I have never used the cross platform incremental transportable tablespace
so I really can't speak on that. I do see that the incremental
transportable tablespace option is only available with 11.2.0.4 so keep in
mind the prerequisites listed in MOS doc # 1389592.1.
Alfredo
On Tue, May 19, 2015 at 11:41 AM, max scalf <oracle.blog3@xxxxxxxxx>
wrote:
Thank you Seth and Alfredo.
Can we use XTTS to go from one version of oracle to another? and how
about using cross platform incremental transportable tablespace?
On Tue, May 19, 2015 at 11:37 AM, Alfredo Abate <alfredo.abate@xxxxxxxxx
wrote:
If using XTTS make sure you confirm the endian format from your source
to destination platform.
SELECT PLATFORM_NAME, ENDIAN_FORMAT from V$TRANSPORTABLE_PLATFORM;
Alfredo
On Tue, May 19, 2015 at 11:24 AM, Seth Miller <sethmiller.sm@xxxxxxxxx>
wrote:
Max,
After reviewing your emails with my microscope, I believe you have
already done 99% of the work. Using DataPump with the Compatible setting,
you can use cross-platform TTS to move tablespaces between 10.X and 11.X
databases. No need for the extra step of moving into a 10g database on the
new platform.
Seth Miller
On Tue, May 19, 2015 at 11:11 AM, max scalf <oracle.blog3@xxxxxxxxx>
wrote:
FOr me i am talking big database size, biggest one is about 62TB
On Tue, May 19, 2015 at 11:08 AM, Jack Applewhite <
jack.applewhite@xxxxxxxxxxxxx> wrote:
Depends on your DB size(s). We moved/upgraded our 10.2.0.4 DBs
from RH Linux servers to Oracle ODAs (Oracle Linux 5.9) via DataPump
Export/Import. Largest DB was about 500GB. It worked perfectly for
about 20
DBs.
We'll do the same in the near future for migrating the data from
our old 9i ERP database on HPUX to our new ERP on the ODAs, only we'll
have
to use legacy exp/imp for that.
----
Jack C. Applewhite - Database Administrator
Austin I.S.D. - MIS Department
512.414.9250 (wk)
------------------------------
*From:* oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>
on behalf of max scalf <oracle.blog3@xxxxxxxxx>
*Sent:* Tuesday, May 19, 2015 11:00 AM
*To:* D Kennel; Oracle Mailing List
*Subject:* Re: hp to linux...Redhat upgrade ?
Adding mailing list..
Even if i ran oracle 11.2.0.4 on 5.5, i would still have to
upgrade linux to 6.5(as that is our new standard)...and i think that
might
be a trivial task..
On Tue, May 19, 2015 at 10:49 AM, D Kennel <dkenlwork@xxxxxxxxx>
wrote:
Per Metalink Note 880989.1 (Requirements for installing Oracle
11gR2 RDB MS on RHEL/OEL 5x64), RDBMS 11.2.0.x can be installed on
linux
5.2 and greater, so should work on 5.5 as you’re proposing. I went
from
Tru64 to RHEL 4 using exp/imp, but haven’t used transportable
tablespaces,
so not sure on that part of it, though…
Deborah
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *max scalf
*Sent:* Tuesday, May 19, 2015 10:09 AM
*To:* Oracle Mailing List
*Subject:* hp to linux...Redhat upgrade ?
Hello List,
I wanted to get some thought from the list with regards to our
migration plan. We have an oracle database(10.2.0.3) running on HP
paric
11.11 and we want to move to Linux 6.5 and oracle 11.2.0.4. We have
moved
couple of our system from HP 11.31(oracle 11g) to Linux 6.5(oracle 11g)
using cross platform incremental transportable tablespace. My
question is
how does one goes about using the same process for 10g to 11g
migration and
also hp to linux. When i say Linux i am talking about RedHat.
We were thinking to do the following
- Install oracle version 10.2.0.3 on Linux(5.5), cant use 6.5
as oracle 10.2 is not supported with 6.5
- If we do above, then i can migrate to 10.2.0.3 followed by an
upgrade to 11g
- But the step above poses another huddle, oracle 11g is not
supported on Linux 5.5
- so would we upgrade the RHEL version to 6.5 --> but if we
upgrade to 6.5 and oracle remains on 10g that is not supported
I know we can use Golden Gate for something like this but we are
trying to find a cheap options and not have additional cost(Golden
gate),
also if we were to go down using Golden Gate i am guessing Golden Gate
version 10 is probably not supported for HP 11.11(source server).
What has the community done for such a migration project?
Confidentiality Notice: This email message, including all
attachments, is for the sole use of the intended recipient(s) and may
contain confidential student and/or employee information. Unauthorized
use
of disclosure is prohibited under the federal Family Educational Rights
&
Privacy Act (20 U.S.C. §1232g, 34 CFR Part 99, 19 TAC 247.2, Gov’t Code
552.023, Educ. Code 21.355, 29 CFR 1630.14(b)(c)). If you are not the
intended recipient, you may not use, disclose, copy or disseminate this
information. Please call the sender immediately or reply by email and
destroy all copies of the original message, including attachments.
