1. Oracle 10g Troubleshooting and Maintenance for Sup
   Oracle 10g Troubleshooting and Maintenance for Support Administrators培訓
   培訓大綱：
   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
2. 
   ?
   ?
3. 
   ?
   ?
4. 
   ?
   ?
5. 
   ?
6. 
   ?
7. 
   ?
8. 
   ?
9. 
   ?
   ?
10. 
    ?
    ?
    ?
    ?
11. 
    ?
12. 
    ?
13. 
    ?
    ?
    ?
    ?
14. 
    ?
    ?
    ?
    ?
15. 
    ? ?
16. 
    
17. 
    ?
18. 
    ?
    ?
19. 
    ?
    ?
20. 
    
    

"