Oracle Database Upgrade Training

Please note, the topics mentioned here are only the major subtopics within the course

• Planning your Oracle Upgrade project
  • Supported upgrade paths to Oracle Database
  • Actions involving weeks and days before Oracle Upgrade
  • Steps to be taken for ‘recoverable’ Backup of Database
• Evaluation/Analysis of Infrastructure and Applications
  • Setting up environment and Storage Requirements
  • Setting OS Patch levels, parameter files before upgrade
  • Securing Access and Control to the Oracle Instance
  • Analysis of Deprecated and De-supported features
• Tasks involving Installation of new versions for Oracle
  • Installing the new version of the Oracle Database
  • Creation of Oracle Instance though Orainst utility
  • Management of Oracle Patches and Interim Patches
• Define Rigid Freeze, Cutover and Regression steps
  • Define and maintain cut-over tasks list
  • Freeze on development and modifications
  • Defining and signing-off clear regression steps
• Oracle Upgrade methodologies & Post-upgrade steps
  • Steps involving Database Upgrade Assistant (DBUA)
  • Actions involving manual Oracle upgrade method
  • Analysis of using Export and Import for Oracle Upgrade
  • Completing all post-upgrade steps in proper sequence
• Undo, Parameter files, and SGA Management
  • Configuring Oracle for Automatic Undo Management
  • AUM monitoring and conversion of manual rollbacks
  • Utilising SPfiles, persistent and dynamic parameters
• Performance Enhancements and Tuning
  • Automatic SGA and PGA Management
  • Analysis of System Statistics and enhancements
  • Auditing Database users and SQL execution traces
• Backup and Restore strategies
  • Re-design of existing Backup and Restore methods
  • Hand-over of complete documentation for the Upgrade

 

ENROL                             Request Info                             IT Courses Page