Oracle Database 11g Administration II & Backup and Recovery Workshop

Course:  OR11A2
Duration:  4 Days
Level:  II
Course Summary

This course provides follow on education for moderately experienced administration of the Oracle database. The course includes coverage of conceptual topics needed for more in-depth understanding of increasingly complex administrative tasks, extensive coverage of Oracle network interaction, specialized database structures, advanced administrative tools, and comprehensive backup and recovery strategies and methodologies.

Backup and recovery concepts are reviewed followed by in-depth coverage of user managed and RMAN backup and recovery techniques. Using Oracle Recovery Manger (RMAN) to perform backups (cold and hot) and database recoveries (complete and point in time ‘PITR’) are a primary focuses of the class.

The Oracle instance, background processes, the SGA and memory structures are explored.Various models of data concurrency and consistency and alternative isolation levels are explained along with their uses.

Oracle provides many, many network-centric features for configuring the database to make optimal use of a network and to provide custom quality of service. The high end options, configuration, optimization and ruggedization of the Oracle network interaction is given broad coverage.

Specialized database objects that serve as alternatives to traditional relational tables are reviewed as are their appropriate uses.

The many optional styles of indexes provided by Oracle are covered, with emphasis on the correct situations in which they can be deployed to best advantage.

In order to maximize Oracle’s delivery of services to various consumer groups and to regulate the regular execution of routine tasks, the Resource Manager and Oracle Scheduler are explained with numerous examples.

« Hide The Details
Topics Covered In This Course

Part 1 Oracle Architecture

  • The instance vs. the database
  • The System Global Area (SGA)
  • The critical background processes

Part 2 Concurrency and Consistency

  • What these two words mean
  • How Oracle manages concurrency and consistency
  • What part UNDO plays
  • Alternative isolation levels

Part 3 Oracle Net Services

  • Understanding client and server sessions
  • How TNS (Transparent Network Substrate) operates
  • Main components of Oracle Net Services
  • Managing the Oracle LISTENER
  • Configuring Oracle Net for security, redundancy and speed

Part 4 Alternative Data Types

  • DATEs, TIMESTAMPs and INTERVALs
  • The EXTRACT function
  • Persistent collections: VARRY and Nested Tables

Part 5 Table Alternatives

  • Global temporary tables
  • Materialized views
  • Index organized tables
  • External tables

Part 6 Advanced Indexing

  • Creating bitmap indexes
  • Creating function-based indexes
  • Creating reverse key indexes
  • Invisible indexes

Part 7 Database Resource Management

  • Understanding resource plans
  • Defining consumer groups
  • Creating plan directives
  • Advanced resource management techniques

Part 8 The Oracle Scheduler

  • Creating bitmap indexes
  • Creating function-based indexes
  • Creating reverse key indexes
  • Invisible indexes

Part 9 Database Startup and Shutdown

  • What happens at startup
  • The different startup modes
  • What happens at shutdown
  • The different shutdown options

Part 10 Database Backup and Recovery Concepts

  • Backup and recovery fundamentals
  • Types of backups
  • Recovery and restore

Part 11 User Managed Backup and Recovery

  • Performing cold complete database backups
  • Performing hot complete database backups
  • Performing full database recovery

Part 12 Segment and Block Storage Management

  • The structure of database blocks
  • Types of segments
  • The segment high water mark
  • Monitoring segment sizing

Part 13 Block Corruption Recovery

  • When bad things happen to good data blocks
  • Discovering and measuring block corruption
  • Block repair techniques
  • Row chaining

Part 14 Recovering from Non-Critical Losses

  • Sources of recovery for auxiliary files
  • Recovering a lost member of a multiplexed file
  • Recovering from the loss of all control files
  • What the ALERT LOG contains

Part 15 RMAN Overview

  • Working with the RMAN interface
  • Logging into RMAN
  • The recovery catalog

Part 16 Configuring RMAN

  • What RMAN ‘remembers’
  • Setting persistent RMAN parameters
  • Configuring and allocating a Fast Recovery Area
  • What the ALERT LOG contains

Part 17 RMAN Backup Management

  • Making disk image backups
  • Making recovery set backups
  • Full vs. incremental backups

Part 18 RMAN Recovery Techniques

  • Performing a full database recovery
  • Performing point in time recovery (PITR)
  • The implications of resetting logs
  • When to not use RMAN

Part 19 Flashback Techniques

  • Flashback query
  • Flashback table
  • Flashback drop
  • Flashback transaction
  • Flashback versions
  • Total Recall

Part 20 Flashback Database

  • Necessary pre-requisites
  • Estimating storage requirements for the fast recovery area
  • Full database recovery using FLASHBACK
What You Can Expect

This course provides follow on education for moderately experienced administration of the Oracle database. The course includes coverage of conceptual topics needed for more in-depth understanding of increasingly complex administrative tasks, extensive coverage of Oracle network interaction, specialized database structures, advanced administrative tools, and comprehensive backup and recovery strategies and methodologies.

Backup and recovery concepts are reviewed followed by in-depth coverage of user managed and RMAN backup and recovery techniques. Using Oracle Recovery Manger (RMAN) to perform backups (cold and hot) and database recoveries (complete and point in time ‘PITR’) are a primary focuses of the class.

This class provides preparation for the OCP Oracle Database 11g: Administration II 1Z0-053 test. Candidates are also required to complete at least one Oracle University class from a pre-defined list of classes relating to this particular exam. Oracle Corporation suggests that candidates also have six months of hands-on experience before testing and undertake substantial self-study.

Who Should Take This Course

Oracle developers and moderately experienced DBAs

Oracle developers and DBAs wishing to ‘back fill’ gaps in their expertise

Administrators responsible for performing or managing Oracle backup and recovery

Technical managers needing Oracle expertise for project administration

Recommended Prerequisites

Oracle Database 11g: Administration I

Oracle SQL Tuning

Oracle Database: SQL Fundamentals

Skill with GUI interfaces

Data processing background

An understanding of SQL is required to succeed in this class

Training Style

Instructor Led with 50% lecture and 50% lab.

« Hide The Details
Related Courses
Code Course Title Duration Level
OR18NEW
Oracle12c -18c New Features For Administrators
5 Days
I
Details
OBIAD
Oracle BI 11g - System Administration
4 Days
I
Details
OR11A1
Oracle Database 11g Administration I
5 Days
I
Details
OR1212NF
Oracle12c Release 1 & 2 New Features For Administrators
5 Days
I
Details
OR12NEW
Oracle12c New Features For Administrators
5 Days
II
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com