• Oracle Database 11g: Administration Workshop II DB
  Oracle Database 11g: Administration Workshop II DBA Release 2 (11gR2-DBA2)培訓
  培訓大綱
  1. Core Concepts and Tools of the Oracle Database
  The Oracle Database Architecture
  ASM Storage Concepts
  Connecting to the Database and the ASM Instance
  DBA Tools Overview
  2. 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)
  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:
  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. Diagnosing 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
  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)
  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 Concepts
  Accessing and Creating Resource Plans
  Creating Consumer Group
  Specifying Resource Plan Directives
  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
  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 Functionality
  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
  ?
  ?
  ?
• 
  ?
• 
  ?
• 
  ?
  ?
  ?
  ?
• 
  ?
  ?

?
?

?

?

?

?

?
?

?
?

?

?

?

?
???

?

?
?

?

?