Oracle 10g DBA Fundamentals II

Course code: O1020

5 days £1,800.00

This Oracle 10g DBA Part 2 course is designed to give the Oracle 10g database administrator a firm foundation in backup and recovery tasks. The primary goal of the Oracle 10g DBA training course is to give the DBA the skills and knowledge to set-up, maint

Course content >

Who Should Attend?

Oracle DBA

Oracle Technical Consultants

Oracle Support Engineers


Oracle 10g DBA Fundamentals I

Oracle 9i DBA Fundamentals I

Course Reviews

Course Contents

On this Oracle 10g DBA Fundamentals Part 2 course students will learn the enhancements and changes that have been introduced since Oracle 9i enabling students to understand the full capability of the Oracle 10g RDBMS as well as for students who may be migrating plans from previous Oracle RDBMS versions.

Students on this course will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. This includes performance monitoring, database security, user management and backup and recovery techniques.

Training Course Contents

Backup and Recovery Overview

  • Understanding the structures and processes for backup and recovery.
  • Introduce the different methods for backup and recovery
  • Diagnose and troubleshoot database problems.
  • Understand Oracle Recovery Manager

Backup and Recovery

  • Recovery structures and processes
  • Backup and recovery configuration
  • Types of failure and troubleshooting
  • Complete recovery
  • Incomplete media recovery
  • Export and import utilities
  • Test Recovery

Oracle Recovery Manager

  • RMAN command line prompt
  • Recovery Manager architecture
  • Setting up Recovery Manager
  • Database space requirements and privileges
  • Creating and running backup and recovery scripts from RMAN
  • Using LIST and REPORT options from Recovery Manager
  • Crash Recovery workshop,
  • Recovery Manager: Tips and tricks
  • Persistent Parameters
  • Block Level recovery

Enterprise Manager Utilities

  • Catalog Maintenance Using Enterprise Manager
  • Creating an EM Backup Configuration
  • LogMiner
  • Recovery Manager
  • Configurable Parameters

Standby Databases and Guards

  • Data Guard Features
  • Creating the Standby Database
  • Maintaining the Standby Database
  • Altering the Physical Structure
  • Failover without Data Guard
  • Failover Using Data Guard
  • Role Transitions Using Data Guard
  • Data Guard Protection Modes
  • Logical Standby Databases
  • Creating a Logical Standby Database
  • Logical Standby Failover and Switchover
  • Data Guard Manager Line Mode
  • Data Guard Manager Using EM


  • Flashback Features
  • Enabling Flashback
  • Flashback Query
  • Additional Query Functions
  • Flashback Version Query
  • Flashback Transaction Query
  • Flashback Table
  • Flashback Drop (Recycle Bin)
  • Flashback Database

Network Architecture

  • Basic configuration
  • Oracle Net Manager
  • Listener administration
  • Using and configuring Oracle Names
  • Networking Wizard

Oracle Intelligent Agent

  • Installation
  • Configuration
  • Mixed SQL*Net and 9i Networking
  • Troubleshooting

Connection Manager

  • Concentrators
  • Multiplexing
  • Connection pooling

Shared Server

  • Using shared server
  • Configuration
  • Restrictions

Shared Memory Management

  • Manual Memory Allocation
  • Setting up ASMM
  • Non-dynamic SGA Buffers


  • Programs
  • Schedules
  • Jobs
  • Job Classes
  • Windows

Automated Storage Management

  • Features
  • ASM instances and database instances
  • ASM Disk groups
  • ASM Files
Contact us for more information