We are planning to upgrade a 10.2.0.4 database to 126.96.36.199. Proper testing would be done in any of the test environments before the actual 'production' database is also upgraded.
However, can someone suggest if there are any known issues pertaining to the below which might come into light after we upgrade to 11g:
1. RMAN Backups - Note: Our catalog is still on 10g.
2. PL/SQL code which is part of the application running on this 10.2.0.4 database.
For any inputs, kindly let me know.
Pl post OS details.
For your RMAN question, pl ask in the RMAN forum - Recovery Manager (RMAN)
Most 10.2.0.4 SQL code will run faster on 11gR2 - this can only be validated by thorough testing.
Pl see these MOS Docs
Query Performance Degradation - Upgrade Related - Recommended Actions [ID 745216.1]
Using SQL Performance Analyzer to Test SQL Performance Impact of an Upgrade [ID 562899.1]
Things to Consider Before Upgrading to 188.8.131.52 to Avoid Poor Performance or Wrong Results [ID 1392633.1]