Oracle Database 11g Administration Workshop II

• Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
• Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
• Use an appropriate and flexible memory configuration for your database
• Identify burdensome database sessions and poorly performing SQL
• Configure the Oracle Database for optimal recovery
• Configure the database instance such that resources are appropriately allocated among sessions and tasks
• Schedule jobs to run inside or outside of the database
• Use compression to optimize database storage and duplicate a data

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

Configuring for Recoverability

• Purpose of Backup and Recovery (BR), Typical Tasks and Terminology
• Using the Recovery Manager (RMAN)
• Configuring your Database for BR Operations
• Configuring Archivelog Mode
• Configuring Backup Retention
• Configuring and Using a Flash Recovery Area (FRA)

Using the RMAN Recovery Catalog

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

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

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

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

Monitoring and Tuning RMAN

• 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

Diagnosing the Database

• Data Recovery Advisor (DRA)
• Block Corruption
• Automatic Diagnostic Repository (ADR)
• Health Monitor
• The ADR Command-Line Tool, ADRCI

Using Flashback Technology I

• Flashback Technology: Overview and Setup
• Using Flashback Technology to Query Data
• Flashback Table
• Flashback Transaction Query
• Performing Flashback Transaction Backout

Using Flashback Technology II

• Oracle Total Recall
• Flashback Drop and the Recycle Bin

Performing Flashback Database

• Configuring Flashback Database
• Performing Flashback Database Operations
• Monitoring Flashback Database

Managing Memory

• Oracle Memory Structures
• Oracle Database Memory Parameters
• Using Automatic Memory Management
• Automatic Shared Memory Management
• Using Memory Advisors
• Using Data Dictionary Views

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

Managing Performance by SQL Tuning

• SQL Tuning and SQL Advisors
• Using SQL Tuning Advisor
• SQL Access Advisor
• SQL Performance Analyzer Overview

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

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

Managing Space in Blocks

• Free Space Management
• Monitoring Space
• Compressing Data

Managing Space in Segments

• Segment Creation on Demand
• Additional Automatic Space-Saving Functionality
• Shrinking Segments
• Segment Advisor
• Managing Resumable Space Allocation

Managing Space for the Database

• Using 4 KB-Sector Disks
• Transporting Tablespaces
• Transporting Databases

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