Database upgrade for big database
Date: Fri, 24 Aug 2012 11:33:13 -0700 (PDT)
Can someone share his experience in upgrading some big databases like 1Tb or so from 10g to 11g and also moving them to new server. I had few database running in 10g and has to be moved to new server with 11g. So looking for some suggestion and any URl/Metalink Doc for reference.
One of them can be
1. Create standby server for 10g on new server
2. Install Oracle 11g with all required Paches
3. stop the primary and activate the Standby server
4. Upgrade the Standby server with 11g Software already installed
This process will save in installing Oracle 11g and performing any datapump export/import and save big downtime to few hours only while upgrading the environment.
Any more suggestions or reference will be helpful