Upgrade 4.6C to ECC 6.0 5 Tb Oracle 10g database takes too long
We´ve just run an upgrade test with a 5Tb database and takes too long so our downtime will be more than 3 days, is there any documents that can lead us to get a better downtime some way
Any help will be appreciated.
4.6C (4.6D ext kernel)
Oracle 10g with 5Tb of data
Jing Ma replied
I think I may be qualified to answer your questions.
our database is 2TB and the technical down time is only 6 hours. Hopefully this benchmark can make your feel comfortable.
If you read some SAP presentation, the downtime is not related with the database size. so even your database is double our size, the downtime may not be doubled.
The tricks for reducing the downtime is simple. You need to have a good Basis/DBA. The first time should be painful but you need to find all the way to speed it up. Here are some common ones.
1. Search for SAP notes to see which processes could be run in parallel.
2. Watch the database to identified slow SQLs. You can add indexes to speed it up.
3. Check the stats for new tables during the upgrade. The new tables could cause some execution plan problems.
4. It is hard to say you need to archive some tables or not. As SAP says it depends. It will be difficult running archiving project with upgrade project.
The bottom line is a good Basis. Every software is peopleware.