D50079 www.globalknowledge.de info@globalknowledge.de 0800 / 295 26 33

Oracle Database 11g: Administration Workshop II

Dauer: 5 Tage Kurscode: D50079

Kursbeschreibung:

Dieser Kurs folgt auf den Administration Workshop I. Teilnehmer erhalten einen tieferen Einblick in die Funktionen wie Backup, Recovering,Tuning, Jobs triggern sowie Kontrolle und Managen von Ressourcen.

Zielgruppe:

Technischer Berater, Datenbankadministratoren, Data Warehouse-Administrator

Kursziele:

Sichern und Wiederherstellen einer Datenbank (und Teile davon) Konfigurieren der Oracle-Datenbank für optimale Leistungmit RMAN (Kommandozeilen-und Enterprise Manager)

Konfigurieren Sie die Datenbank-Instanz, so dass RessourcenVerwenden "Flash"-Technologie, um auf Vergangenheits-Stati angemessen zu Sitzungen und Aufgaben zugewiesen werdenvon Daten undObjekten oder die gesamte Datenbankzurückzugreifen Programmieren Sie zeitabhängige Jobs,innerhalb oder außerhalb

der DatenbankVerwenden Sie eine geeignete und flexible Speicherkonfigurationfür Ihre Datenbank Verwenden der Komprimierung, umdie Speicherung von

Datenbanken zuoptimieren und Duplikat einer Datenbank zuFinden Sie augelasteteDatenbank-Sessions und erstellenleistungsschwache SQL Programmierungen

Voraussetzungen:

Erforderliche Vorkenntnisse:

Oracle Database 11g Database AdministrationOracle Database 11g: Administration Workshop I

Empfohlene Vorkenntnisse:

Working knowledge of SQL and how to use PL/SQL packages

D50079 www.globalknowledge.de info@globalknowledge.de 0800 / 295 26 33

Schulungsinhalt:

Core Concepts and Tools of the Oracle Monitoring and Tuning RMAN Managing Performance by SQL TuningDatabase line lineline Monitoring RMAN Jobs SQL Tuning and SQL Advisors

The Oracle Database Architecture: Overview Balance Between Speed of Backup Using SQL Tuning AdvisorASM Storage Concepts Versus Speed of Recovery SQL Access AdvisorConnecting to the Database and the ASM RMAN Multiplexing SQL Performance Analyzer Overview Instance Synchronous and Asynchronous I/ODBA Tools Overview Explaining Performance Impact of Managing Resources

MAXPIECESIZE, FILESPERSET, line

Configuring for Recoverability MAXOPENFILES and BACKUP Database Resource Manager: Overviewline DURATION and Concepts

Purpose of Backup and Recovery (B;R), Accessing and Creating Resource PlansTypical Tasks and Terminology Diagnosing the Database Creating Consumer GroupUsing the Recovery Manager (RMAN) line Specifying Resource Plan Directives,Configuring your Database for B;R Data Recovery Advisor (DRA) including:Operations Block Corruption - Limiting CPU Utilization at the DatabaseConfiguring Archivelog Mode Automatic Diagnostic Repository (ADR) LevelConfiguring Backup Retention Health Monitor - Instance CagingConfiguring and Using a Flash Recovery The ADR Command-Line Tool, ADRCI Activating a Resource PlanArea (FRA) Monitoring the Resource Manager

Using Flashback Technology IUsing the RMAN Recovery Catalog line Automating Tasks with the Schedulerline Flashback Technology: Overview and line

Tracking and Storing Backup Information Setup Simplifying Management TasksSetting up a Recovery Catalog Using Flashback Technology to Query Creating a Job, Program, and ScheduleRecording Backups Data Using Time-Based, Event-Based, andUsing RMAN Stored Scripts Flashback Table Complex SchedulesManaging the Recovery Catalog (Backup, Flashback Transaction Query Describing the Use of Windows, WindowExport, Import, Upgrade, Drop and Virtual Performing Flashback Transaction Groups, Job Classes, and ConsumerPrivate Catalog) Backout Groups

Multi-Destination Jobs Configuring Backup Settings Using Flashback Technology IIline line Managing Space in Blocks

Configuring and Managing Persistent Oracle Total Recall lineSettings for RMAN Flashback Drop and the Recycle Bin Free Space ManagementConfiguring Autobackup of Control File Monitoring SpaceBackup optimization Performing Flashback Database Compressing DataAdvanced Configuration Settings: lineCompressing Backups Configuring Flashback Database Managing Space in SegmentsConfiguring Backup and Restore for Very Performing Flashback Database lineLarge Files (Multisection) Operations Segment Creation on Demand

Monitoring Flashback Database Additional Automatic Space-SavingCreating Backups with RMAN Functionalitline Managing Memory Shrinking Segments

RMAN backup types line Segment AdvisorCreating and Using the following: Oracle Memory Structures Managing Resumable Space Allocation - Backup Sets and Image Copies Oracle Database Memory Parameters- Whole Database Backup Using Automatic Memory Management Managing Space for the Database- Fast Incremental Backup Automatic Shared Memory Management line- Configure Backup Destinations Using Memory Advisors Using 4 KB-Sector Disks- Duplexed Backup Sets Using Data Dictionary Views Transporting Tablespaces- Archival Backups Transporting Databases

Managing Database PerformanceRestore and Recovery Task line Duplicating a Databaseline Tuning Activities line

Restoring and Recovering Using Statistic Preferences Purpose and Methods of Cloning aCauses of File Loss Optimizer Statistics Collection DatabaseAutomatic Tempfile Recovery Monitor the Performance of Sessions and Using RMAN to Create a DuplicateRecovering from the Loss of a Redo Log Services DatabaseGroup Automatic Workload Repository (AWR) Cloning a Database from a BackupRecovering from a Lost Index Tablespace Describing the Benefits of Database Duplicate a Database Based on a RunningRe-creating a Password Authentication File Replay InstanceComplete and Incomplete Recovery Targetless Duplicating a DatabaseOther Recovery Operations

D50079 www.globalknowledge.de info@globalknowledge.de 0800 / 295 26 33

Using RMAN to Perform Recoveryline

Complete Recovery after Loss of a Criticalor Noncritical Data FileRecovering Image Copies and SwitchingFilesRestore and Recovery of a Database inNOARCHIVELOG ModeIncomplete RecoveryPerforming Recovery with a Backup ControlFileRestoring from Autobackup: ServerParameter File and Control FileRestoring and Recovering the Database ona New Host

Weitere Informationen:

Für weitere Informationen oder Buchung kontaktieren Sie uns bitte unter 0800 / 295 26 33

info@globalknowledge.de

www.globalknowledge.de

Global Knowledge Germany Training GmbH, Friedensallee 271, 22763 Hamburg