Oracle Database 11g Release 2 DBA - Part II

Oracle Database 11g Release 2 DBA - Part II

5 days @ £1,945.00 exc. VAT 

Course Code: O11GDBAII

25 Years - The IT Training specialist

Upcoming Scheduled Events - next 12 months

Location Start Date Spaces Book
London 13 Nov 2017 Spaces StayAhead - Course Running Book
London 26 Feb 2018 Spaces StayAhead - Course Running Book
London 14 May 2018 Spaces StayAhead - Course Running Book
London 16 Jul 2018 Spaces StayAhead - Course Running Book
View Further Dates

Location Start Date Spaces Book
London 01 Oct 2018 Spaces StayAhead - Course Running Book

S8

Oracle Database 11g Release 2 DBA - Part II 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.

Skills Gained

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

Who will the Course Benefit?

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.

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.

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.

Requirements

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 Release 2 DBA - Part I courses. Knowledge of Oracle PL/SQL would be beneficial.


Oracle Database 11g Release 2 DBA - Part II Training Course

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

Oracle Database 11g Release 2 DBA - Part II Training Course

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

Oracle Database 11g Release 2 DBA - Part II Training Course

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

Oracle Database 11g Release 2 DBA - Part II Training Course

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

Oracle Database 11g Release 2 DBA - Part II Training Course

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
Home Let Us Call You Enquiry

Place A booking





Print Friendly



Course Reviews

Very enjoyable course with an excellent instructor with lots of real world experience to backup the course content with plenty of additional information to use once we are back in a production environment. I thoroughly enjoyed the course and will be recommending it to my colleagues

Ian - Systems and Infrastructure Manager - Storage - June 2017


The instructor was exceptional.

Josh - System Administrator - Government


A complex topic explained clearly and methodically at an easily digestible pace. Well done StayAhead.

Simon - Lead Application Specialist


More Course Reviews....

Good instruction. Instructor was flexible in what we asked for. Very pleased with course.

- Developer DBA - Government


Very good course, extremely knowledgeable tutors and good practical's to go with the tutor lead sections.

Peter - Transport


Good course, well delivered. Objectives met. Thankyou very much.

Matthew - assistant dba - IT


All Course Reviews....


StayAhead Promo 10


Oracle User Group - Membership Benefits

Oracle User Group - Membership Benefits

Course Certification

Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.

Programming, Java, Web Dev, SQL, NoSQL, MySQL & MariaDB

Linux, Red Hat, Oracle Linux, SUSE & LPI

UNIX, Solaris, AIX & HP-UX

UNIX 
AIX 
HP-UX 

GDPR, Business Analysis, ITIL & Prince2

See what our clients say . . .

Having previously undertaken a similar course in the past I expected this course to not be especially beneficial, however this was not the case at all. I have garnered some very useful new skills and knowledge. The trainer's subject knowledge and delivery are a credit to himself and Stayahead. I was constantly engaged and rarely found myself requiring a repeat of the coursework but when needed he was more than helpful in explaining where I was struggling.

Laurence - Operations Support - Finance - September 2017

More Reviews

+44 (0)20 7600 6116
Cookies Policy
Copyright © 2017 StayAhead Training Ltd
sales@stayahead.com