Course Overview

This Oracle Database 11g Release 2 DBA – Part II course introduces the delegate to advanced administration tasks. Participants will learn how to plan and implement a backup and recovery strategy using Recovery Manager. They will also learn how to control database resources using the Resource Manager; how to automate administration tasks with the Scheduler and how to carry out performance monitoring and tuning.

This Oracle Database 11g Release 2 DBA – Part II course is suitable for both users of Release 1 and Release 2.

Course Objectives

The Oracle Database 11g Release 2 DBA – Part II course introduces delegates to the main concepts of Oracle backup and recovery. They will learn how to plan and implement a backup and recovery strategy using RMAN. Delegates will also learn to manage memory effectively, carry out some evaluation and tuning exercises, control database resources using Resource Manager and automate tasks with the Scheduler.

The delegate will practise:

Planning a backup strategy and a disaster recovery strategy

Altering a database to archivelog and noarchivelog modes

Managing memory

Using Recovery Manager to perform backups and restorations

Using Flashback technology to diagnose and repair a database

Reviewing database logs for diagnostic purposes

Using Database advisors and views to monitor and improve database performance

Controlling database resources using Resource Manager

Automating management tasks with the Scheduler

Target Audience

This Oracle Database 11g Release 2 DBA – Part II course is designed for database administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle Database 11g Release 1 or Release 2 databases. Administrators will also learn about the tools available to monitor database performance and the steps that can be taken to improve database performance.

Examinations

The course covers the major topics required for the Oracle examination 1Z0-053 Oracle Database 11g: Administration II.

Exams are not included as part of the course.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Pre-Requisites

Delegates who wish to attend this Oracle Database 11g Release 2 DBA – Part II course should have a working knowledge of Oracle SQL and Oracle Database Administration, good operating system knowledge is also essential. This can be obtained by attendance on the Oracle SQL and Oracle Database 11g DBA – Part I courses. Knowledge of PL/SQL would be beneficial.

 Delegates should have attended the following courses or equivalent

-Oracle SQL

-Oracle Database 11g Release 2 DBA – Part I

This Oracle Database 11g Release 2 DBA – Part II course introduces the delegate to advanced administration tasks. Participants will learn how to plan and implement a backup and recovery strategy using Recovery Manager. They will also learn how to control database resources using the Resource Manager; how to automate administration tasks with the Scheduler and how to carry out performance monitoring and tuning.

This Oracle Database 11g Release 2 DBA – Part II course is suitable for both users of Release 1 and Release 2.

Course Contents – DAY 1

Course Introduction

Administration and Course Materials

Course Structure and Agenda

Delegate and Trainer Introductions

Session 1: BACKUP AND RECOVERY CONSIDERATIONS

Oracle Suggested Backup Strategy

Plan and Implement a Backup and Recovery Strategy

Define a Backup Strategy

Define a Disaster Recovery Plan

The Advantages and Disadvantages of Different Backup Methods

Test a Backup and Recovery Plan

Backup Strategy

Recovery Strategy

Validate the Recovery Strategy

Session 2: ORACLE RECOVERY STRUCTURES AND PROCESSES

Architectural Components of Backup and Restore

Redo Logs, Checkpoints and Archives

Multiplexing Control Files and Redo Logs

Types of Database Failure

Session 3: MEMORY MANAGEMENT

Automatic Shared Memory Management

PGA Memory Management

Automatic Memory Management

The Memory Advisor

Memory Allocation Advisors

Memory Management Data Dictionary Views

Session 4: USING ARCHIVELOG AND NOARCHIVELOG MODES

The Archive Modes of a Database

Altering the Archive Mode of a Database

Configuring Multiple Archival Destinations

Configuring Multiple ARCH Processes

Data Dictionary Tables for Archiving

Session 5: TROUBLESHOOTING UTILITIES

Database Synchronization

Automatic Block Corruption reporting

Automatic Quarantine of Corrupt Redo Segments

Protection from Data Corruptions

Analyze Validate Structure

Automatic Diagnostic Repository (ADR)

The ADR Command Line Tool (ADRCI)

Proactive Monitoring with the Health Monitor

Course Contents – DAY 2

Session 6: RECOVERY MANAGER OVERVIEW

Overview of Recovery Manager

RMAN Features and Components

Connect to RMAN

Start Up and Shut Down a Target Database Using RMAN

Session 7: CREATE A RECOVERY CATALOG

Recovery Catalog Overview

Create a Recovery Catalog

Use a Flashback Recovery Area

Register and Unregister a Database

Control File Information

RESYNC CATALOG command

Virtual Private Catalogs

Merge Catalogs

Backup a Recovery Catalog

Session 8: BACKING UP WITH RMAN

Channel Allocation

The Configure Channel Command

Types of RMAN Backup

Recovery Manager Commands

Performing Backups with RMAN

The Backup Command

The Copy Command

Backup File Image Copies

Perform Full, Incremental and Cumulative Backups

Use Data Dictionary Tables

Session 9: MAINTAIN A RECOVERY CATALOG

Reset Database Command

Change the Availability Status of Backups and Copies

Catalog Backups Made with Operating System Commands

Generate Reports and Lists

Configuration Values

Cross Check Backups and Copies

Delete Backups

Drop Database and Archival Backups

Course Contents – DAY 3

Session 10: RESTORE AND RECOVER WITH RMAN

Overview of Restore

The Restore Command

Restore a Database in Noarchivelog Mode

Restore and Recover a Database in Archivelog Mode

Incomplete Recovery using Until Time and Until Sequence

Restore and Recover a Tablespace

Automatic tempfile Recovery

Restore and Recover a Datafile

Recover a Datafile Not Backed Up

Recover Individual Data Blocks

Recover a Lost Redo Log Group

Re-create a Password Authentication File

Apply Incremental Backups to Restore Datafile Image Copies

The Switch command

The Data Recovery Advisor (DRA)

Restore and Recover the Database on a New Host

Session 11: CREATE A DUPLICATE DATABASE WITH RMAN

Overview of Database Duplication

Database Duplication

Duplication Options

Create Files for the Duplicate Database

Prepare an Auxiliary Instance for Duplication

Create a Duplicate Database

Clone a Running Database without a Backup

Targetless duplication of a database

Session 12: MANAGE SPACE FOR THE DATABASE

Transport Tablespaces

Transport Databases

Session 13: MONITOR, TUNE RMAN

Recovery Manager Tuning Overview

Tuning RMAN Backup Performance

Synchronous and Asynchronous I/O

Instance Recovery Performance Tuning

RMAN Messages

Troubleshoot RMAN

RMAN Detected Block Corruptions

Performance impact of MAXPIECESIZE, FILESPERSET, MAXOPENFILES and BACKUP DURATION

Course Contents – DAY 4

Session 14: FLASHBACK

Configure and Use Flashback Database

Monitor Flashback Database

Flash Recovery Area Space Usage

Flashback Query

Retrieve Row History with Flashback Versions Query

Audit or Recover from Transactions with Flashback Transactions Query

Flashback Table

Recover Dropped Tables with Flashback Drop

The Recycle Bin

Recover Tables to a Point in Time with Flashback Table

Flashback Database

Flashback Restore Points

Flashback Transaction Backout

Session 15: ORACLE TOTAL RECALL

Overview of Oracle Total Recall

Manage Flashback Archives

Flashback Data Archive and Auditing

Flashback Data Archive Uses

Session 16: AUTOMATE TASKS WITH THE SCHEDULER

Introduction to the Scheduler

Scheduler Related Parameters

Access Rights

Create and enable a Program

Drop a Program

Create a Schedule

Create a Job

Job Classes

Windows

Window Group

Monitoring and Logging

Use Time Based, Event Based and Complex Schedules

Multi Destination Jobs

Session 17: MANAGE SPACE IN SEGMENTS

Tablespace Monitoring

Segment Management Enhancements

Segment Advisor

Segment Space Estimation

Online Segment Shrink

Proactive Tablespace Management

Session 18: MANAGE SPACE IN BLOCKS

Free Space Management

Monitor Space

Compress Data

Course Contents – DAY 5

Session 19: MANAGE DATABASE PERFORMANCE

Tuning Activities

Use Statistic Preferences

Optimizer Statistics Collection

Monitor The Performance of Sessions And Services

Automatic Workload Repository (AWR)

The Benefits of Automatic Database Replay

Session 20: DATABASE PERFORMANCE BY SQL TUNING

Application and SQL Tuning

SQL Tuning Advisor

SQL Access Adviso

SQL Performance Analyzer

Session 21: OVERVIEW OF AUTOMATIC STORAGE MANAGEMENT

Overview of ASM

ASM Instance Creation

SYSASM Role

Administer ASM Disk Groups

ASM Files

ASM Startup and Shutdown

Asm Disk Failure

ASM Data Dictionary Views

Migrate a Database to ASM Using RMAN

The ASM Command Line Tool

Session 22: MANAGING RESOURCES WITH RESOURCE MANAGER

Overview of the Database Resource Manager

Create Resource Plans

Create Resource Consumer Groups

Create Resource Plan Directives

Limit CPU Utilization at the Database Level

Instance Caging

Control Resources by User Groups

Specify an Instance Plan

Monitor the Resource Manager

Data Dictionary Views

Duration: 5 Days

Cost: £2195 + VAT