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 (B&R), Typical Tasks and Terminology

• Using the Recovery Manager (RMAN)

• Configuring your Database for B&R Operations

• Configuring Archive log 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 Auto backup 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 Table space

• 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 Auto backup: 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 Back out

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 Reusable Space Allocation

Managing Space for the Database

• Using 4 KB-Sector Disks

• Transporting Table spaces

• 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

• Target less Duplicating a Database

Course Objective

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