Advanced Oracle Database Administration

• Overview of Oracle Database Administration
  • A summary of the Apcom Oracle Database Administration course
• Oracle NET and Oracle Patch Management
  • Use TNS to connect to other Oracle Instances
  • Application of Oracle Database Patches and Interim Patches
• Proactive Maintenance of Oracle Databases
  • Analysis and setting of critical thresholds and error messages
  • Detection and resolution of lock conflicts and deadlocks
  • Management of Automatic Storage and Undo Management
  • About Oracle Control files and consistency of Oracle
• Advanced Backup and Recovery concepts
  • Creation of consistent Oracle Database Backups
  • Concepts about Online and Offline Backups
  • Automated Database Backups and Incremental Backups
  • Recovery from loss of either Redo, Control or Datafiles
• Disaster recovery using a standby Database
  • Configuration/Synchronisation of an Oracle standby Database
  • Maintaining a read-only standby database
  • More about physical and logical standby databases
  • Failover and switching to the standby Database
• Hands-on Backup and Recovery workshops
  • Practical examples will be provided for recovery methodologies
• Performance Tuning of Oracle Databases
  • Tuning the Oracle Memory/buffer areas
  • Optimum performance of queries through tuning SQL
  • Enabling Dynamic Memory Management methods
  • Performance Tuning through management of I/O and Caches
• Introduction to RMAN and Oracle Enterprise Manager
  • RMAN Basic Operations covering Commands and Interfaces
  • Creation and Connection to the RMAN Catalog Database
  • Management of the RMAN Add-on through CUI commands
  • Functionalities of the GUI-based Oracle Enterprise Manager
  • Performing Administrative functions with the OEM

 

ENROL                             Request Info                             IT Courses Page