• Oracle 11g Database Backup, Recovery, and Tuning培
  Oracle 11g Database Backup, Recovery, and Tuning培訓
  課程大綱
  1. Backup and Recovery Concepts
  Basics of Database Backup, Restore, and Recovery
  Types of Failure that May Occur in an Oracle Database
  Ways to Tune Instance Recovery
  Importance of Checkpoints, Redo Log Files, and Archived Log File
  Configure ARCHIVELOG Mode
  Flashback Database / Table / Query
  2. Database Backups
  Create Consistent Database Backups
  Create Incremental Backups
  Automate Database Backups
  Monitor the Flash Recovery Area
  Back Up Your Database without Shutting It Down
  3. Database Recovery
  Loss of a Control File
  Loss of a Redo Log File
  Loss of Data Files
  Loss of Temp Files
  Loss of Undo Tablespaces
  4. Recovery Manager Configuration
  Parameters affecting RMAN
  Use of a Flashback Recovery Area
  The CONFIGURE Command
  Persistent Settings
  NOCATALOG / CATALOG Mode
  Channel Allocation
  Controlfile Autobackup
  Retention Policies
  5. Recovery Manager Operations
  Using the BACKUP Command
  Creating Backup Sets / Image Copies
  Parallelization
  Compressed Backups
  Whole Database Copying
  Incremental Backups
  Block Change Tracking
  RMAN Backup Monitoring
  REPORT and LIST commands
  6. Non-Critical Loss Recovery
  Password and Network Files
  Read-Only Tablespaces
  Temporary Tablespaces
  Index Tablespaces
  Redo Log Members / Control Files
  7. Database Recovery
  Recovering the Control File
  Reasons for Incomplete Recovery
  Recovery after RESETLOGS
  Incomplete Recovery using EM
  Incomplete Recovery using RMAN
  Incomplete Recovery using SQL
  8. Flashback Database
  When to Use
  Configuration and Use
  Monitoring Flashback Database
  Using EM for Flashback Database
  Flash Recovery Area Maintenance
  Flash Recovery Area Monitoring
  9. User Error Recovery
  The New Recycle Bin
  Flashback a Dropped Table using EM
  Querying Dropped Tables
  Flashback Versions Query
  Flashback Transaction Query
  10. Block Corruption Management
  DBVERIFY and ANALYZE
  DBMS_REPAIR
  Block Media Recovery
  DBMS_BLOCK_CHECKING Parameter
  Using RMAN for Block Corruption
  11. Tune Database Operations
  SQL Parsing and Execution
  Shared SQL Statements / Bind Variables
  The SQL Area / High Load SQL
  Automatic Segment Space Management
  Statement Transformation
  Using SQL Syntax
  12. Tuning The Logical Structure
  Tablespace Considerations
  Table Considerations
  Free Space Management
  Chaining and Migrated Data
  Choosing the Right Index
  Index Usage Monitoring
  Materialized Views
  13. SQL Tuning Tools
  Execution Plans
  Cost-Based Optimization
  Table Column and Index Statistics
  DBMS_STATS
  Stats Pack
  Execution Plans / EXPLAIN PLAN
  Row Access Methods / Index Types
  Autotrace
  SQL_TRACE and TKPROF
  Using Hints
  Stored Outlines and Plan Stability
  Query Rewrites / Materialized Views
  Initialization Parameters
  14. Application Memory Use
  Memory Tuning Goals
  Tuning the Buffer Cache
  Memory Subcaches
  Partitioned Tables and Indexes
  ?
  ?
• 
  ?
• 
  ?
• 
  ?
  ?
  ?
  ?
• 
  ?
  ?

?
?

?

?

?

?

?
?

?
?

?

?

?

?
???

?

?
?

?

?