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. onfiguring 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 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)

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
• ­ Explaining Performance Impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION

9. iagnosing 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

• ­ Oracle 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