دوره Oracle Database 11g Administration Workshop II

سر فصل ها:

Core Concepts and Tools of the Oracle Database

• The Oracle Database Architecture: Overview
• Connecting to the Database and the ASM Instance
• DBA Tools Overview

• ASM Storage Concepts
• Set up initialization parameter files for ASM instance
• Start up and shut down ASM instances
• Administer ASM disk groups

• 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
• Performing Flashback Database
• 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

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