Oracle Database 11g: Administration Workshop II (D17092GC30)

Overview


  • In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios.
  • Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices.
  • Back up and recover a database using RMAN and Enterprise Manager
  • Configure Oracle Database for optimal recovery for any environment
  • Identify burdensome database sessions and poorly performing SQL
  • Configure the database instance such that resources are allocated among sessions and tasks appropriately Schedule jobs to run inside or outside of the database

Days:

Course Code:

5

O11GAWS2

Pre-Requisites


  • Oracle Database 11g: Administration Workshop I
Content


  • Database Architecture and ASM
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Configuring Backup Specifications
  • Creating Backups
  • Performing User-Managed Backup and Recovery
  • Using RMAN to Perform Recovery
  • Using RMAN to Duplicate a Database
  • Performing Tablespace Point-in-time Recovery
  • Monitoring and Tuning RMAN
  • Using Flashback Technology
  • Using Flashback Database
  • Diagnosing the Database
  • Managing Memory
  • Managing Database Performance
  • Using the Segment Advisor
  • Managing Resources
  • Automating Tasks with the Scheduler
  • Administering the Scheduler
  • Globalization
Objectives


  • Back up and recover a database
  • Configure Oracle Database for optimal recovery
  • Administer ASM disk groups
  • Use an RMAN backup to duplicate a database
  • Automating Tasks with the Scheduler
Target Audience


  • Database Administrators
  • Data Warehouse Administrator
  • Technical Consultant
  • Support Engineer
vendors Course Code Course Title Days Date
Oracle Certifications in UAE
O11GAWS2 Oracle Database 11g: Administration Workshop II (D17092GC30) 5 View All Dates

This public courses are pre-scheduled throughout the year at our premises

Online, live and interactive training accessible from anywhere

We can deliver standard or customised training at any time and location that suits your employees

Guaranteed courses are confirmed to run on the specific dates shown