This content has been marked as final. Show 6 replies
Pl post details of OS and database versions on source and target.
user503988 wrote:This is the recommended approach as all tasks are automated
Please let me know which one is the best and most convinient way of upgrading a database and why?
2. Manual upgrade by catupgrd.sqlThis requires manual running of many scripts, and is prone to human errors
3. Export ImportSee #2 above (there are some advantages to this approach - see doc link below)
4. DB linksPl elaborate on how one can upgrade using database links
If the database is big i would recommend using DBUA, i dont recommend using manual as it can lead to human errors.
If the database is small then go for export/import as you no need to run pre-upgrade, post-upgrade steps...etc. Instead of export/import i would recommend datapump.
See the solution for ORA-19755 during recovery/DB startup
Oracle data pump export/import with examples.
I hope you know each shop has its own measurements. If I give some size based upon my exp, it may not for him.
The user has to make his assessment based upon his downtime/mainteance window.
Hope this helps,
RMAN Debug and Trace
Time for Change: Migrate your Non-RAC Database to RAC