Need a plan for migrating from Oracle 10gR2 to Oracle 11g

347795 pts.
Tags:
Oracle 10g
Oracle 11g
Oracle migration
Storage
Planning a migration from Oracle 10gR2 to Oracle 11g. Below are the specifications, what should I consider before starting a plan? Any experience in this - advice greatly appreciated. Conditions to meet during 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.

Software/Hardware used:
oracle 10g R2 migrating to Oraclle 11g

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • ITKE
    This question was asked on LinkedIn: http://bit.ly/9PTx2a
    347,795 pointsBadges:
    report
  • ITKE
    [...] Need a plan for migrating from Oracle 10gR2 to Oracle 11g, asked by ITKE and yet to be [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following