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.

What You’ll Learn

  • Configure for globalization support
  • Secure the Oracle listener
  • Configure and use Recovery Manager
  • Identify and use diagnostic information
  • Recover your database
  • How and why to flashback a database
  • Use the new Automation Tools
  • Use the new Performance Tuning Tools
  • Manage database storage
  • Manage memory
  • Manage other database resources
  • Use Scheduler to automate tasks
  • Configure and use Automated Storage Management

Who Needs to Attend

Data analysts, database administrators, systems administrators, network managers, and technical support personnel

Prerequisites

  • Knowledge of SQL, the Introduction to Oracle 11g SQL and SQL* Plus course, or equivalent experience
  • The Introduction to Oracle 11g PL/SQL course or equivalent experience is highly recommended
  • Oracle 11g Foundations: SQL & SQL Plus (OR103)
  • Oracle 11g Introduction to PL/SQL (OR120)

Follow-On Courses

There are no follow-ons for this course.

Course Outline

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

18. The Virtual Private Database

Labs

Lab 1: Recovery Manager Configuration

Lab 2. Recovery Manager Backups

Lab 3: Database Recovery using RMAN

Lab 4: Flashback Database

Lab 5: Flashback for User Errors

Lab 6. Dealing with Block Corruption

Lab 7: Automated Management Tools

Lab 8: Using the Scheduler

Lab 9: Managing Storage

Lab 10: Scheduler

Lab 11: Listener Security

Lab 12: Diagnostic Sources

Lab 13: Oracle Auditing

Lab 14: Performance Tuning