Home » RDBMS Server » Server Administration » Needed Plan for Migrating from Oracle 10g to 11g (Solaris)
Needed Plan for Migrating from Oracle 10g to 11g [message #435007] Sun, 13 December 2009 11:43 Go to next message
lokeshorafaq
Messages: 9
Registered: December 2009
Location: NJ
Junior Member
Migrating from Oracle 10gR2 to Oracle 11g

Conditions to met while migration:

1) Currently Our Production Database 10gR2 is on Solaris server. (Server- N3000).

2) And now we are migrating to Oracle 11g on solaris server. (Server- N5000).

3) Our Database is running on 24X7 basis, The Applications running on this database is Prepaid Card Processing.

4) We have total 14 Application schemas in our database, In that 4 schemas need dynamic syncing with new 11g database.

5) In these 4 schemas we have around 120 tables. We need dynamic syncing for these tables.

6) And the load impact on the database is less in between 9:30pm and 12:00am and 6am to 9am.

7) Our database has about 41/2 million transactions per day, and we generate about 500 archived redo log files per day.

9) The important thing is we can't put any impact or load on the redolog files.

10) One more Important thing is we dont have any test databases.

10) The client is looking for database downtime is in between (20 to 30) mins.

10) This Production database doen't have the Disaster Recovery.

11) And we are taking storage(SAN Based) backups.

 

So Based on this Scenario, The Client need a Plan to Migrate the Database.

If any one knows solution for this please post here.

Thanks,
Re: Needed Plan for Migrating from Oracle 10g to 11g [message #435010 is a reply to message #435007] Sun, 13 December 2009 11:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is none.
Good luck.

Regards
Michel
Re: Needed Plan for Migrating from Oracle 10g to 11g [message #435011 is a reply to message #435007] Sun, 13 December 2009 12:00 Go to previous messageGo to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
Hi,

You can use the database upgrade assistant utility (DBUA)for upgrading the database.

I feel that 30 mintes will be too short to complete the production database upgraded. Please check if you could get an extended downtime.

http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/preup.htm#i1007718

Regards,
Antony
Re: Needed Plan for Migrating from Oracle 10g to 11g [message #435012 is a reply to message #435011] Sun, 13 December 2009 12:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I feel that 30 mintes will be too short to complete the production database upgraded.

For sure, above all if you also count the backup time.
This is why I said it is not possible.

Regards
Michel
Re: Needed Plan for Migrating from Oracle 10g to 11g [message #435013 is a reply to message #435012] Sun, 13 December 2009 12:23 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Depends on the strategy.

If I understand correctly, the new database will be on a new server.

When it's a Hardware/OS/Oracle version upgrade all in one, I usually completely install the new server, create a new database there (which also gives you a test database to try things), and then on the "switch" date I shut down the applications on the old server, run an export/import, then start up the applications on the new server.

There basically the only factor that influences the downtime is how long it takes to do the export/import, which can be anything between a few minutes and a few days, depending on how much data there is.

Re: Needed Plan for Migrating from Oracle 10g to 11g [message #435014 is a reply to message #435007] Sun, 13 December 2009 12:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Currently Our Production Database 10gR2 is on Solaris server.
What is approximate size of current DB?
Re: Needed Plan for Migrating from Oracle 10g to 11g [message #435017 is a reply to message #435014] Sun, 13 December 2009 13:18 Go to previous messageGo to next message
lokeshorafaq
Messages: 9
Registered: December 2009
Location: NJ
Junior Member
800 GB
Re: Needed Plan for Migrating from Oracle 10g to 11g [message #435018 is a reply to message #435017] Sun, 13 December 2009 13:21 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>800 GB
expdp will take multiple hours to complete
impdp will take at 2 times the duration of the expdp.

ROCK<=>lokeshorafaq<=>Hard_Spot
Re: Needed Plan for Migrating from Oracle 10g to 11g [message #435020 is a reply to message #435017] Sun, 13 December 2009 13:24 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
lokeshorafaq wrote on Sun, 13 December 2009 20:18
800 GB


OK, forget the 20 to 30 minutes. Or forget to do it in one step.

You could probably set up a completely NEW environment, then migrate the data for each schema one by one while the application is running, and then do some sort of "switch over"

But that would depend heavily on the application, so you have to go talk to the people that wrote the application.

Re: Needed Plan for Migrating from Oracle 10g to 11g [message #435021 is a reply to message #435018] Sun, 13 December 2009 13:24 Go to previous messageGo to next message
lokeshorafaq
Messages: 9
Registered: December 2009
Location: NJ
Junior Member
Yup....

So Thats the reason..I am looking for is there any alternate solution for this.

I suggested to client..Implimenting streams..reflects no downtime necessary..but they were saying..it will show some redolog size impact on the prod database.
Re: Needed Plan for Migrating from Oracle 10g to 11g [message #435022 is a reply to message #435021] Sun, 13 December 2009 13:46 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Consider the following assuming current DB running in archive redo enable mode.

Establish a DataGaurd like environment between old & new system; both running V10.

When you are ready to test you stop shipping redos to new system.
Next run dbua from V11 & time the upgrade process.
You can then run acceptance tests against V11 DB.
After all is OK on V11, overwrite with another copy of Prod & continue to ship redo logs from Prod/Primary to standby.

At the scheduled hour SHUTDOWN & proceed to run dbua for real.

If at any point bad things occur, you simply STARTUP old DB.
What is the best way to copy 800GB data to another server in less time. [message #435027 is a reply to message #435014] Sun, 13 December 2009 22:02 Go to previous messageGo to next message
lokeshorafaq
Messages: 9
Registered: December 2009
Location: NJ
Junior Member
Hi,

I am Planning to move 800 GB data from one database to the other. Here each database is on its own server. I mean both databases are on different servers. What is the best and efficient method to copy/move data from one database to the other.

1) I am Looking for less time to copy it.
2) And What is the best Utility.

Q: Can I copy this 800GB data in 2 hours Using DataPump.
Q: If I Use Datapump with Parallel Processing. Does it show any effect on redologs.


*** I have few more doubts.
1)Q: Can I clone database from 10g to 11g. Here source is 10g.
(Using RMAN/Manually).

Please Give me answers by your personal experience.

Thanks.
Lokesh.
Re: What is the best way to copy 800GB data to another server in less time. [message #435028 is a reply to message #435027] Sun, 13 December 2009 22:11 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>What is the best way to copy 800GB data to another server in less time.
one rcp process for each data file to be transfered & all run concurrently which saturates network & disk subsystem for duration.

Is existing Production DB running with archive redo enabled?
Re: What is the best way to copy 800GB data to another server in less time. [message #435030 is a reply to message #435028] Sun, 13 December 2009 22:17 Go to previous messageGo to next message
lokeshorafaq
Messages: 9
Registered: December 2009
Location: NJ
Junior Member
Yes My database is running on Archivelog Mode...
Re: What is the best way to copy 800GB data to another server in less time. [message #435033 is a reply to message #435030] Sun, 13 December 2009 22:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
What is the maximum sustained data transfer rate between the 2 systems across the network?

Once you have this number, you can calculate the minimum time it will take to transfer the whole 800GB.
Re: What is the best way to copy 800GB data to another server in less time. [message #435036 is a reply to message #435033] Sun, 13 December 2009 22:48 Go to previous messageGo to next message
lokeshorafaq
Messages: 9
Registered: December 2009
Location: NJ
Junior Member
How Can I Find this...maximum sustained data transfer rate between the 2 systems across the network?


Thanks For Responding,
Lok.
Re: What is the best way to copy 800GB data to another server in less time. [message #435037 is a reply to message #435036] Sun, 13 December 2009 22:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>How Can I Find this...maximum sustained data transfer rate between the 2 systems across the network?
some ftp implementations display it.
come rcp implementations display it.

alternatively how long does it take to transfer a 1GB file between systems?
Take that time & multiply by 800 to determine minimum time to transfer DB.
Re: What is the best way to copy 800GB data to another server in less time. [message #436148 is a reply to message #435037] Mon, 21 December 2009 20:33 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
how about just Migration of DataFiles only ? That shuld suffice I think.

I hope from 10G to 11G it supports.

Regards,
Rahul
Re: What is the best way to copy 800GB data to another server in less time. [message #438519 is a reply to message #435027] Sun, 10 January 2010 03:12 Go to previous message
nhameed
Messages: 3
Registered: January 2010
Location: Jeddah
Junior Member
Check the Transportable Tablespace option, if its compatible option for such transfer.
Previous Topic: Oracle 10g
Next Topic: Database server slow
Goto Forum:
  


Current Time: Mon Nov 04 11:18:43 CST 2024