Oracle 11g DBA Fundamentals I (O1110) Training Course

Training Course Objectives

This practical foundation course is an essential toolkit for all Database Administrators covering the practical skills needed by the DBA to perform the Oracle 11g database administration function within their enterprise. The enhancements and changes that have been introduced in Oracle 11g will be discussed during this course.

Who Should Attend

• Analyst/Designers
• Analyst/Programmers
• Technicians

Training Course Prerequisites

• There are no prerequisites.

Training Course Duration

5 Days

Training Course Contents

Managing the Oracle Instance

• Initialization Parameters
• Memory Management
• Automatic Shared Memory Management (ASMM)
• Database Startup and Shutdown
• Viewing the Alert History
• Using Trace Files
• Data Dictionary: Overview

Managing Database Storage

• Managing Tables / Data Storage.
• Setting Storage Parameters
• Managing Tablespaces / Data Files
• Automatic Storage Management (ASM)
• SYSTEM and SYSAUX Tablespaces.
• Creating Additional Tablespaces
• Adding Data Files to a Tablespace
• Tablespace Online / Offline
• Locally Managed Tablespaces
• Multiple Block sizes
• Bigfile Tablespaces
• Temporary Tablespaces
• Database Default Tablespaces
• Renaming Tablespaces
• Renaming and Relocating Data Files
• Dropping Tablespaces and Data Files

Managing Undo Data

• Managing Rollback Segments
• Setting up Automatic Undo Management
• Monitoring Undo Segments
• Undo Tablespace & Sizing
• Undo Advisor

Redo Logs and Control Files

• Managing Redo Logs
• Types of Redo Log
• Archiving Modes
• Log Switches and Checkpoints
• Creating Online Redo Log Groups
• Creating Log Group Members
• Renaming/Relocating Redo Log Members
• Dropping Redo Log Groups / Members
• Archiving Redo Logs
• Specifying Archived Log Destinations
• Manual Archiving of Redo Logs
• Control Files
• Creating/Dropping Control Files

Database Security

• Key Concepts
• Connecting as SYSDBA/SYSOPER
• Password Management
• Schemas and Synonyms
• Dropping Users
• Profile Management
• Creating / Altering/ Dropping Roles
• Enabling and Disabling Roles
• Granting / Revoking System Privileges and Roles.
• Granting / Revoking Object Privileges

EXPORT, IMPORT & DATAPUMP

• Introduction to Utilities
• EXP: Runtime EXPORT Command
• EXP Parameters and Operation Notes
• Restrictions on Export
• IMP: Runtime IMPORT Command
• IMP Parameters & Operation Notes
• Using Data Pump Features
• Transportable Tablespaces

SQL Loader

• Conventional path
• Types of file
• The control file

Backup and Recovery Procedures

• Basic Concepts
• Backup Guidelines
• Performing Full / Partial Back-ups
• Control File Backups in ARCHIVELOG mode
• Online Backup
• Recovery Mechanisms
• Types of failure
• Appropriate Recovery Procedures
• Restoring Damaged Data Files
• Restoring Archived Redo Log Files
• Restoring a Full Backup
• Closed Database Recovery
• Open Database Recovery
• Incomplete Media Recovery

Enterprise Mgr and Maintenance

• Database Control
• Server Generated Alerts
• Reacting to Alerts
• Advisor Central

Optimisation

• Introduction to Database Tuning
• Gathering Tuning Statistics
• Tuning Memory
• Balancing Disk I/O
• Resource Contention
• Automatic Workload Repository (AWR)
• Automatic Database Diagnostic Monitor (ADDM)

Next Available Dates

• 13th Sep 2010  London
• 20th Sep 2010  Edinburgh
• 11th Oct 2010  London
• 11th Oct 2010  Leeds