| Needed Plan for Migrating from Oracle 10g to 11g [message #435007] |
Sun, 13 December 2009 11:43  |
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 #435013 is a reply to message #435012] |
Sun, 13 December 2009 12:23  |
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 #435020 is a reply to message #435017] |
Sun, 13 December 2009 13:24 |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
lokeshorafaq wrote on Sun, 13 December 2009 20:18800 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.
|
|
|
|
|
|
|
|
| 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 |
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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
