I have been tasked with upgrading the oracle database from Oracle 10g to 11g, but I am not sure what is the best way to go about doing that. A little background first, currently oracle 10g is on a Windows 2003 x32 server and I am suppose to move it to a new server the OS is 2008 x64. So should I:
A. From a backup tape restore the current 10g dbf's and then proceed to upgrade it to 11g from there or
B. Would it be better to start from scratch doing a clean install of 11g on the 2008 server and placing the dbf's accordingly
The only reason why I am asking this is I have never done an upgrade like this before so any assistance will help.