Oracle Database 11g Administration Workshop II DBA Release 2

Document Sample
Oracle Database 11g Administration Workshop II DBA Release 2 Powered By Docstoc
					Oracle Database 11g: Administration Workshop II DBA Release 2

What you will learn:

This course takes the database administrator beyond the basic tasks covered in the first workshop. The student
begins by gaining a much deeper understanding of possibly the most important job of a DBA – backup and
recovery. The concepts and architecture that support backup and recovery, along with the steps of how to carry
it out in various ways and situations, are covered in detail. This includes how to define and test your own backup
and recovery scenarios. Also, the DBA learns how to manage memory effectively and how to perform some
performance evaluation and tuning tasks, including using some of the advisors. All types of flashback
technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are
also covered
This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator
Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification
Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on

Learn To:

      Automate DBA tasks with the Scheduler
      Diagnose and repair data failures with Flashback technology
      Manage space to optimize database storage and to be able to respond to growing space requirements
      Monitor and manage major database components, including as memory, performance, and resources
      Secure the availability of your database by appropriate backup and recovery strategies
                                                      Using the RMAN Recovery Catalog
                                                      Tracking and Storing Backup Information
 Database Administrators
                                                      Setting up a Recovery Catalog
 Support Engineer
                                                      Recording Backups
 Technical Administrator
                                                      Using RMAN Stored Scripts
 Technical Consultant
                                                      Managing the Recovery Catalog (Backup, Export,
                                                      Import, Upgrade, Drop and Virtual Private Catalog)
Required Prerequisites                                Configuring Backup Settings
 Oracle Database 11g Database Administration          Configuring and Managing Persistent Settings for
 Working knowledge of SQL and how to use
 PL/SQL packages                                      Configuring Autobackup of Control File
                                                      Backup optimization
                                                      Advanced Configuration Settings: Compressing
Suggested Prerequisites                               Backups
 Oracle Database 11g: Administration Workshop I       Configuring Backup and Restore for Very Large
 DBA Release 2                                        Files (Multisection)

Course Objectives                                     Creating Backups with RMAN
 Back and recover a database (and its parts) with     RMAN backup types
 RMAN (command-line and Enterprise Manager)           Creating and Using the following:
 Use flashback technology to view past states of      - Backup Sets and Image Copies
 data and to revert either objects or the entire      - Whole Database Backup
 database back to a past state                        - Fast Incremental Backup
 Use an appropriate and flexible memory               - Configure Backup Destinations
 configuration for your database                      - Duplexed Backup Sets
 Identify burdensome database sessions and poorly     - Archival Backups
 performing SQL
 Configure the Oracle Database for optimal recovery   Restore and Recovery Task
 Configure the database instance such that            Restoring and Recovering
 resources are appropriately allocated among          Causes of File Loss
 sessions and tasks                                   Automatic Tempfile Recovery
 Schedule jobs to run inside or outside of the        Recovering from the Loss of a Redo Log Group
 database                                             Recovering from a Lost Index Tablespace
 Use compression to optimize database storage and     Re-creating a Password Authentication File
 duplicate a database                                 Complete and Incomplete Recovery
                                                      Other Recovery Operations
Course Topics
Core Concepts and Tools of the Oracle Database        Using RMAN to Perform Recovery
 The Oracle Database Architecture: Overview           Complete Recovery after Loss of a Critical or
 ASM Storage Concepts                                 Noncritical Data File
 Connecting to the Database and the ASM Instance      Recovering Image Copies and Switching Files
 DBA Tools Overview                                   Restore and Recovery of a Database in
Configuring for Recoverability                        NOARCHIVELOG Mode
 Purpose of Backup and Recovery (B&R), Typical        Incomplete Recovery
 Tasks and Terminology                                Performing Recovery with a Backup Control File
 Using the Recovery Manager (RMAN)                    Restoring from Autobackup: Server Parameter File
 Configuring your Database for B&R Operations         and Control File
 Configuring Archivelog Mode                          Restoring and Recovering the Database on a New
 Configuring Backup Retention                         Host
 Configuring and Using a Flash Recovery Area
Monitoring and Tuning RMAN                          Managing Performance by SQL Tuning
 Monitoring RMAN Jobs                                SQL Tuning and SQL Advisors
 Balance Between Speed of Backup Versus Speed        Using SQL Tuning Advisor
 of Recovery                                         SQL Access Advisor
 RMAN Multiplexing                                   SQL Performance Analyzer Overview
 Synchronous and Asynchronous I/O
 Explaining Performance Impact of                   Managing Resources
 MAXPIECESIZE, FILESPERSET,                          Database Resource Manager: Overview and
 MAXOPENFILES and BACKUP DURATION                    Concepts
                                                     Accessing and Creating Resource Plans
Diagnosing the Database                              Creating Consumer Group
 Data Recovery Advisor (DRA)                         Specifying Resource Plan Directives, including:
 Block Corruption                                    - Limiting CPU Utilization at the Database Level
 Automatic Diagnostic Repository (ADR)               - Instance Caging
 Health Monitor                                      Activating a Resource Plan
 The ADR Command-Line Tool, ADRCI                    Monitoring the Resource Manager
Using Flashback Technology I                        Automating Tasks with the Scheduler
 Flashback Technology: Overview and Setup            Simplifying Management Tasks
 Using Flashback Technology to Query Data            Creating a Job, Program, and Schedule
 Flashback Table                                     Using Time-Based, Event-Based, and Complex
 Flashback Transaction Query                         Schedules
 Performing Flashback Transaction Backout            Describing the Use of Windows, Window Groups,
                                                     Job Classes, and Consumer Groups
Using Flashback Technology II                        Multi-Destination Jobs
 Oracle Total Recall
 Flashback Drop and the Recycle Bin                 Managing Space in Blocks
                                                     Free Space Management
Performing Flashback Database                        Monitoring Space
 Configuring Flashback Database                      Compressing Data
 Performing Flashback Database Operations
 Monitoring Flashback Database                      Managing Space in Segments
                                                     Segment Creation on Demand
Managing Memory                                      Additional Automatic Space-Saving Functionalit
 Oracle Memory Structures                            Shrinking Segments
 Oracle Database Memory Parameters                   Segment Advisor
 Using Automatic Memory Management                   Managing Resumable Space Allocation
 Automatic Shared Memory Management
 Using Memory Advisors                              Managing Space for the Database
 Using Data Dictionary Views                         Using 4 KB-Sector Disks
                                                     Transporting Tablespaces
Managing Database Performance                        Transporting Databases
 Tuning Activities
 Using Statistic Preferences                        Duplicating a Database
 Optimizer Statistics Collection                     Purpose and Methods of Cloning a Database
 Monitor the Performance of Sessions and Services    Using RMAN to Create a Duplicate Database
 Automatic Workload Repository (AWR)                 Cloning a Database from a Backup
 Describing the Benefits of Database Replay          Duplicate a Database Based on a Running Instance
                                                     Targetless Duplicating a Database