D50079 Oracle Database 11g/11gR2: 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/11gR2: Professioneller Einstieg in Oracle SQL
• D50102 Oracle Database 11gR2: 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

Sofern vorhanden/möglich Deutsch, anderenfalls Englisch

Kursdauer

5 Tage

Kurspreis

2.950 EUR exkl. Mwst.

Kurstermine

Von	Bis	Ort	Preis (exkl. MwSt.)	Trainer
18.10.2010	22.10.2010	GNC	2.950,00 EUR	nur wenn eingeloggt !	Termin buchen
22.11.2010	26.11.2010	Oracle	2.950,00 EUR	nur wenn eingeloggt !	Termin buchen
13.12.2010	17.12.2010	GNC	2.950,00 EUR	nur wenn eingeloggt !	Termin buchen
24.01.2011	28.01.2011	GNC	2.950,00 EUR	nur wenn eingeloggt !	Termin buchen
21.03.2011	25.03.2011	GNC	2.950,00 EUR	nur wenn eingeloggt !	Termin buchen
09.05.2011	13.05.2011	GNC	2.950,00 EUR	nur wenn eingeloggt !	Termin buchen
27.06.2011	01.07.2011	GNC	2.950,00 EUR	nur wenn eingeloggt !	Termin buchen