Upgrading from a 9i file system non-RAC database to 11g RAC?
We now have a project of migrating from a 9i file-system database to new 11g RAC servers. I'm wondering if anyone has experience or suggestions?
Here's more information of the project:
Existing/Source Database:
Version:9.2.0.7
Storage: OS file system
Size: about 1.3TB
It'll be moved to a clustered environment and has to be upgraded to 11gR2, and we hope we can minimize the downtime.
Here's my first thoughts:
1. Install 9i & 9i cluster on new servers.
2. Create 9i single standby database for the source database on new servers in a cluster file system configuration (using RMAN).
3. Convert the single standby database to 9i RAC standby database.