Back to Search Results

Training Course Summary:

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.

Pre-Requisites:

There are no prerequisites.

Who Should Attend:

Analyst/Designers
Analyst/Programmers
Technicians

Training Course Overview/Content:

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
back to top
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
back to top
Managing Undo Data
Managing Rollback Segments
Setting up Automatic Undo Management
Monitoring Undo Segments
Undo Tablespace & Sizing
Undo Advisor
back to top
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
back to top
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
back to top
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
back to top
SQL Loader
Conventional path
Types of file
The control file
back to top
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
back to top
Enterprise Mgr and Maintenance
Database Control
Server Generated Alerts
Reacting to Alerts
Advisor Central
back to top
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)