Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
identify the steps for ensuring an Oracle Database 11g database is available to users when needed, by monitoring its performance, anticipating and avoiding database failure, setting up instance recovery options, and creating backups.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators

Prerequisites
A working knowledge of SQL

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup

  • identify the steps for monitoring and analyzing performance, managing memory, and troubleshooting invalid objects that affect performance.
  • recognize ways to anticipate and avoid various types of failure that can occur in Oracle Database 11g.
  • recognize the process used to configure an Oracle Database 11g database for instance recovery.
  • recognize the features of different backup strategies you can employ in Oracle Database 11g.
  • recognize the steps for using RMAN to configure, schedule, manage, and view backup operations.
  • resolve performance issues, prepare the database for recovery, and perform a database backup in a given scenario.

    • Course Number:
    255845_eng