Szkolenia Oracle

Cel szkolenia

This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Learn To:

  • Diagnose and repair data failures with Flashback technology.
  • Manage space to optimize database storage so you can respond to growing space requirements.
  • Monitor and manage major database components, including memory, performance and resources.
  • Secure the availability of your database through appropriate backup and recovery strategies.
  • Automate DBA tasks with the Scheduler.

Plan szkolenia Rozwiń listę

  1. Core Concepts and Tools of the Oracle Database
    • The Oracle Database Architecture: Overview
    • ASM Storage Concepts
    • Connecting to the Database and the ASM Instance
    • DBA Tools Overview
  2. Configuring for Recoverability
    • Purpose of Backup and Recovery (B&R), Typical Tasks and Terminology
    • Using the Recovery Manager (RMAN)
    • Configuring your Database for B&R Operations
    • Configuring Archivelog Mode
    • Configuring Backup Retention
    • Configuring and Using a Flash Recovery Area (FRA)
  3. Using the RMAN Recovery Catalog
    • Tracking and Storing Backup Informatio
    • Setting up a Recovery Catalog
    • Recording Backups
    • Using RMAN Stored Scripts
    • Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop and Virtual Private Catalog)
  4. Configuring Backup Settings
    • Configuring and Managing Persistent Settings for RMAN
    • Configuring Autobackup of Control File
    • Backup optimization
    • Advanced Configuration Settings: Compressing Backups
    • Configuring Backup and Restore for Very Large Files (Multisection)
  5. Creating Backups with RMAN
    • RMAN backup types
    • Creating and Using the following:
      • Backup Sets and Image Copies
      • Whole Database Backup
      • Fast Incremental Backup
      • Configure Backup Destinations
      • Duplexed Backup Sets
      • Archival Backups
  6. Restore and Recovery Task
    • Restoring and Recovering
    • Causes of File Loss
    • Automatic Tempfile Recovery
    • Recovering from the Loss of a Redo Log Group
    • Recovering from a Lost Index Tablespace
    • Re-creating a Password Authentication File
    • Complete and Incomplete Recovery
    • Other Recovery Operations
  7. Using RMAN to Perform Recovery
    • Complete Recovery after Loss of a Critical or Noncritical Data File
    • Recovering Image Copies and Switching Files
    • Restore and Recovery of a Database in NOARCHIVELOG Mode
    • Incomplete Recovery
    • Performing Recovery with a Backup Control File
    • Restoring from Autobackup: Server Parameter File and Control File
    • Restoring and Recovering the Database on a New Host
  8. Monitoring and Tuning RMAN
    • Monitoring RMAN Jobs
    • Balance Between Speed of Backup Versus Speed of Recovery
    • RMAN Multiplexing
    • Synchronous and Asynchronous I/O
  9. Diagnosing the Database
    • Data Recovery Advisor (DRA)
    • Block Corruption
    • Automatic Diagnostic Repository (ADR)
    • Health Monitor
    • The ADR Command-Line Tool, ADRCI
  10. Using Flashback Technology I
    • Flashback Technology: Overview and Setup
    • Using Flashback Technology to Query Data
    • Flashback Table
    • Flashback Transaction Query
    • Performing Flashback Transaction Backout
  11. Using Flashback Technology II
    • Oracel Total Recall
    • Flashback Drop and the Recycle Bin
  12. Performing Flashback Database
    • Configuring Flashback Database
    • Performing Flashback Database Operations
    • Monitoring Flashback Database
  13. Managing Memory
    • Oracle Memory Structures
    • Oracle Database Memory Parameters
    • Using Automatic Memory Management
    • Automatic Shared Memory Management
    • Using Memory Advisors
    • Using Data Dictionary Views
  14. Managing Database Performance
    • Tuning Activities
    • Using Statistic Preferences
    • Optimizer Statistics Collection
    • Monitor the Performance of Sessions and Services
    • Automatic Workload Repository (AWR)
    • Describing the Benefits of Database Replay
  15. Managing Performance by SQL Tuning
    • SQL Tuning and SQL Advisors
    • Using SQL Tuning Advisor
    • SQL Access Advisor
    • SQL Performance Analyzer Overview
  16. Managing Resources
    • Database Resource Manager: Overview and Concepts
    • Accessing and Creating Resource Plans
    • Creating Consumer Group
    • Specifying Resource Plan Directives, including:
      • Limiting CPU Utilization at the Database Level
      • Instance Caging
    • Activating a Resource Plan
    • Monitoring the Resource Manager
  17. Automating Tasks with the Scheduler
    • Simplifying Management Tasks
    • Creating a Job, Program, and Schedule
    • Using Time-Based, Event-Based, and Complex Schedules
    • Describing the Use of Windows, Window Groups, Job Classes, and Consumer Groups
    • Multi-Destination Jobs
  18. Managing Space in Blocks
    • Free Space Management
    • Monitoring Space
    • Compressing Data
  19. Managing Space in Segments
    • Segment Creation on Demand
    • Additional Automatic Space-Saving Functionalit
    • Shrinking Segments
    • Segment Advisor
    • Managing Resumable Space Allocation
  20. Managing Space for the Database
    • Using 4 KB-Sector Disks
    • Transporting Tablespaces
    • Transporting Databases
  21. Duplicating a Database
    • Purpose and Methods of Cloning a Database
    • Using RMAN to Create a Duplicate Database
    • Cloning a Database from a Backup
    • Duplicate a Database Based on a Running Instance
    • Targetless Duplicating a Database
Pobierz konspekt szkolenia w formacie PDF

Dodatkowe informacje


Recommended Related Training Courses:

  • Oracle Database 11g: Security Release 2
  • Oracle Database 11g: Performance Tuning DBA Release 2
  • Oracle Database 11g: Backup and Recovery Workshop
  • Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Release 2
Poziom trudności
Czas trwania 5 dni
Zobacz więcej szkoleń Oracle

Prosimy o wypełnienie poniższego formularza, jeśli chcą Państwo uzyskać więcej informacji o powyższym szkoleniu.

Cena szkolenia

  • Forma szkolenia: stacjonarne


Czytaj więcej o ctab

Czas trwania

5 dni

Dostępne terminy