Successful Migration on New Server

On the 20th Feb 2010, we successfully migrated our entire system onto the new server, and the migrated the 9iR2 Production Database to 10gR2 Database (10.2.0.4), and the system were made available for the end users.

Just a little bit about the server configuration:

IBM x3650 Server, Xeon Quad Core E5430 2.66 GHz, with 16 GB RAM, having around 500 GB storage after RAID configurations.

The Testing took more time than planned, but it paid off really well. We tested the entire ERP Application and Database, in terms of Data Validation and Performance. And the test results were impressive. And from 21st Feb, users were online.

In the past 15 days, we carried out the SGA optimization , encountered an Oracle Bug (will discuss its workaround in separate post), Enterprise Manager was setup, RMAN Backups and other jobs were configured (same as it was before the migration), Clone Server were setup for periodic cloning, and the DEV and TEST Environments were also refreshed.

As of now, I am enjoying the 10g Database on a powerful server. We have also recieved good feedback from a couple of users, although formal feedback has not been collected yet. With a couple of weeks of more support, I am eyeing at 11g testing and upgrade preparations...