• Oracle Database 11g: Administration Workshop I DBA
  Oracle Database 11g: Administration Workshop I DBA Release 2 (11gR2-DBA1)培訓
  培訓大綱：
  1. Exploring the Oracle Database Architecture
  Oracle Database Architecture Overview
  Oracle ASM Architecture Overview
  Process Architecture
  Memory Structures
  Logical and Physical Storage Structures
  ASM Storage Components
  2. Installing your Oracle Software
  Tasks of an Oracle Database Administrator
  Tools Used to Administer an Oracle Database
  Installation: System Requirements
  Oracle Universal Installer (OUI)
  Installing Oracle Grid Infrastructure
  Installing Oracle Database Software
  Silent Install
  3. Creating an Oracle Database
  Planning the Database
  Using the DBCA to Create a Database
  Password Management
  Creating a Database Design Template
  Using the DBCA to Delete a Database
  4. Managing the Oracle Database Instance
  Start and Stop the Oracle Database and Components
  Use Oracle Enterprise Manager
  Access a Database with SQLPlus
  Modify Database Installation Parameters
  Stages of Database Startup
  Database Shutdown Options
  View the Alert Log
  Access Dynamic Performance Views
  5. Managing the ASM Instance
  Set Up Initialization Parameter Files for ASM Instance
  Start Up and Shut Down ASM Instances
  Administer ASM Disk Groups
  6. Configuring the Oracle Network Environment
  Use Enterprise Manager to Create and Configure the Listener
  Enable Oracle Restart to Monitor the Listener
  Use TNSPING to Test Oracle Net Connectivity
  When to Use Shared Servers and When to Use Dedicated Servers
  7. Managing Database Storage Structures
  Storage Structures
  How Table Data is Stored
  Anatomy of a Database Block
  Space Management in Tablespaces
  Tablespaces in the Preconfigured Database
  Actions with Tablespaces
  Oracle Managed Files (OMF)
  8. Administering User Security
  Database User Accounts
  Predefined Administrative Accounts
  Benefits of Roles
  Predefined Roles
  Implementing Profiles
  9. Managing Data Concurrency
  Data Concurrency
  Enqueue Mechanism
  Resolving Lock Conflicts
  Deadlocks
  10. Managing Undo Data
  Data Manipulation
  Transactions and Undo Data
  Undo Data Versus Redo Data
  Configuring Undo Retention
  11. Implementing Oracle Database Auditing
  DBA Responsibilities for Security
  Enable Standard Database Auditing
  Specify Audit Options
  Review Audit Information
  Maintain the Audit Trail
  12. Database Maintenance
  Manage optimizer statistics
  Manage the Automatic Workload Repository (AWR)
  Use the Automatic Database Diagnostic Monitor (ADDM)
  Use the Advisory Framework
  Set Alert Thresholds
  Use Server-Generated Alerts
  Use Automated Tasks
  13. Performance Management
  Performance Monitoring
  Managing Memory Components
  Enabling Automatic Memory Management (AMM)
  Automatic Shared Memory Advisor
  Using Memory Advisors
  Dynamic Performance Statistics
  Troubleshooting and Tuning Views
  Invalid and Unusable Objects
  14. Backup and Recovery Concepts
  Part of Your Job
  Statement Failure
  User Error
  Understanding Instance Recovery
  Phases of Instance Recovery
  Using the MTTR Advisor
  Media Failure
  Archive Log Files
  15. Performing Database Backups
  Backup Solutions
  Oracle Secure Backup
  User-Managed Backup
  Terminology
  Recovery Manager (RMAN)
  Configuring Backup Settings
  Backing Up the Control File to a Trace File
  Monitoring the Flash Recovery Area
  16. Performing Database Recovery
  Opening a Database
  Data Recovery Advisor
  Loss of a Control File
  Loss of a Redo Log File
  Data Recovery Advisor
  Data Failures
  Listing Data Failures
  Data Recovery Advisor Views
  17. Moving Data
  Ways to Move Data
  Create and Use Directory Objects
  Use SQL*Loader to Move Data
  Use External Tables to Move Data
  General Architecture of Oracle Data Pump
  Use Data Pump Export and Import to Move Data
  18. Working with Support
  Use the Enterprise Manager Support Workbench
  Work with Oracle Support
  Log Service Requests (SR)
  Manage Patches
  ?
  ?
  ?
• 
  ?
• 
  ?
• 
  ?
  ?
  ?
  ?
• 
  ?
  ?

?
?

?

?

?

?

?
?

?
?

?

?

?

?
???

?

?
?

?

?