This content has been marked as final. Show 2 replies
The best option is to read the Metalink document Note:316889.1 Complete checklist for manual upgrades to 10gR2. It has given all the pre requisites for the upgrades and the steps to be performed after the upgrade.
You will need to take a cold back up and the down time need to be increased to 2 hours to 2.5 hours at least as you might need to take lots of steps involving the tracking down of the invalid objects after catpatch or utlrp scripts. You will also need to comment the deprecated parameters in the database 10g which were there till 9i. You need to create the sysaux tablespace as well which is newly introduced in 10g.
You will need to take the database down at least for this period to take the cold backup before the upgrade and after that you may run the db in normal mode. Some of the steps involve you to startup upgrade and startup migrate. Thus, keep a cushion of time for yourself.
Hope it helps.