Migration from Oracle 10G Solaris to Exadata X2-2

All posts relating to Oracle database administration.

Moderator: Tim...

Migration from Oracle 10G Solaris to Exadata X2-2

Postby ssadoglu » Sat May 25, 2013 5:00 pm

Hi Tim.

We're planning to migrate from Oracle 10G on Solaris to Oracle 11.2 on OEL5 Exadata X2-2 Quarter Edition in our test environment. My question : What kind of methods are you recommend to migrate? ( without zero-downtime as well as with zero-downtime)


Thanks & Regards,
ssadoglu
Senior Member
 
Posts: 58
Joined: Wed Feb 02, 2011 10:59 am

Re: Migration from Oracle 10G Solaris to Exadata X2-2

Postby Tim... » Sat May 25, 2013 7:01 pm

Hi.

Zero downtime is pretty much an impossibility, so let's taks about minimising down time.

You are converting between large endian (Solaris) and small endian (Linux), so you can't do an RMAN database convert. What are your options:

1) expdp/impdp : Logically the easiest way to upgrade and/or move data between platforms. Having said that, it is slow for large databases, giving you significant down time.

2) Transportable tablespaces : I said you can't do a full database convert because of the different endians, but that doesn't stop you doing converts of individual tablespaces. Assuming there are no interdependenties stopping it, transportable tablespaces can move the data between systems really fast.

3) If both instances were the same version, you could consider using data guard to setup a standby on the new system, then switch over, to effectively do the transfer really quickly. But as you have different versions, this is not supported.

For small databases, I always prefer data pump. I think it is a clean way to move between platforms and do upgrades.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Migration from Oracle 10G Solaris to Exadata X2-2

Postby ssadoglu » Sat May 25, 2013 7:32 pm

Hi.

We have approximately 5TB data. By the way , what do you think about Oracle GoldenGate ? So Does Oracle goldengate support for ExaData? For us , is it fast really?

Thanks in advance,
Regards,
ssadoglu
Senior Member
 
Posts: 58
Joined: Wed Feb 02, 2011 10:59 am

Re: Migration from Oracle 10G Solaris to Exadata X2-2

Postby Tim... » Sun May 26, 2013 6:14 am

Hi.

You will have to check version restrictions, but it should be possible to replicate using golden gate, the switch to the new server. Golden Gate is very expensive though. It's a lot of money to pay for one transfer.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Migration from Oracle 10G Solaris to Exadata X2-2

Postby ssadoglu » Wed May 29, 2013 5:45 am

Hİ Tim.

My last question is : How to migrate from Exadata X2-2 to Exadata X3-8 ? Just backup and restore? is there any MOS note related that? please clarify.
ssadoglu
Senior Member
 
Posts: 58
Joined: Wed Feb 02, 2011 10:59 am

Re: Migration from Oracle 10G Solaris to Exadata X2-2

Postby Tim... » Wed May 29, 2013 6:24 am

Hi.

Should be no different than any duplicate between RAC servers of the same OS.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Migration from Oracle 10G Solaris to Exadata X2-2

Postby ssadoglu » Sun Jun 09, 2013 1:31 am

Hi.

Sorry for delay.

Thanks so much.

Regards,
ssadoglu
Senior Member
 
Posts: 58
Joined: Wed Feb 02, 2011 10:59 am

Re: Migration from Oracle 10G Solaris to Exadata X2-2

Postby Tim... » Sun Jun 09, 2013 6:49 am

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 7 guests

cron