Curso Oracle Database 11 g: Administration Workshop II Release 2

Módulo I: Diagnostico y reparación de fallas con tecnología Flashback

Módulo II: Administración de espacios y componentes para memoria, rendimiento y recursos

Módulo III: Backups y recuperación de base de datos

Módulo IV: Automatización de tareas del DBA con el Programador.

· The Oracle Database Architecture: Overview

· ASM Storage Concepts

· Connecting to the Database and the ASM Instance

· DBA Tools Overview

· 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)

· Tracking and Storing Backup Information

· Setting up a Recovery Catalog

· Recording Backups

· Using RMAN Stored Scripts

· Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop and Virtual Private Catalog)

· 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)

· 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

· 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

· 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

· Monitoring RMAN Jobs

· Balance Between Speed of Backup Versus Speed of Recovery

· RMAN Multiplexing

· Synchronous and Asynchronous I/O

· Explaining Performance Impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION

· Data Recovery Advisor (DRA)

· Block Corruption

· Automatic Diagnostic Repository (ADR)

· Health Monitor

· The ADR Command-Line Tool, ADRCI

· Flashback Technology: Overview and Setup

· Using Flashback Technology to Query Data

· Flashback Table

· Flashback Transaction Query

· Performing Flashback Transaction Backout

· Oracle Total Recall

· Flashback Drop and the Recycle Bin

· Configuring Flashback Database

· Performing Flashback Database Operations

· Monitoring Flashback Database

· Oracle Memory Structures

· Oracle Database Memory Parameters

· Using Automatic Memory Management

· Automatic Shared Memory Management

· Using Memory Advisors

· Using Data Dictionary Views

· 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

· SQL Tuning and SQL Advisors

· Using SQL Tuning Advisor

· SQL Access Advisor

· SQL Performance Analyzer Overview

· 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

· 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

· Free Space Management

· Monitoring Space

· Compressing Data

· Segment Creation on Demand

· Additional Automatic Space-Saving Functionalit

· Shrinking Segments

· Segment Advisor

· Managing Resumable Space Allocation

· Using 4 KB-Sector Disks

· Transporting Tablespaces

· Transporting Databases

· 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