Oracle Database 11g: Administration Workshop II

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.

Students will learn in this course: back up and recover a database using RMAN and Enterprise Manager, configure Oracle Database 11g 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.

Vorkenntnisse erforderlich

• D49988 Oracle Datenbank 11g: Professioneller Einstieg in Oracle SQL



• D50102 Oracle Database 11g: Administration Workshop I

Kursbeschreibung

Sachgebiete

• 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

Teilnehmerkreis

• Datenbankadministrator
• Support Engineer
• Data Warehouse Administrator
• Technical Consultant

Kategorie

Oracle 11g Datenbank

Sprache Unterlagen

Deutsch