Oracle Database 11g: Administration Workshop II

AS-SYSTEME Unternehmensberatung
In Stuttgart und Frankfurt Am Main

2.950 
zzgl. MwSt.
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
711 9... Mehr ansehen

Wichtige informationen

Tipologie Workshop
Beginn An 2 Standorten
Dauer 5 Tage
Beschreibung

Dieser Kurs vermittelt folgende Kenntnisse und Fähigkeiten: 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. - Back up and recover a database. - Configure Oracle Database for optimal recovery. - Administer ASM disk grou..
Gerichtet an: Datenbankadministratoren. Data Warehouse-Administrator. Technischer Berater.

Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Frankfurt Am Main
Amperestrasse 6, D-63225, Hessen, Deutschland
auf Anfrage
Stuttgart
Wankelstraße 1, D-70563, Baden-Württemberg, Deutschland
Beginn auf Anfrage
Lage
Frankfurt Am Main
Amperestrasse 6, D-63225, Hessen, Deutschland
Beginn auf Anfrage
Lage
Stuttgart
Wankelstraße 1, D-70563, Baden-Württemberg, Deutschland

Häufig gestellte Fragen

· Voraussetzungen

Um diesen Kurs erfolgreich absolvieren zu können, sollten Sie über folgende Vorkenntnisse verfügen: - SQL-Grundkenntnisse

Themenkreis

Trainingsziel

Dieser Kurs vermittelt folgende Kenntnisse und Fähigkeiten:

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.

  • 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


Teilnehmerkreis

Datenbankadministratoren

Data Warehouse-Administrator

Technischer Berater

Voraussetzungen

Um diesen Kurs erfolgreich absolvieren zu können, sollten Sie über folgende Vorkenntnisse verfügen:

  • SQL-Grundkenntnisse


Im Vorfeld

AOR-2201: Oracle Database 11g: Administration Workshop I

Überblick über den Inhalt des Trainings

Database Architecture and ASM

  • Oracle Database Architecture Overview
  • ASM General Architecture
  • Creating an ASM Instance
  • Using Enterprise Manager to Manage ASM Users
  • ASM Storage Concepts
  • The ASMCMD Utility
  • ASM Scalability and Performance


Configuring for Recoverability

  • Purpose of Backup and Recovery Functionality
  • Typical Backup and Recovery Tasks
  • Oracle Backup and Recovery Solutions
  • Using Recovery Manager (RMAN)
  • Using a Flash Recovery Area
  • Flash Recovery Area Space Management


Using the RMAN Recovery Catalog

  • RMAN Repository Data Storage: Comparison of Options
  • Storing Information in the Recovery Catalog
  • Registering a Database in the Recovery Catalog
  • Recovery Catalog Resynchronization: Concepts
  • Using RMAN Stored Scripts
  • Backing Up and Recovering the Recovery Catalog
  • Using a Virtual Private Catalog


Configuring Backup Specifications

  • Using RMAN to Create Backups
  • Configuring Persistent Settings for RMAN
  • Using Enterprise Manager to Configure RMAN Settings
  • Control File Auto-backups
  • Managing Persistent Settings
  • Configuring Devices for Backup
  • Configuring and Allocating Channels for Use in Backups
  • Configuring Backup Optimization


Creating Backups

  • Creating an Oracle-Suggested Backup
  • Creating Backup Sets & Image Copies
  • Creating a Whole Database Backup
  • RMAN Backup Types
  • Monitoring Block Change Tracking
  • Creating Duplex Backup Sets
  • Archival Backups: Concepts
  • Encrypting Backups


Performing User-Managed Backup and Recovery

  • Restoring and Recovering
  • Causes of File Loss
  • Critical Versus Non-critical
  • Recovering from a TEMPFILE Loss
  • Re-creating Indexes
  • Recovering from a Lost Index Tablespace
  • Authentication Methods for Database Administrators
  • Recovering a Read-Only Tablespace


Using RMAN to Perform Recovery

  • Using RMAN RESTORE and RECOVER Commands
  • Performing Recovery Using Enterprise Manager
  • Recovery Using Incrementally Updated Backups
  • Perform a Fast Switch to Image Copies
  • Restoring and Recovering the Database on a New Host
  • Performing Disaster Recovery


Using RMAN to Duplicate a Database

  • Using RMAN to Create a Duplicate Database
  • Creating a Duplicate Database
  • Creating an Initialization Parameter File for the Auxiliary Instance
  • Allocating Auxiliary Channels
  • Understanding the RMAN Duplication Operation
  • Using EM to Clone a Database
  • Cloning a Running Database


Performing Tablespace Point-in-time Recovery

  • Tablespace Point-in-Time Recovery (TSPITR) Concepts
  • Tablespace Point-in-Time Recovery: Architecture
  • Understanding When to Use TSPITR
  • Determining the Tablespaces for the Recovery Set
  • Using Enterprise Manager to Perform TSPITR
  • Understanding TSPITR Processing
  • Troubleshooting RMAN TSPITR


Monitoring and Tuning RMAN

  • Parallelization of Backup Sets
  • Monitoring RMAN Sessions
  • Interpreting RMAN Message Output
  • Using the DEBUG Option
  • Tuning RMAN
  • RMAN Multiplexing
  • Comparing Synchronous and Asynchronous I/O
  • Tape Subsystem Performance Rules


Using Flashback Technology

  • Flashback Technology
  • Transactions and Undo
  • Guaranteeing Undo Retention
  • Preparing Your Database for Flashback
  • Flashback Drop and the Recycle Bin
  • Using Flashback Technology to Query Data
  • Possible Workflow
  • Flashback Transaction Wizard


Using Flashback Database

  • Flashback Table
  • Enabling Row Movement on a Table
  • Enabling Row Movement on a Table
  • Flashback Database Architecture
  • Configuring Flashback Database
  • Performing Flashback Database Using EM
  • Flashback Database Considerations
  • Flashback Data Archive


Diagnosing the Database

  • Automatic Diagnostic Workflow & Repository
  • Location for Diagnostic Traces
  • Viewing the Alert Log Using Enterprise Manager
  • The Support Workbench and Oracle Configuration Manager
  • Create a Service Request
  • Package and upload diagnostic data to Oracle Support
  • Incident Packaging Configuration
  • Health Monitor Overview & Data Recovery Advisor


Managing Memory

  • Oracle Memory Structures
  • Automatic Memory Management Overview
  • Oracle Database Memory Parameters
  • Auto Memory Parameter Dependency
  • Automatic Shared Memory Management: Overview
  • Automatic PGA Memory Management
  • Using the Memory Advisor to Size the SGA
  • Memory Tuning Guidelines for the Library Cache


Managing Database Performance

  • Tuning Activities
  • Performance Planning & Performance Tuning Methodology
  • Instance Tuning
  • Troubleshooting and Tuning Views
  • Automatic Workload Repository
  • SQL Tuning & SQL Advisors
  • Using the SQL Tuning Advisor
  • SQL Access Advisor: Overview


Using the Segment Advisor

  • Space Management: Overview
  • Proactive Tablespace Monitoring
  • Thresholds and Resolving Space Problems
  • Monitoring Tablespace Space Usage
  • Shrinking Segments
  • Space Reclamation with ASSM
  • Automatic Segment Advisor
  • Minimum Compatibility Level


Managing Resources

  • Database Resource Manager: Overview
  • Database Resource Manager Concepts
  • Accessing Resource Plans
  • Default Maintenance Resource Manager Plan
  • Creating Consumer Groups
  • Resource Allocation Methods for Resource Plans
  • Resource Allocation Methods for Resource Plans
  • Monitoring the Resource Manager


Automating Tasks with the Scheduler

  • Simplifying Management Tasks
  • Key Components and Steps
  • Creating an Event-Based Schedule
  • Creating Complex Schedules
  • Creating Job Chains
  • Creating Job Chains


Administering the Scheduler

  • Advanced Scheduler Concepts
  • Job Classes
  • Windows
  • Prioritizing Jobs Within a Window
  • Remote Jobs
  • Installing the Scheduler Agent
  • Dictionary Views Supporting Remote Jobs


Globalization

  • Globalization Support Features
  • What Every DBA Needs to Know
  • Understanding Unicode
  • Database Character Sets and National Character Sets
  • Language- and Territory-Dependent Parameters
  • Linguistic Searching and Sorting
  • Case- and Accent-Insensitive Search and Sort
  • NLS Data Conversion with Oracle Utilities



User, die sich für diesen Kurs interessiert haben, interessierten sich auch für...
Mehr ansehen