Course Overview

This course aims to introduce the skills required to become an Oracle Database Administrator. The course will provide an insight into role of an Oracle Database Administrator and provide practical experience of the tasks and activities required.

efst á síðu

Pre-Requisite Skills

Oracle 10g Database Administration Part 1 or practical DBA experience . Do not hesitate to contact us with any questions about pre-requisite skills.

efst á síðu

Course Content

Introduction to RMAN

What is RMAN?, Why use RMAN,, Basics of RMAN, Using RMAN command line and through Enterprise Manager

efst á síðu

RMAN Configuration

Configuring the Recovery Catalog Database, Creating the Recovery Catalog Owner, Creating the Recovery Catalog, Registering a Database in the Recovery Catalog, Cataloging Additional Backup Files, Manually Resynchronizing the Recovery Catalog, Configuring RMAN Persistent Settings Configuring Backup Optimization

efst á síðu

Working with RMAN

Creating and Executing Stored Scripts, Using RMAN to Create a Duplicate Database, Performing a backup using RMAN command line and Enterprise Manager, Performing Full and Incremental backups using RMAN, Creating an Oracle suggested backup, Automatic Control file backups, Managing Backups

efst á síðu

RMAN Database Recovery

Using RMAN to perform a full recovery, Recovering using incremental backups, Restoring SPFILES and control files, Performing Tablespace Point in Time recovery

efst á síðu

Performing Non Critical Recovery

Recovering temporary tablespaces, index tablespaces, recovering individual members of a log file group, recovering read only tablespace, recreating a password file

efst á síðu

Flashback Technology in 10g

Flashback Table, Flashback Versions Query, Flashback Transaction Query, Configuring Flashback Database, Performing, Flashback Database, Managing the Recyclebin

efst á síðu

Database Corruption

Understanding why block corruption can occur, Detecting Corruption using DBVERIFY, ANALYZE, DBMS_REPAIR package and Alert log, Preventing Corruption using DB_BLOCK_CHECKING and DB_BLOCK_CHECKSUM

efst á síðu

Automatic Management of the Database

Introducing the Automatic Workload Repository (AWR), Using the Database advisors: ADDM (Auto Database Diagnostic Monitor), Segment advisor, Undo Management Advisor, Memory Advisor, SQL Tuning and Access advisors, Mean time to Recovery Manager (MTTR) advisor.

efst á síðu

Diagnostic Information

Using and managing the Alert log and trace files, Using Enterprise Manager to work with the Alert log, Building policies in Oracle Enterprise Manager, securing the listener

efst á síðu

Monitoring and Tuning the Memory

Memory management option in 10g, Using manual and automatic shared memory management, (ASMM), Configuring ASMM, Memory advisors, working the PGA in 10g

efst á síðu

Monitoring and Managing Storage

Tablespace monitoring in 10g, resumable operations using DBMS_RESUMABLE, table management, estimating storage requirement for tables, space usuage trend analysis, working with the DBMS_SPACE package.

efst á síðu

Resource Management

Introduction to resource management in Oracle, features of Oracle Resource Manager, Configuring resource manager, creating resource plans and associating users to resource groups, creating directives.

efst á síðu

Working Scheduler

Introduction to DBMS_SCHEDULE, the scheduler architecture, Creating jobs, programs, windows, schedules with DBMS_SCHEDULER

efst á síðu