• Oracle 11g Troubleshooting and Maintenance for Sup
  Oracle 11g Troubleshooting and Maintenance for Support Administrators (OR224)培訓
  培訓大綱：
  1. Basic Oracle Architecture
  Architecture Overview
  Database Structures
  Process Structures
  Memory Structures: SGA and PGA
  2. Starting and Stopping the Database
  Connecting as a Privileged User
  Password File Authentication
  Starting a Database
  Shutting Down a Database
  Reading the Alert Log / Trace Files
  Quiescing the Database
  SPFILE / Parameter Management
  3. Logical Components
  Basic Definitions
  Blocks / Extents / Segments / Tablespaces
  Fragmentation / Deallocation
  Managing Undo Segments
  Automatic Undo Management
  Managing Sort Activity
  Managing Data Segments
  Managing Index Segments
  Monitoring Database Segments
  Tablespace Overview
  System Tablespace
  Types of Tablespaces
  Creating Additional Tablespaces
  Altering Tablespaces
  4. Oracle Database Files
  Basic Structures of an Oracle RDBMS
  Data Files
  Redo Log Files / Archived Redo Logs
  Control Files
  Oracle-Managed Files (OMF)
  5. Users and Security
  Managing Database Users
  System / Object Privileges
  Managing Roles / Profiles
  Resource and Password Management
  6. Physical NOARCHIVELOG Mode Backups
  Oracle Database Backups
  Automatic Recovery Architecture
  NOARCHIVELOG / ARCHIVELOG Physical Backups
  Closed Backups
  7. Configuring Archivelog Mode
  Physical ARCHIVELOG Mode Backups
  Establishing Multiple Archiving Destinations
  Open Backups in ARCHIVELOG Mode
  Controlfile Backup
  8. Complete Recovery
  Recovery Structures and Processes
  Recovery in NOARCHIVELOG and ARCHIVELOG Mode
  9. Incomplete Recovery
  What Incomplete Recovery Is
  Recovering from Loss of Current Redo Log Files
  10. Recovery Manager Configuration
  Parameters Affecting RMAN
  Use of a Flashback Recovery Area
  CONFIGURE Command
  Persistent Settings
  NOCATALOG / CATALOG Mode
  Channel Allocation
  Controlfile Autobackup
  Retention Policies
  11. Recovery Manager Operations
  Using the BACKUP command
  Compressed Backups
  Whole Database Copying
  Incremental Backups
  Block Change Tracking
  RMAN Backup Monitoring
  REPORT and LIST commands
  12. Non-Critical Loss Recovery
  Password and Network Files
  Read-Only Tablespaces
  Temporary Tablespaces
  Index Tablespaces
  Redo Log Members / Control Files
  13. 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
  14. Flashback Database
  When to Use
  Configuration and Use
  Monitoring Flashback Database
  Using EM for Flashback Database
  Flash Recovery Area Maintenance
  Flash Recovery Area Monitoring
  15. User Error Recovery
  The New Recycle Bin
  Flashback a Dropped Table
  Querying Dropped Tables
  Flashback Versions Query
  Flashback Transaction Query
  16. Block Corruption Management
  DBVERIFY and ANALYZE
  DBMS_REPAIR
  Block Media Recovery
  DBMS_BLOCK_CHECKING
  Using RMAN for Block Corruption
  17. Diagnostic Sources
  Alert Logs and Trace Files
  Enterprise Manager and Alerts
  Controlling Trace File Size
  Alert Notification
  18. Performance Tuning
  Application Identification
  Enterprise Manager Tools
  SQL Tuning Advisor
  SQL Access Advisor
  DBMS_SQLTUNE
  DBMS_ADVISIOR
  Quick Tune
  ?
  ?
  ?
• 
  ?
• 
  ?
• 
  ?
  ?
  ?
  ?
• 
  ?
  ?

?
?

?

?

?

?

?
?

?
?

?

?

?

?
???

?

?
?

?

?