Oracle Database 11g

Oracle Database 11g

Oracle Database 11g:

The Oracle Database is the most flexible, scalable, reliable, fast and secure data management platform available in the market. Today’s Oracle Database offers more cost and performance management features than ever before, whether you run it in your data center on your hardware, run it Cloud at Customer, or run it in the Oracle Public Cloud.

Oracle Database Training will:

• Help you choose which deployment architecture works for your data management situation.
• Teach you the skills you need to install, configure, design and troubleshoot database systems.
• Demonstrate how to use advanced features or the Oracle Database to extend it for your data management solution.

Recommended Courses

Oracle Database 11g: Administration Workshop I Release 2

Learn To:

This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam.

Learn To:

• Install Oracle Grid Infrastructure.
• Create and manage users.
• Install and configure an Oracle Database.
• Create and manage storage structures.
• Administer the Oracle Database.
• Understand the Oracle database architecture and how its components work and interact with one another.
• Perform backup and recovery.

Benefits to You

• Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

Suggested Prerequisite

• Taken Oracle Introduction to SQL course or equivalent experience
• Taken Oracle PL/SQL course or equivalent experience


• Database Administrators
• Java Developers
• Support Engineer
• Technical Consultant
• Technical Administrator

Course Objectives

• Install and configure Oracle Database 11g
• Configure Oracle Net services
• Monitor and administer undo data
• Manage the database storage structures
• Create and administer user accounts
• Perform basic backup and recovery of a database
• Manage data concurrency
• Monitor performance
• Describe Oracle Database Architecture

Course Topics

Installing your Oracle Software

• Oracle Universal Installer (OUI)
• Installation: System Requirements
• Tools Used to Administer an Oracle Database
• Installing Oracle Grid Infrastructure
• Installing Oracle Database Software
• Tasks of an Oracle Database Administrator
• Silent Install

Creating an Oracle Database

• Planning the Database
• Password Management
• Using the DBCA to Create a Database
• Creating a Database Design Template
• Using the DBCA to Delete a Database

Managing the Oracle Database Instance

• Modify database installation parameters
• Describe database shutdown options
• Use Oracle Enterprise Manager
• Describe the stages of database startup
• Start and stop the Oracle database and components
• Access a database with SQLPlus
• View the alert log
• Access dynamic performance views

Manage the ASM Instance

• Set up initialization parameter files for ASM instance
• Administer ASM disk groups
• Start up and shut down ASM instances

Configuring the Oracle Network Environment

• Use Enterprise Manager to create and configure the Listener
• Identify when to use shared servers and when to use dedicated servers
• Enable Oracle Restart to monitor the listener
• Use tnsping to test Oracle Net connectivity

Managing Database Storage Structures

• Oracle Managed Files (OMF)
• Storage Structures
• Tablespaces in the Preconfigured Database
• Space Management in Tablespaces
• Actions with Tablespaces
• How Table Data Is Stored
• Anatomy of a Database Block

Administering User Security

• Benefits of Roles
• Predefined Administrative Accounts
• Implementing Profiles
• Predefined Roles
• Database User Accounts

Managing Data Concurrency

• Resolving Lock Conflicts
• Data Concurrency
• Deadlocks
• Enqueue Mechanism

Managing Undo Data

• Undo Data Versus Redo Data
• Data Manipulation
• Transactions and Undo Data
• Configuring Undo Retention

Implementing Oracle Database Auditing

• Enable standard database auditing
• Describe DBA responsibilities for security
• Review audit information
• Maintain the audit trail
• Specify audit options

Database Maintenance

• Use server-generated alerts
• Use automated tasks
• Manage the Automatic Workload Repository (AWR)
• Set alert thresholds
• Use the Automatic Database Diagnostic Monitor (ADDM)
• Describe and use the advisory framework
• Manage optimizer statistics

Performance Management

• Performance Monitoring
• Dynamic Performance Statistics
• Enabling Automatic Memory Management (AMM)
• Automatic Shared Memory Advisor
• Using Memory Advisors
• Troubleshooting and Tuning Views
• Invalid and Unusable Objects
• Managing Memory Components

Backup and Recovery Concepts

• Understanding Instance Recovery
• Statement Failure
• Phases of Instance Recovery
• Archive Log Files
• Media Failure
• Part of Your Job
• User Error
• Using the MTTR Advisor

Performing Database Backups

• Backup Solutions: Overview
• Monitoring the Flash Recovery Area
• Recovery Manager (RMAN)
• Terminology
• Configuring Backup Settings
• Backing Up the Control File to a Trace File
• User-Managed Backup
• Oracle Secure Backup

Performing Database Recovery

• Opening a Database
• Data Recovery Advisor Views
• Data Recovery Advisor
• Loss of a Control File
• Data Failures
• Loss of a Redo Log File
• Listing Data Failures

Moving Data

• Use SQL*Loader to move data
• Use external tables to move data
• Describe ways to move data
• Create and use directory objects
• Use Data Pump export and import to move data
• General architecture of Oracle Data Pump

Working with Support

• Use the Enterprise Manager Support Workbench
• Manage patches
• Work with Oracle Support
• Log service requests (SR)

Oracle Database 11g: Administration Workshop II Release 2

This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Learn To:

• Diagnose and repair data failures with Flashback technology.
• Manage space to optimize database storage so you can respond to growing space requirements.
• Monitor and manage major database components, including memory, performance and resources.
• Secure the availability of your database through appropriate backup and recovery strategies.
• Automate DBA tasks with the Scheduler.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

Backup & Recovery

The concepts and architecture that support backup and recovery, along with the steps required to execute it in various ways and situations, are covered in detail. You’ll learn how to define and test your own backup and recovery scenarios.

Manage Memory Effectively

You’ll also learn how to manage memory effectively, as well as how to perform some performance evaluation and tuning tasks. Instructors will review all types of flashback technologies, scheduling jobs inside and outside of the database and controlling system resource usage.

Course Requirements

This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led in class or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study and Knowledge Center courses DO NOT meet the Hands-on Requirement.

Suggested Prerequisite

• Oracle Database 11g Database Administration
• Working knowledge of SQL and how to use PL/SQL packages

Required Prerequisite

• Oracle Database 11g: Administration Workshop I Release 2
• Database Administrators
• Support Engineer
• Technical Consultant
• Technical Administrator

Course Objectives

• Configure the Oracle Database for optimal recovery
• Configure the database instance such that resources are appropriately allocated among sessions and tasks
• Schedule jobs to run inside or outside of the database
• Use compression to optimize database storage and duplicate a database
• Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
• Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
• Use an appropriate and flexible memory configuration for your database
• Identify burdensome database sessions and poorly performing SQL

Configuring for Recoverability

• Configuring Backup Retention
• Using the Recovery Manager (RMAN)
• Configuring Archivelog Mode
• Configuring your Database for B&R Operations
• Purpose of Backup and Recovery (B&R), Typical Tasks and Terminology
• Configuring and Using a Flash Recovery Area (FRA)

Using the RMAN Recovery Catalog

• Tracking and Storing Backup Information
• Using RMAN Stored Scripts
• Recording Backups
• Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop and Virtual Private Catalog)
• Setting up a Recovery Catalog

Configuring Backup Settings

• Configuring Autobackup of Control File
• Backup optimization
• Configuring Backup and Restore for Very Large Files (Multisection)
• Configuring and Managing Persistent Settings for RMAN
• Advanced Configuration Settings: Compressing Backups

Creating Backups with RMAN

• – Fast Incremental Backup
• Creating and Using the following:
• RMAN backup types
• – Whole Database Backup
• – Configure Backup Destinations
• – Archival Backups
• – Duplexed Backup Sets
• – Backup Sets and Image Copies

Restore and Recovery Task

• Re-creating a Password Authentication File
• Complete and Incomplete Recovery
• Causes of File Loss
• Restoring and Recovering
• Automatic Tempfile Recovery
• Other Recovery Operations
• Recovering from a Lost Index Tablespace
• Recovering from the Loss of a Redo Log Group

Using RMAN to Perform Recovery

• Recovering Image Copies and Switching Files
• Restore and Recovery of a Database in NOARCHIVELOG Mode
• Performing Recovery with a Backup Control File
• Restoring from Autobackup: Server Parameter File and Control File
• Incomplete Recovery
• Complete Recovery after Loss of a Critical or Noncritical Data File
• Restoring and Recovering the Database on a New Host

Monitoring and Tuning RMAN

• RMAN Multiplexing
• Balance Between Speed of Backup Versus Speed of Recovery
• Monitoring RMAN Jobs
• Synchronous and Asynchronous I/O

Diagnosing the Database

• Health Monitor
• Data Recovery Advisor (DRA)
• The ADR Command-Line Tool, ADRCI
• Block Corruption
• Automatic Diagnostic Repository (ADR)

Using Flashback Technology I

• Flashback Technology: Overview and Setup
• Flashback Table
• Using Flashback Technology to Query Data
• Performing Flashback Transaction Backout
• Flashback Transaction Query

Using Flashback Technology II

• Flashback Drop and the Recycle Bin
• Oracle Total Recall

Performing Flashback Database

• Configuring Flashback Database
• Monitoring Flashback Database
• Performing Flashback Database Operations

Managing Memory

• Oracle Database Memory Parameters
• Automatic Shared Memory Management
• Using Automatic Memory Management
• Using Data Dictionary Views
• Oracle Memory Structures
• Using Memory Advisors

Managing Database Performance

• Using Statistic Preferences
• Describing the Benefits of Database Replay
• Optimizer Statistics Collection
• Tuning Activities
• Automatic Workload Repository (AWR)
• Monitor the Performance of Sessions and Services

Managing Performance by SQL Tuning

• SQL Performance Analyzer Overview
• SQL Tuning and SQL Advisors
• SQL Access Advisor
• Using SQL Tuning Advisor

Managing Resources

• – Instance Caging
• Database Resource Manager: Overview and Concepts
• Accessing and Creating Resource Plans
• Activating a Resource Plan
• – Limiting CPU Utilization at the Database Level
• Creating Consumer Group
• Specifying Resource Plan Directives, including:
• Monitoring the Resource Manager

Automating Tasks with the Scheduler

• Simplifying Management Tasks
• Using Time-Based, Event-Based, and Complex Schedules
• Describing the Use of Windows, Window Groups, Job Classes, and Consumer Groups
• Creating a Job, Program, and Schedule
• Multi-Destination Jobs

Managing Space in Blocks

• Free Space Management
• Compressing Data
• Monitoring Space

Managing Space in Segments

• Additional Automatic Space-Saving Functionalit
• Managing Resumable Space Allocation
• Segment Advisor
• Shrinking Segments
• Segment Creation on Demand

Managing Space for the Database

• Using 4 KB-Sector Disks
• Transporting Databases
• Transporting Tablespaces

Duplicating a Database 

• Using RMAN to Create a Duplicate Database
• Targetless Duplicating a Database
• Duplicate a Database Based on a Running Instance
• Cloning a Database from a Backup
• Purpose and Methods of Cloning a Database