Course Details
Through hands-on experience in administering an Oracle 11g database, you will learn a wide variety of advanced concepts to let you fully master administration of an Oracle database. This course includes a thorough discussion of new Oracle11g automation features, including Flashback Technologies, Automated Storage Management, Automated Tuning Tools, and Automated Management Tools such as the new Scheduler.
Course Prerequisites
- Knowledge of SQL, the Introduction to Oracle 11g SQL and SQL* Pluscourse, or equivalent experience
- The Introduction to Oracle 11g PL/SQL course or equivalent experience ishighly recommended
Course Agenda
1. Recovery Manager Configuration
- Parameters affecting RMAN
- Use of a Flashback Recovery Area
- The CONFIGURE Command
- Persistent Settings
- NOCATALOG / CATALOG Mode
- Catalog Management/Virtual Catalog
- Channel Allocation
- Controlfile Autobackup
- Retention Policies
2. Recovery Manager Operations
- Using the BACKUP Command
- Creating Backup Sets/Image Copies
- Parallelization
- Compressed Backups
- Whole Database Copying/Cloning
- Incremental Backups
- Block Change Tracking
- RMAN Backup Monitoring
- REPORT and LIST Commands
3. Non-Critical Loss Recovery
- Password and Network Files
- Read-Only Tablespaces
- Temporary Tablespaces
- Index Tablespaces
- Redo Log Members/Control Files
4. 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
5. Flashback Database
- When to Use
- Configuration and Use
- Monitoring Flashback Database
- Using EM for Flashback Database
- Flash Recovery Area Maintenance
- Flash Recovery Area Monitoring
6. User Error Recovery
- The New Recycle Bin
- Flashback a Dropped Table using EM
- Querying Dropped Tables
- Flashback Versions Query
- Flashback Transaction Query
7. Block Corruption Management
- DBVERIFY and ANALYZE
- DBMS_REPAIR
- Block Media Recovery
- DBMS_BLOCK_CHECKING Parameter
- Using RMAN for Block Corruption
8. Automatic Database Management
- Management and Advisory Framework
- Automatic Statistics Collection
- The Automated Workload Repository
- Database Advisors
- SQL Tuning Advisors
- SQL Access Advisors
- Active Session History (ASH)
- Automatic Statistics Collection
- Automatic Undo Retention
- Adjusting Thresholds/Managed Metrics
9. Automatic Storage Management
- ASM Architecture
- ASM Initialization Parameters
- ASM Filenames in SQL commands
- ASM Tablespaces
- Disk Groups/Failure Groups
- ASM Startup/Shutdown/ASMCMD
- ASM Disk Group Administration
10. Globalization Support
- Timezones and Datetimes
- Language Dependent Behavior
- Locales and Variants
- Case and Accent Insensitive Sorts
- Linguistic Sorting
- Querying GS Configuration
11. Resource Management
- Resource Manager Configuration
- Resource Consumer Groups
- Resource Plans and Directives
- Directives for Resource Allocation
- Adaptive Consumer Group Mapping
- Enabling and Switching Plans
12. Scheduler
- Creating Jobs and Job Classes
- Creating Schedules and Windows
- Scheduler Programs
- Prioritizing Jobs
- Scheduler Component Reuse
- Query Scheduler Information
13. Storage Management
- Tuning Archiving
- Redo Log Size Advisor
- Segment Advisor
- Managing Resumable Operations
- Proactive Tablespace Management
- Table/Index Size Estimation
- Optimizing Storage Options
- Online Index Rebuilds
14. Listener Security
- Password Authentication
- Securing EXTPROC
- Controlling Access
15. Diagnostic Sources
- Alert Logs and Trace Files
- Enterprise Manager and Alerts
- Controlling Trace File Size
- Alert Notification
16. Memory Management
- Memory Structures
- Automatic Shared Memory Management
- SGA configuration/SGA_TARGET
- Automatic PGA Memory Management
- The Memory Advisor
17. Performance Tuning
- Application Identification
- Enterprise Manager Tools
- SQL Tuning Advisor
- SQL Access Advisor
- DBMS_SQLTUNE
- DBMS_ADVISIOR
- Quick Tune